CTRL + D ? What does this do?

[gittar29]

Im doing some quick analysis on instructions for a client to produce a report. It instructs the person to fill the column with 00000000 and then hit CTRL + D. It switches everything to a single zero. I cannot figure out why they include this in their instructions.

Does anyone have any insight into what CTRL D does? It looks like it may be some kind of rounding function? Its not calling a macro b/c it manipulates data on clean sheets.

 

[Barrie Davidson]

CTRL+D is the shortcut for Fill Down.

Regards,

 

[Haluk]

Hi;

Ctrl + D is a shortcut for "Fill Down"

 

[gittar29]

AHH -

Yes I see now! I looked in the shortcut menu in the Help file, but couldn't find it referenced. Thanks.

 

[Ivan F Moala]

Here's a list.......also Look @ Chip's Site

http://www.cpearson.com/excel.htm

<META content=Excel.Sheet name=ProgId><META content="Microsoft Excel 9" name=Generator><LINK href="./sht_files/filelist.xml" rel=File-List><STYLE id="Excel Keyboard Shortcuts_7912_Styles"></STYLE>  <DIV id="Excel Keyboard Shortcuts_7912" align=center xublishsource="Excel"><TABLE class=xl227912 style="TABLE-LAYOUT: fixed; WIDTH: 616pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=819 border=0 x:str><COLGROUP><COL class=xl237912 style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3437" width=94><COL class=xl227912 style="WIDTH: 99pt; mso-width-source: userset; mso-width-alt: 4827" width=132><COL class=xl227912 style="WIDTH: 98pt; mso-width-source: userset; mso-width-alt: 4754" width=130><COL class=xl227912 style="WIDTH: 102pt; mso-width-source: userset; mso-width-alt: 4973" width=136><COL class=xl227912 style="WIDTH: 92pt; mso-width-source: userset; mso-width-alt: 4461" width=122><COL class=xl227912 style="WIDTH: 106pt; mso-width-source: userset; mso-width-alt: 5156" width=141><COL class=xl227912 style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD class=xl357912 style="WIDTH: 71pt; HEIGHT: 15.75pt" width=94 height=21>Key</TD><TD class=xl367912 style="WIDTH: 99pt" width=132>Alone</TD><TD class=xl367912 style="WIDTH: 98pt" width=130>Shift</TD><TD class=xl367912 style="WIDTH: 102pt" width=136>Ctrl</TD><TD class=xl367912 style="WIDTH: 92pt" width=122>Alt</TD><TD class=xl377912 style="WIDTH: 106pt" width=141>Shift Ctrl</TD><TD class=xl257912 style="WIDTH: 48pt" width=64> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>F1</TD><TD class=xl307912>Help</TD><TD class=xl327912 style="BORDER-LEFT: medium none">What's This Help</TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl307912>Insert Chart Sheet</TD><TD class=xl267912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>F2</TD><TD class=xl317912>Edit Mode</TD><TD class=xl337912 style="BORDER-LEFT: medium none">Edit Comment</TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl347912>Save As</TD><TD class=xl277912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>F3</TD><TD class=xl307912>Paste Name Formula</TD><TD class=xl327912 style="BORDER-LEFT: medium none">Paste Function</TD><TD class=xl327912 style="BORDER-LEFT: medium none">Define Name</TD><TD class=xl307912> </TD><TD class=xl267912>Names From Labels</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>F4</TD><TD class=xl317912>Repeat Action</TD><TD class=xl337912 style="BORDER-LEFT: medium none">Find Again</TD><TD class=xl337912 style="BORDER-LEFT: medium none">Close Window</TD><TD class=xl347912>Quit Excel</TD><TD class=xl277912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>F5</TD><TD class=xl307912>Goto</TD><TD class=xl327912 style="BORDER-LEFT: medium none">Find</TD><TD class=xl327912 style="BORDER-LEFT: medium none">Restore Window Size</TD><TD class=xl307912> </TD><TD class=xl267912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>F6</TD><TD class=xl317912>Next Pane</TD><TD class=xl337912 style="BORDER-LEFT: medium none">Prev Pane</TD><TD class=xl337912 style="BORDER-LEFT: medium none">Next Workbook</TD><TD class=xl347912>Switch To VBA</TD><TD class=xl277912>Prev Workbook</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>F7</TD><TD class=xl307912>Spell Check</TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none">Move Window</TD><TD class=xl307912> </TD><TD class=xl267912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>F8</TD><TD class=xl317912>Extend Selection</TD><TD class=xl337912 style="BORDER-LEFT: medium none">Add To Selection</TD><TD class=xl337912 style="BORDER-LEFT: medium none">Resize Window</TD><TD class=xl347912>Macro List</TD><TD class=xl277912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>F9</TD><TD class=xl307912>Calculate All</TD><TD class=xl327912 style="BORDER-LEFT: medium none">Calculate Worksheet</TD><TD class=xl327912 style="BORDER-LEFT: medium none">Minimize Workbook</TD><TD class=xl307912> </TD><TD class=xl267912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>F10</TD><TD class=xl317912>Activate Menu</TD><TD class=xl337912 style="BORDER-LEFT: medium none">Context Menu</TD><TD class=xl337912 style="BORDER-LEFT: medium none">Restore Workbook</TD><TD class=xl347912> </TD><TD class=xl277912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>F11</TD><TD class=xl307912>New Chart</TD><TD class=xl327912 style="BORDER-LEFT: medium none">New Worksheet</TD><TD class=xl327912 style="BORDER-LEFT: medium none">New Macro Sheet</TD><TD class=xl307912>VB Editor</TD><TD class=xl267912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>F12</TD><TD class=xl317912>Save As</TD><TD class=xl337912 style="BORDER-LEFT: medium none">Save</TD><TD class=xl337912 style="BORDER-LEFT: medium none">Open</TD><TD class=xl347912> </TD><TD class=xl277912>Print</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>A</TD><TD class=xl307912> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none" x:str="Select All ">Select All </TD><TD class=xl307912> </TD><TD class=xl267912>Formula Arguments</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>B</TD><TD class=xl317912> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none">Bold</TD><TD class=xl347912> </TD><TD class=xl277912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>C</TD><TD class=xl307912> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none">Copy</TD><TD class=xl307912> </TD><TD class=xl267912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>D</TD><TD class=xl317912> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none">Fill Down</TD><TD class=xl347912>Data Menu</TD><TD class=xl277912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>E</TD><TD class=xl307912> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl307912>Edit Menu</TD><TD class=xl267912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>F</TD><TD class=xl317912> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none">Find</TD><TD class=xl347912>File Menu</TD><TD class=xl277912>Font Name</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>G</TD><TD class=xl307912> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none">Goto</TD><TD class=xl307912> </TD><TD class=xl267912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>H</TD><TD class=xl317912> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none">Replace</TD><TD class=xl347912>Help Menu</TD><TD class=xl277912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>I</TD><TD class=xl307912> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none">Italics</TD><TD class=xl307912>Insert Menu</TD><TD class=xl267912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>J</TD><TD class=xl317912> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl347912> </TD><TD class=xl277912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>K</TD><TD class=xl307912> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none">Insert<SPAN style="mso-spacerun: yes">  </SPAN>Hyperlink</TD><TD class=xl307912> </TD><TD class=xl267912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>L</TD><TD class=xl317912> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl347912> </TD><TD class=xl277912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>M</TD><TD class=xl307912> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl307912> </TD><TD class=xl267912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>N</TD><TD class=xl317912> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none">New Workbook</TD><TD class=xl347912> </TD><TD class=xl277912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>O</TD><TD class=xl307912> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none">Open Workbook</TD><TD class=xl307912>Format Menu</TD><TD class=xl267912>Select Comments</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>P</TD><TD class=xl317912> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none">Print</TD><TD class=xl347912> </TD><TD class=xl277912>Font Size</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>Q</TD><TD class=xl307912> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl307912> </TD><TD class=xl267912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>R</TD><TD class=xl317912> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none">Fill Right</TD><TD class=xl347912> </TD><TD class=xl277912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>S</TD><TD class=xl307912> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none">Save</TD><TD class=xl307912> </TD><TD class=xl267912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>T</TD><TD class=xl317912> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl347912>Tools Menu</TD><TD class=xl277912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>U</TD><TD class=xl307912> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none">Underline</TD><TD class=xl307912> </TD><TD class=xl267912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>V</TD><TD class=xl317912> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none">Paste</TD><TD class=xl347912> </TD><TD class=xl277912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>W</TD><TD class=xl307912> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none">Close Workbook</TD><TD class=xl307912>Window Menu</TD><TD class=xl267912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>X</TD><TD class=xl317912> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none">Cut</TD><TD class=xl347912> </TD><TD class=xl277912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>Y</TD><TD class=xl307912> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none">Repeat Active</TD><TD class=xl307912> </TD><TD class=xl267912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>Z</TD><TD class=xl317912> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none">Undo</TD><TD class=xl347912> </TD><TD class=xl277912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>` (~)</TD><TD class=xl307912> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none">Toggle Formula View</TD><TD class=xl307912> </TD><TD class=xl267912>General Format</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>1 (!)</TD><TD class=xl317912> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none">Cell Format</TD><TD class=xl347912> </TD><TD class=xl277912>Number Format</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>2 (@)</TD><TD class=xl307912> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none">Toggle Bold</TD><TD class=xl307912> </TD><TD class=xl267912>Time Format</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>3 (#)</TD><TD class=xl317912> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none">Toggle Italics</TD><TD class=xl347912> </TD><TD class=xl277912>Date Format</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>4 ($)</TD><TD class=xl307912> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none">Toggle Underline</TD><TD class=xl307912> </TD><TD class=xl267912>Currency Format</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>5 (%)</TD><TD class=xl317912> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none">Toggle Strikethru</TD><TD class=xl347912> </TD><TD class=xl277912>Percent Format</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>6 (^)</TD><TD class=xl307912> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none">a</TD><TD class=xl307912> </TD><TD class=xl267912>Exponent Format</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>7 (&)</TD><TD class=xl317912> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none">a</TD><TD class=xl347912> </TD><TD class=xl277912>Apply Border</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>8 (*)</TD><TD class=xl307912> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none">Outline</TD><TD class=xl307912> </TD><TD class=xl267912>Select Region</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>9 (()</TD><TD class=xl317912> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none">Hide Rows</TD><TD class=xl347912> </TD><TD class=xl277912>Unhide Rows</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>0 ())</TD><TD class=xl307912> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none">Hide Columns</TD><TD class=xl307912> </TD><TD class=xl267912>Unhide Columns</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>-</TD><TD class=xl317912> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none">Delete Selection</TD><TD class=xl347912>Control Menu</TD><TD class=xl277912>No Border</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>= (+)</TD><TD class=xl307912>Formula</TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl307912>Auto Sum</TD><TD class=xl267912>Insert dialog</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>[</TD><TD class=xl317912> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none">Direct Dependents</TD><TD class=xl347912> </TD><TD class=xl277912>Direct Precedents</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>]</TD><TD class=xl307912> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none">All Dependents</TD><TD class=xl307912> </TD><TD class=xl267912>All Precedents</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>; (semicolon)</TD><TD class=xl317912> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none">Insert Date</TD><TD class=xl347912>Select Visible Cells</TD><TD class=xl277912>Insert Time</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>' (apostrophe)</TD><TD class=xl307912> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl307912>Style</TD><TD class=xl267912>Copy Cell Value Above</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>: (colon)</TD><TD class=xl317912> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none">Insert Time</TD><TD class=xl347912> </TD><TD class=xl277912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>/</TD><TD class=xl307912> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none">Select Array</TD><TD class=xl307912> </TD><TD class=xl267912>Select Array</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>\</TD><TD class=xl317912> </TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none">Select Differences</TD><TD class=xl347912> </TD><TD class=xl277912>Select Unequal Cells</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>Insert</TD><TD class=xl307912>Insert Mode</TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none">Copy</TD><TD class=xl307912> </TD><TD class=xl267912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>Delete</TD><TD class=xl317912>Clear</TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none">Delete To End Of Line</TD><TD class=xl347912> </TD><TD class=xl277912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>Home</TD><TD class=xl307912>Begin Row</TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none">Start Of Worksheet</TD><TD class=xl307912> </TD><TD class=xl267912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>End</TD><TD class=xl317912>End Row</TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none">End Of Worksheet</TD><TD class=xl347912> </TD><TD class=xl277912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>Page Up</TD><TD class=xl307912>Page Up</TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none">Previous Worksheet</TD><TD class=xl307912>Left 1 screen</TD><TD class=xl267912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>Page Down</TD><TD class=xl317912>Page Down</TD><TD class=xl337912 style="BORDER-LEFT: medium none"> </TD><TD class=xl337912 style="BORDER-LEFT: medium none">Next Worksheet</TD><TD class=xl347912>Right 1 screen</TD><TD class=xl277912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>Left Arrow</TD><TD class=xl307912>Move Left</TD><TD class=xl327912 style="BORDER-LEFT: medium none">Select Left</TD><TD class=xl327912 style="BORDER-LEFT: medium none">Move Left Area</TD><TD class=xl307912> </TD><TD class=xl267912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>Right Arrow</TD><TD class=xl317912>Move Right</TD><TD class=xl337912 style="BORDER-LEFT: medium none">Select Right</TD><TD class=xl337912 style="BORDER-LEFT: medium none">Move Right Area</TD><TD class=xl347912> </TD><TD class=xl277912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>Up Arrow</TD><TD class=xl307912>Move Up</TD><TD class=xl327912 style="BORDER-LEFT: medium none">Select Up</TD><TD class=xl327912 style="BORDER-LEFT: medium none">Move Up Area</TD><TD class=xl307912> </TD><TD class=xl267912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>Down Arrow</TD><TD class=xl317912>Move Down</TD><TD class=xl337912 style="BORDER-LEFT: medium none">Select Down</TD><TD class=xl337912 style="BORDER-LEFT: medium none">Move Down Area</TD><TD class=xl347912>Drop down list</TD><TD class=xl277912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>Space Bar</TD><TD class=xl307912>Space</TD><TD class=xl327912 style="BORDER-LEFT: medium none">Select Row</TD><TD class=xl327912 style="BORDER-LEFT: medium none">Select Column</TD><TD class=xl307912>Control Box</TD><TD class=xl267912>Select All</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl287912 style="HEIGHT: 12.75pt" height=17>Tab</TD><TD class=xl317912>Move Right</TD><TD class=xl337912 style="BORDER-LEFT: medium none">Move Left</TD><TD class=xl337912 style="BORDER-LEFT: medium none">Next Window</TD><TD class=xl347912>Next Application</TD><TD class=xl277912>Previous Window</TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl297912 style="HEIGHT: 12.75pt" height=17>BackSpace</TD><TD class=xl307912> </TD><TD class=xl327912 style="BORDER-LEFT: medium none"> </TD><TD class=xl327912 style="BORDER-LEFT: medium none">Goto Active Cell</TD><TD class=xl307912> </TD><TD class=xl267912> </TD><TD class=xl257912> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl247912 style="HEIGHT: 12.75pt" height=17> </TD><TD class=xl257912> </TD><TD class=xl257912> </TD><TD class=xl257912> </TD><TD class=xl257912> </TD><TD class=xl257912> </TD><TD class=xl257912> </TD></TR></TBODY></TABLE></DIV>

 

[wamjr1]

It isn't completely clear from the above discussion, but the way this works in its simplest way is to type what you want in the top cell (say B2), then highlight this cell AND all the cells below it where you want that entry filled. Then press ctrl-D. Here is one additional feature that makes this key-stroke very powerful on big spreadsheets. If you want to fill say cells B2 through B10012, this would take a long time to drag. Instead you can type in that little area to the left of the formula line B2:B10012. This will select the whole column. Then press Ctrl D to fill it down.