How to Copy a Formula Down an Entire Column in Excel

To copy 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 choose Home > Fill > Down or press Ctrl+D on Windows. For a shorter range, drag the fill handle at the cell’s lower-right corner. Excel adjusts relative cell references as the formula fills, so each row can calculate using its own data.

Before filling, make sure the formula works in its first row and decide how far down it should go. This guide covers Microsoft Excel for Microsoft 365 on Windows, including the fill handle, double-click, keyboard, and copy-and-paste methods. Mac and Excel for the web differences are noted where they matter.

What You’ll Need

An Excel workbook with the formula already entered in the first cell of the column you want to fill.
Rows of data, or a clear destination range, so you can tell how far the formula should extend.
Permission to edit the workbook. If the sheet is protected, you may need the owner to unlock the relevant cells.

You do not need a special add-in or a particular Excel setting. If your data is an Excel Table, you can also use its calculated-column behavior, described below.

Step-by-Step

Check the data and choose the destination range. Identify the first formula cell and the last row that should receive a formula. For example, you might have quantities in A2:A4, prices in B2:B4, and want totals in column C. Avoid selecting the entire column unless you intentionally want formulas in every row; filling over a million rows can make a workbook larger and slower. Leave headers and any summary rows out of the destination range.
Enter and check the first formula. With quantities in A2:A4, prices in B2:B4, and the first total to calculate in C2, enter =A2*B2 in C2. If A2 contains 3 and B2 contains 12, the displayed result should be 36. Confirm that the formula bar shows a formula and that the result is plausible before copying it. A typo or incorrect starting reference will be repeated throughout the filled range.
Use the fill handle for a small or visible range. Click the formula cell, such as C2. Move the pointer to the tiny square at the lower-right corner of the selected cell until the pointer changes to a small black plus sign. Click and hold, then drag down to the final destination cell, such as C4. Release the mouse button. Excel fills the selected cells with copies of the formula. Check the last row to confirm the range ends where you intended.
Double-click the fill handle when adjacent data marks the endpoint. Select the formula cell and double-click its fill handle. Excel usually fills the formula down alongside a continuous neighboring data range. This is convenient for a long list, but it depends on the nearby column: a blank cell may cause the fill to stop early, while another continuous block may make the fill continue farther than expected. Inspect the final filled row and undo immediately with Ctrl+Z if the endpoint is wrong. On Mac, use Command+Z to undo.
Select the range and use Fill Down for precise control. Click the formula cell, then select it and all the cells below that should contain the formula. You can drag over the range, or click the Name Box to the left of the formula bar, type a range such as C2:C4, and press Enter. On the ribbon, choose Home > Fill > Down. Excel copies the top cell’s formula through the selected range. On Windows, Ctrl+D performs the same Fill Down action when the range is selected. On Mac, Control+D is the Fill Down shortcut in Excel; if the shortcut does not work with your keyboard setup, use Home > Fill > Down.
Copy and paste when you need a familiar alternative. Select the formula cell and press Ctrl+C on Windows, select the destination range, then press Ctrl+V. On Mac, use Command+C and Command+V. Copying the formula cell into a multi-cell selection fills that selection. This method can also copy formatting, depending on how you paste. If you want to copy only the calculation, use the paste options button after pasting and choose Formulas, or use Paste Special and select Formulas where available.
Verify the copied formulas and results. Click a cell near the bottom of the filled range and inspect the formula bar. In the example, the row 3 formula should refer to A3 and B3, and the row 4 formula should refer to A4 and B4. If A3 is 5 and B3 is 12, the result should be 60; if A4 is 2 and B4 is 15, the result should be 30. These checks show that the formula moved with the rows rather than repeating the first row’s calculation.

Using an Excel Table: If your data is formatted as a Table, adding a formula to a cell in a table column commonly fills the formula through that calculated column automatically. To make a table, select the data and choose Insert > Table, then confirm whether the data has headers. Add the formula in the first data row of the intended column. Table behavior can be controlled by Excel’s calculated-column settings, so if it does not fill automatically, use the fill handle or Fill Down method above. Avoid adding a formula to a header cell.

Common Mistakes

Filling too far or not far enough. Dragging is easy to misjudge, and double-clicking follows nearby data rather than your intention. Select an exact range with the Name Box or inspect the last filled row before relying on the results.
Using fixed references when you meant to use changing ones. Excel normally adjusts relative references as a formula moves. But references containing dollar signs are absolute or partly absolute and may stay anchored. This is useful for a constant such as a tax rate stored in one cell, but can produce repeated results if you did not mean to lock a reference. Review the formula in a lower row before filling a large range.
Overwriting existing entries. Fill Down replaces the contents of the selected cells with copies of the top cell. Check the destination range for notes, manually entered values, or other formulas first. If those cells matter, save a separate copy or choose a range that does not include them.
Expecting copied formulas to display results immediately. A cell may display the formula text rather than its calculated value if it is formatted as Text, or if Show Formulas is enabled. Also, calculation may be set to manual. These are different issues from the fill operation itself; see Troubleshooting for checks.
Copying formatting unintentionally. Regular copy and paste can bring the source cell’s formatting along with its formula. If the destination has a specific number format or color, use Fill Down, choose Formulas from paste options, or restore the intended formatting after filling.

Tips

Use the shortcut for a known range. Selecting the source cell at the top and the intended cells below before pressing Ctrl+D is often quicker and more precise than dragging. The source cell must be part of the selection and should be at its top.
Understand reference behavior before filling. Relative references change as formulas move; absolute references stay fixed; mixed references lock only a row or a column. This matters when a calculation combines row-by-row data with a shared rate, target, or assumption. Test a copied formula in one row before filling hundreds of rows.
Use Tables for lists that grow. A calculated column can extend the formula as you add rows to a Table, reducing the need to repeat the fill operation. Tables also make it easier to work with structured lists. Check that new rows are actually inside the Table and that the calculated column is behaving consistently.
Keep a clear stopping point. If the neighboring data has blank rows, double-clicking may stop at the first break. For lists with gaps, select the destination range directly rather than relying on automatic detection.
Save before a large fill. A quick save gives you a recovery point before changing many cells. Ctrl+S saves on Windows; Command+S saves on Mac. If the result is wrong, Ctrl+Z on Windows or Command+Z on Mac will usually undo the fill, as long as you have not closed the workbook or performed actions that prevent undo.

Troubleshooting

The fill handle is missing. In Excel for Microsoft 365 on Windows, open File > Options > Advanced. Under Editing options, check Enable fill handle and cell drag-and-drop, then choose OK. If the worksheet is protected or the workbook is in a restricted editing state, some actions may also be unavailable. On Mac, check Excel > Settings or Preferences for the editing options; labels can vary by release.

Double-click fills only a few rows. Excel uses neighboring data to determine how far to fill. Look for blank cells in that adjacent column. Select the formula cell and the intended destination range yourself, then use Home > Fill > Down or the keyboard shortcut instead.

The formula repeats the same result or points to the wrong cells. Click a filled cell and inspect its references in the formula bar. Check whether dollar signs have locked a row or column that should change, or whether the formula was entered as text. If the first formula is wrong, correct it and refill the range. If you need to keep existing destination values, do not refill over them without first preserving a copy.

The cell shows formula characters instead of a result. First check whether the cell is formatted as Text. Change its number format to General, then re-enter the formula by selecting the cell, pressing F2, and pressing Enter. Also check whether Show Formulas is on: on Windows, press Ctrl+` (the grave accent key, commonly beneath Esc) to toggle it. The shortcut can differ on some keyboards; the Formulas tab also has a Show Formulas control. If formulas appear but results do not update, choose Formulas > Calculation Options > Automatic, then recalculate.

The formula will not fill because Excel blocks editing. Check for a protected worksheet, a merged destination cell, or a selection that includes cells outside the editable range. Unmerge cells if appropriate, select a consistent range, or ask the workbook owner to allow editing. In Excel for the web, the Home tab and Fill options may appear in a compact ribbon; if a command is not visible, use the search box to find Fill Down or use the fill handle.

Frequently Asked Questions

What is the quickest way to copy a formula down in Excel?

For a known range, select the formula cell and the cells below it, then press Ctrl+D on Windows. You can also choose Home > Fill > Down. On Mac, Control+D is the Fill Down shortcut, though the ribbon command is a dependable alternative.

How do I copy a formula down without changing its references?

Use absolute references for the parts that must remain fixed. In a formula, dollar signs lock a column, a row, or both. Do not lock references that should move with each row. Test the copied formula in a lower cell to verify that the references behave as intended.

Can I fill a formula down to the last row automatically?

Yes. Double-click the fill handle to extend the formula alongside a continuous neighboring data range. Excel uses that adjacent range to infer the endpoint, so blank rows or uneven data can make the fill stop early or end at an unexpected row. Verify the endpoint afterward.

Will copying a formula also copy the cell’s formatting?

It can, especially when you use copy and paste. To keep the destination formatting, use Fill Down or choose the Formulas paste option after copying. If the format changes, you can reapply the destination number format or use Paste Special to paste formulas only.

Why does my formula show the same answer in every row?

Check whether the references are locked with dollar signs, whether each row’s input values are different, and whether calculation is set to Automatic. Also inspect a lower formula cell: it may have been pasted as text or may not refer to that row’s inputs.

Does this work in Excel for Mac and Excel for the web?

Yes. The fill handle and ribbon Fill Down command are available in current Excel versions, though ribbon layout can vary. On Mac, use Control+D for Fill Down where supported, or use Home > Fill > Down; copy and paste uses Command+C and Command+V. Excel for the web also supports filling cells, but some keyboard shortcuts depend on the browser and operating system.

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.