CTRL+D is the shortcut for Fill Down.
This is a discussion on CTRL + D ? What does this do? within the Excel Questions forums, part of the Question Forums category; Im doing some quick analysis on instructions for a client to produce a report. It instructs the person to fill ...
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.
CTRL+D is the shortcut for Fill Down.
"You're only given a little spark of madness. You mustn't lose it." - Robin Williams
Ctrl + D is a shortcut for "Fill Down"
Yes I see now! I looked in the shortcut menu in the Help file, but couldn't find it referenced. Thanks.
Here's a list.......also Look @ Chip's Site
****** content=Excel.Sheet name=ProgId>****** content="Microsoft Excel 9" name=Generator>**
Key Alone Shift Ctrl Alt Shift Ctrl * F1 Help What's This Help * Insert Chart Sheet * * F2 Edit Mode Edit Comment * Save As * * F3 Paste Name Formula Paste Function Define Name * Names From Labels * F4 Repeat Action Find Again Close Window Quit Excel * * F5 Goto Find Restore Window Size * * * F6 Next Pane Prev Pane Next Workbook Switch To VBA Prev Workbook * F7 Spell Check * Move Window * * * F8 Extend Selection Add To Selection Resize Window Macro List * * F9 Calculate All Calculate Worksheet Minimize Workbook * * * F10 Activate Menu Context Menu Restore Workbook * * * F11 New Chart New Worksheet New Macro Sheet VB Editor * * F12 Save As Save Open * * A * * Select All * Formula Arguments * B * * Bold * * * C * * Copy * * * D * * Fill Down Data Menu * * E * * * Edit Menu * * F * * Find File Menu Font Name * G * * Goto * * * H * * Replace Help Menu * * I * * Italics Insert Menu * * J * * * * * * K * * Insert* Hyperlink * * * L * * * * * * M * * * * * * N * * New Workbook * * * O * * Open Workbook Format Menu Select Comments * P * * * Font Size * Q * * * * * * R * * Fill Right * * * S * * Save * * * T * * * Tools Menu * * U * * Underline * * * V * * Paste * * * W * * Close Workbook Window Menu * * X * * Cut * * * Y * * Repeat Active * * * Z * * Undo * * * ` (~) * * Toggle Formula View * General Format * 1 (!) * * Cell Format * Number Format * 2 (@) * * Toggle Bold * Time Format * 3 (#) * * Toggle Italics * Date Format * 4 ($) * * Toggle Underline * Currency Format * 5 (%) * * Toggle Strikethru * Percent Format * 6 (^) * * a * Exponent Format * 7 (&) * * a * Apply Border * 8 (*) * * Outline * Select Region * 9 (() * * Hide Rows * Unhide Rows * 0 ()) * * Hide Columns * Unhide Columns * - * * Delete Selection Control Menu No Border * = (+) Formula * * Auto Sum Insert dialog * [ * * Direct Dependents * Direct Precedents * ] * * All Dependents * All Precedents * ; (semicolon) * * Insert Date Select Visible Cells Insert Time * ' (apostrophe) * * * Style Copy Cell Value Above * : (colon) * * Insert Time * * * / * * Select Array * Select Array * \ * * Select Differences * Select Unequal Cells * Insert Insert Mode * Copy * * * Delete Clear * Delete To End Of Line * * * Home Begin Row * Start Of Worksheet * * * End End Row * End Of Worksheet * * * Page Up Page Up * Previous Worksheet Left 1 screen * * Page Down Page Down * Next Worksheet Right 1 screen * * Left Arrow Move Left Select Left Move Left Area * * * Right Arrow Move Right Select Right Move Right Area * * * Up Arrow Move Up Select Up Move Up Area * * * Down Arrow Move Down Select Down Move Down Area Drop down list * * Space Bar Space Select Row Select Column Control Box Select All * Tab Move Right Move Left Next Window Next Application Previous Window * BackSpace * * Goto Active Cell * * * * * * * * * *
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.