Paste a Formula in Excel Down a Column: Step-by-Step

Formulas & functions · Updated November 20, 2026

To paste a formula down a column in Excel, enter it in the first cell, select that cell and the cells below where you want the results, then press Ctrl+D on Windows. You can also drag the fill handle or copy and paste the formula. Excel adjusts relative cell references as it fills, so each row can calculate using its own data.

What You’ll Need

  • An Excel workbook with the data your formula should use.
  • A formula entered in the first cell of the column you want to fill.
  • A clear idea of which rows should receive the formula. Check that the destination cells can be overwritten.

The steps below are for Excel for Microsoft 365 on Windows. The same fill handle and ribbon options are available in Excel for Mac and Excel for the web, although keyboard shortcuts can differ. If the workbook is shared or important, save it before making a large change.

Step-by-Step

  1. Choose the result column. Decide where the calculated values belong and check that the cells below the starting point are available. For example, if the results go in column D, confirm that filling D2:D20 will not replace notes or existing values. If you are unsure, use an empty column or save a copy of the workbook first.
  2. Enter the formula in the first row. For this example, the cell layout is quantities in B2:B5, unit prices in C2:C5, and line totals in D2:D5. Enter =B2*C2 in D2. If B2 contains 3 and C2 contains 12, the result in D2 is 36, because 3 multiplied by 12 equals 36. Press Enter to calculate it.
  3. Check the first result. Before filling several rows, confirm that the result makes sense and that the formula refers to the intended cells. Select D2 and look at the formula bar to review the formula. If the first row is wrong, correct it before copying; filling a wrong formula down would repeat the problem throughout the column.
  4. Select the range to fill. Click D2, then drag down to the last destination cell, such as D5. The selection must include the cell containing the formula at the top as well as the blank cells below it. You can also click D2, hold Shift, and click D5. For a long range, click the Name Box to the left of the formula bar, type D2:D500, and press Enter.
  5. Fill the selected cells. On Windows, press Ctrl+D. Excel copies the top cell’s formula down through the rest of the selected range. Alternatively, use Home > Fill > Down on the ribbon. On Mac, use Command+D when that shortcut is available, or choose Home > Fill > Down. In Excel for the web, the ribbon command or fill handle is a straightforward option if a browser shortcut behaves differently.
  6. Inspect the copied formulas and results. Click a lower result cell, such as D5, and check the formula bar. Excel should have adjusted the row references for that row. Confirm that the displayed result is plausible and that the range ends at the intended row. If a row is missing or an extra row was filled, undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then select the correct range and repeat.
  7. Use the fill handle as an alternative. Select D2 and point to the small square at the lower-right corner of its cell border. When the pointer becomes a thin black plus sign, drag the handle down to the final row. Release the mouse to fill the formula. If the column beside the formula contains a continuous list of data, double-clicking the fill handle may fill down to the end of that adjacent list; check where Excel stops, because gaps or blank neighboring cells can affect the result.
  8. Use copy and paste when convenient. Select the formula cell and press Ctrl+C on Windows, select the destination cells below it, and press Ctrl+V. On Mac, use Command+C and Command+V. Copying into a selected vertical range fills that range with adjusted formulas. If you only want to copy the formula and not its formatting, use the paste options that appear after pasting and choose the formulas option, if shown.

Common Mistakes

Selecting only the blank cells: Ctrl+D uses the top cell of the selection as the source. If the selection begins below the formula cell, Excel may fill from the wrong cell or have no intended formula to copy. Include the original formula cell at the top of the selected range.

Filling too far: A drag can continue past the last row you need, and a double-click can follow adjacent data farther than expected. Check the selected range before using Ctrl+D, then review the final filled row afterward. If extra cells were changed, use Undo before doing other edits.

Overwriting existing information: Fill Down replaces the contents of destination cells. It does not automatically protect existing values or formulas. Inspect the destination range first, and avoid selecting cells that contain data you need to keep.

Assuming every reference should move: Excel normally adjusts relative references as it fills. That is usually right when each row should use its own inputs, but a formula may also need to keep referring to a particular fixed cell. If a reference should stay fixed, edit the original formula to use an absolute reference before filling, or review the copied formulas afterward.

Mixing formulas with typed values: A column can look consistent while some cells are numbers typed by hand rather than formulas. When troubleshooting, click several cells and inspect the formula bar instead of judging by appearance alone.

Tips

For a short range, dragging the fill handle is easy to see and control. For a long or precisely defined range, selecting the first and last cells and using Ctrl+D is often more predictable. You can use the Name Box to select a range by its address rather than scrolling through hundreds of rows.

When you fill a formula, ordinary relative references change row by row. A fixed reference stays pointed at the same cell when it is written as an absolute reference with dollar signs. If you need a mix of changing and fixed references, check the formula in the first row carefully before filling. Press F4 while editing a cell reference to cycle through reference styles in Windows Excel; on some laptops you may need Fn+F4. On Mac, the shortcut can depend on keyboard settings, so typing the dollar signs directly is a reliable alternative.

If you expect to keep adding records, format the data range as an Excel table using Home > Format as Table. When you enter a formula in a table column, Excel can fill it through the other rows in that calculated column and apply it to new rows. Tables also make it easier to keep related data together, but check the result after converting a range because table behavior may differ from filling a fixed block.

Keep formulas and their source data aligned by using one row per record and clear column headings. Before sharing a workbook, consider whether recipients need formulas or just final values; if you replace formulas with values, you will no longer get recalculated results when source data changes.

Troubleshooting

Ctrl+D does nothing or fills the wrong cells: Confirm that the formula cell is the top cell in the selected range and that the range extends downward. Select the source and destination together, then use Home > Fill > Down. If the ribbon command is unavailable, check that you are editing a cell rather than a dialog or protected area.

Every copied row shows the same result: Select a few filled cells and inspect their formulas. The references may have been made absolute, so they keep pointing at the same source cells, or the formula may use fixed values. If each row should use different inputs, adjust the references in the first formula and fill again. If only one reference should stay fixed, lock only that reference rather than the whole formula.

The cells show the formula instead of a result: Check whether the cells are formatted as Text. Change the cells to General using Home > Number Format, then re-enter the formula in the first cell and fill again. Also check whether Show Formulas is enabled; pressing Ctrl+` on Windows toggles formula display in many Excel installations. The backtick key is usually near the top-left of the keyboard. If the formula begins with an apostrophe, remove it and re-enter the formula.

The result is unexpected or an error appears: Review the first formula’s cell references and verify that the source cells contain the expected values. Look for blank cells, text stored where numbers are expected, or a range that stops before the needed data. Fix the original formula first, then refill the range. If the destination contains a mix of old values and new formulas, decide which cells should be formulas and fill only those rows.

The fill handle is missing: In the Windows desktop app, open File > Options > Advanced and check that Enable fill handle and cell drag-and-drop is selected under Editing options. On Mac, check Excel > Settings or Preferences for editing options, as the wording and location can vary by release. You can still use Home > Fill > Down if the handle is disabled.

Frequently Asked Questions

Does Excel change the cell references when I fill down?

Yes. Relative references normally adjust to the new row as the formula is filled. Absolute references stay fixed, while mixed references lock either the row or the column. Review a lower cell’s formula bar to confirm the change is what you intended.

What is the fastest way to fill a formula down a large range?

Select the formula cell and the full destination range, then press Ctrl+D on Windows. On Mac, Command+D is the usual equivalent. If you know the range address, enter it in the Name Box to select it quickly before filling.

Can I fill a formula down without copying the formatting?

Yes. After using copy and paste, open the paste options and choose the option for formulas, if it appears. You can also use Home > Fill > Down, which fills the selection from its top cell. Check the result if your sheet uses special number formats or styles.

Can Excel fill the formula automatically for new rows?

Often, yes, when the data is formatted as an Excel table. A formula entered in a table column can populate the other rows in that column, and Excel can extend it to added rows. If it does not, check the table range and enter or copy the formula into the table column.

How do I fill a formula upward or across instead?

Select the range with the source formula at the bottom and use Home > Fill > Up to fill upward. To fill across columns, select the source cell and destination cells in the same row, then choose Home > Fill > Right. Check that the formula references should shift in that direction.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.