1. Computing

Excel Fill Down Command

An Excel Keyboard Shortcut

By

Use the Fill Down Command with a Keyboard Shortcut

Use the Fill Down Command with a Keyboard Shortcut

© Ted French

If you need to input the same data - text or numbers - into a number of adjacent cells in a column, the Fill Down command can quickly do this for you by just using the keyboard.

This Excel tip shows you how to apply the Fill Down command in an Excel spreadsheet using a keyboard shortcut.

The key combination that applies the Fill Down command is:

  • Ctrl + D

Example: Using Fill Down with a Keyboard Shortcut

For help with this example, see the image above.

  1. Type a number, such as 395.54 into cell D1 in Excel.

  2. Press and hold down the Shift key on the keyboard

  3. Press and hold down the Down Arrow key on the keyboard to extend the cell highlight from cell D1 to D7.

  4. Release both keys.

  5. Press and hold down the Ctrl key on the keyboard.

  6. Press and release the " D " key on the keyboard.

  7. Cells D2 to D7 should now be filled with the same data as cell D1.

Other Keyboard Shortcuts

©2014 About.com. All rights reserved.