This article shows how to activate the Fill Down command with a keyboard or mouse shortcut in Excel 2019, 2016, 2013, 2010, Excel Online, and Excel for Mac.

What to Know

  • Select the source cell. Then, highlight the range to which you want to copy it and press Ctrl+D.Alternatively, click the fill handle in the source cell and drag it over the target cells.

The Keyboard Method

The key combination that applies the Fill Down command is Ctrl+D.

Follow these steps to see how to use Fill Down in your own Excel spreadsheets:

  • Type a number into a cell.
  • Press and hold the Shift key.
  • Press and hold the Down Arrow key on the keyboard to extend the cell highlight from cell D1 to D7. Then release both keys.
  • Press and Ctrl+D and release.
  • The Mouse Method
  • Use your mouse to select the cell that contains the number that you want to duplicate in the cells beneath it. Then, highlight the range to which you want to copy it, and press the keyboard shortcut Ctrl+D .
  • Alison Czinkota / Lifewire
  • Use AutoFill to Duplicate the Data in a Cell
  • Here’s how to accomplish the same effect as the Fill Down command, but instead with the AutoFill feature:
  • Type a number into a cell in an Excel spreadsheet.
  • Click and hold the fill handle in the bottom right corner of the cell that contains the number.
  • Drag the fill handle downward to select the cells that you want to contain the same number.
  • Release the mouse and the number is copied into each of the selected cells.

The AutoFill feature also works horizontally to copy a number of adjacent cells in the same row. Just click and drag the fill handle across the cells horizontally. When you release the mouse, the number is copied into each selected cell.

Type a number into a cell.

Press and hold the Shift key.

Press and hold the Down Arrow key on the keyboard to extend the cell highlight from cell D1 to D7. Then release both keys.

Press and Ctrl+D and release.

The Mouse Method

Use your mouse to select the cell that contains the number that you want to duplicate in the cells beneath it. Then, highlight the range to which you want to copy it, and press the keyboard shortcut Ctrl+D .

Use AutoFill to Duplicate the Data in a Cell

Here’s how to accomplish the same effect as the Fill Down command, but instead with the AutoFill feature:

Type a number into a cell in an Excel spreadsheet.

Click and hold the fill handle in the bottom right corner of the cell that contains the number.

Drag the fill handle downward to select the cells that you want to contain the same number.

Release the mouse and the number is copied into each of the selected cells.

Get the Latest Tech News Delivered Every Day