What fill down does and when you need it

Fill down copies the content of a cell (or cells) downward to fill a range you select. In Excel, it saves you from typing the same formula, number, or text into dozens of rows by hand. When you fill down a formula, Excel automatically adjusts the cell references so each row calculates based on its own data.

You use fill down constantly in spreadsheets. If you have a formula in one cell that calculates a total, a percentage, or a date, and you need that same calculation in the rows below, fill down does it in seconds. It also works for plain text or numbers — if you need the same value repeated down a column, fill down handles that too.

Key Takeaways

  • Select the cell with the content you want to copy, then extend your selection down to include all the cells where you want that content to go.
  • Press Ctrl+D on Windows or Cmd+D on Mac to fill down when ready.
  • When you fill down a formula, Excel changes the row numbers in the formula automatically — so a formula referencing row 2 becomes row 3, row 4, and so on as it fills down.
  • You can also use the fill handle (the small square at the bottom right of a selected cell) to drag down and fill, which works the same way.
  • Fill down only works downward; to copy across columns, use fill right instead.

The keyboard shortcut method (fastest)

The quickest way to fill down is with the keyboard. Click the cell that contains what you want to copy. Then hold Shift and click the last cell in the range where you want the content to go. This selects all the cells from your starting point down to that final cell.

Once your range is selected, press Ctrl+D if you are on Windows, or Cmd+D if you are on a Mac. The content fills down when ready to every cell in your selection. The formula adjusts automatically for each row.

This method is reliable and works the same way in every version of Excel. It is also the fastest once you remember the shortcut.

Using the fill handle to drag down

The fill handle is the small square at the bottom right corner of a selected cell. When you hover your cursor over it, the cursor changes to a small plus sign. You can click and drag this handle downward to fill the cells below.

Click the cell with your content, then position your cursor exactly on the small square at the bottom right. Click and hold, then drag downward as far as you need. As you drag, Excel shows you a preview of how many rows you are filling. Release the mouse button when you reach the last row you need.

The drag method works well when you can see the destination on your screen. If you need to fill down 500 rows and your screen only shows 30, the keyboard shortcut is faster because you can type the cell address instead of scrolling.

How Excel adjusts formulas when you fill down

When you fill down a formula, Excel treats most cell references as relative by default. That means the row number changes as the formula copies down. If your original formula in row 2 says =A2*B2, then row 3 will get =A3*B3, row 4 will get =A4*B4, and so on.

Sometimes you do not want a reference to change. If you have a formula that always needs to reference a single cell (like a tax rate in cell E1), you can lock that reference by typing a dollar sign before the column letter and row number: =$E$1. When you fill down, that reference stays the same while the others adjust.

For example, if your formula is =A2*$E$1, filling down gives you =A3*$E$1, then =A4*$E$1, and so on. The A reference changes (relative), but the E1 reference does not (absolute).

Filling down text and numbers (not formulas)

Fill down works exactly the same way for plain text or numbers as it does for formulas. If you type a name in one cell and want it repeated down a column, select that cell, extend your selection downward, and press Ctrl+D (or Cmd+D on Mac).

The same rule applies: select the cell with the content, then select all the way down to where you want it to stop. Fill down copies it to every cell in between. This is useful for filling in a category name, a date, or any value that should repeat.

What to do if fill down does not work as expected

The most common problem is selecting the wrong range. Make sure your starting cell (the one with the content you want to copy) is included in your selection. If you select only the empty cells below, there is nothing to fill down from.

Another issue is merged cells. If any cells in your range are merged, fill down may not work or may behave unexpectedly. Unmerge the cells first, fill down, then merge again if you need to.

If a formula fills down but the results look wrong, check whether you meant to use an absolute reference (with dollar signs). A formula that references the wrong row for each calculation will give you incorrect numbers, even though the fill down itself worked correctly.

Fill down versus fill right and other fill options

Excel has several fill directions. Fill down copies downward (Ctrl+D). Fill right copies across columns to the right (Ctrl+R). Both work the same way: select your range with the source cell included, then use the shortcut.

You can also access fill options through the menu. Select your range, then go to Home > Fill (in the Editing group) and choose Down, Right, Up, or Left. The menu also has options like Fill Series (for counting sequences) and Flash Fill (which tries to detect a pattern and complete it for you), but these are less common.

For most spreadsheet work, fill down and fill right handle what you need. The keyboard shortcuts are faster than the menu.

Frequently Asked Questions

Can I fill down multiple columns at once?

Yes. Select all the cells you want to copy (across multiple columns), then extend your selection downward to include all the rows where you want them to go. Press Ctrl+D, and Excel fills down each column independently, adjusting formulas as it goes.

What happens if I fill down over cells that already have content?

Fill down overwrites whatever is in those cells. If you are not sure, you can undo with Ctrl+Z. There is no warning before it happens, so be careful with your selection.

Does fill down work the same way in Google Sheets?

Google Sheets uses the same keyboard shortcut (Ctrl+D on Windows, Cmd+D on Mac) and the same fill handle drag method. The behavior is nearly identical, though Google Sheets also has an autofill feature that sometimes suggests patterns as you type.

Can I fill down a formula that references cells in a different sheet?

Yes. If your formula references another sheet (like =Sheet2!A2*B2), fill down adjusts the row numbers the same way it does for cells in the current sheet. The sheet name stays the same, but the cell references change.

What is the difference between fill down and copy-paste?

Fill down is faster and requires fewer steps. Copy-paste gives you more control — you can copy from one place and paste to a non-contiguous range. For filling a contiguous range directly below your source cell, fill down is simpler.