Excel Copy Formula Down a Column Not Working? Fixes

If copying a formula down an Excel column is not working, select the formula cell and the cells below it, then choose Home > Fill > Down; on Windows, Ctrl+D does the same. If the formula fills but produces unexpected results, check whether its cell references should change as they move, whether calculation is set to Automatic, and whether Excel is treating the entry as text.

How Excel fills formulas

When Excel copies a formula to another cell, it normally adjusts relative references to match the new position. This is useful when each row should calculate using that row’s values, but it can look like a failure if you expected the original references to stay fixed. The formula itself may be copied correctly even though its displayed result is surprising.

For example, with quantities in B2:B4, prices in C2:C4, and the first total in D2, enter =B2*C2 in D2. If B2 is 12 and C2 is 5, D2 returns 60. Filling the formula into D3 changes its references to B3 and C3, so the next row uses its own quantity and price. Relative references are the default.

A dollar sign makes a reference absolute, meaning it stays fixed when copied. With a fixed multiplier in B2 and amounts in C2:C4, enter =$B$2*C2 in D2. If B2 contains 1.1 and C2 contains 100, D2 returns 110; filled into D3, the formula still uses B2 but changes C2 to C3. If a copied formula repeats the same inputs in every row, check whether the references were made absolute unintentionally.

Use a dependable fill method

Excel offers several ways to copy a formula down. Choose one based on the shape of your data and whether you want to fill a short range or a long block:

Drag the fill handle: Select the formula cell and drag the small square at its lower-right corner down the column. This is direct, but dragging a long distance can be awkward.
Use Fill Down: Select the formula cell and the destination cells below it, then choose Home > Fill > Down. Excel copies the top cell’s contents through the selected range.
Use a shortcut: In Windows Excel, select the source cell and destination range, then press Ctrl+D. In Excel for Mac, use Command+D. The Home > Fill > Down command is an alternative if your keyboard or settings differ.
Double-click the fill handle: Double-click the handle on the formula cell to fill down alongside a neighboring column of continuous data. Excel uses that adjacent data to estimate how far to fill; it may stop early if the neighboring column has blanks.

For a precise fill, selecting the complete destination range before using Fill Down is often more reliable than dragging. Include the formula cell at the top of the selection. If you select only the blank cells beneath it, the command may not use the source formula as intended. After filling, check the last few rows rather than assuming every row was included.

When the formula copies but gives the wrong result

First, click a result cell and inspect the formula in the formula bar. Compare its row references with the row it is meant to calculate. A copied formula should usually point to cells on the same row, unless the calculation deliberately uses a fixed input or a different row. Selecting the source and destination cells and comparing their formulas can quickly reveal a misplaced dollar sign or an incorrect starting reference.

Absolute and mixed references are useful when copying formulas. In a reference such as $B$2, both the column and row are fixed. In B$2, the row is fixed while the column can move; in $B2, the column is fixed while the row can move. Pressing F4 while editing a cell reference cycles through reference styles in Windows Excel. On a Mac, the key combination can depend on keyboard settings; you can also type the dollar signs directly.

Another common cause is a formula that was already wrong in its first row. Filling repeats the logic; it does not infer what the calculation ought to be. Verify the original formula’s inputs and intended calculation, then check a middle row and the final row. If the formula should use a fixed rate, lookup cell, or header, make that reference explicit before filling.

When Excel shows the formula instead of its result

If a cell displays something like =B2*C2 instead of a number, Excel may be treating the entry as text, or Show Formulas may be turned on. To check the display setting, choose Formulas > Show Formulas. The Windows shortcut Ctrl+` toggles this view; the menu command is useful if the key is hard to locate. When Show Formulas is enabled, Excel displays formulas in cells across the sheet rather than their calculated results.

If only one cell shows the formula as text, select it and look at Home > Number Format. If the format is Text, change it to General, then re-enter the formula: press F2 and Enter, or edit the formula and confirm it again. Merely changing the format may not convert an existing text entry into a formula. Also check for a leading apostrophe or space before the equals sign, either of which can make the entry behave as text.

If the formula displays a previous result or does not update after its inputs change, check Formulas > Calculation Options > Automatic. In Manual calculation mode, Excel does not recalculate every dependent formula immediately. You can request a recalculation with F9 in Windows Excel; on a Mac, use Formulas > Calculate Now if the shortcut differs on your keyboard. Calculation mode can affect more than the selected cell, so verify it before assuming the fill itself failed.

Why filling stops partway down

Double-clicking the fill handle uses nearby data to decide where the destination range ends. A blank cell in that neighboring column can make the fill stop at that row, even when the formula column has more rows to complete. Either fill by dragging to the intended last row or select the exact range and use Home > Fill > Down. Review gaps in the neighboring data if double-click fill behaves inconsistently.

Also confirm that the destination cells are actually included. A filter, hidden rows, or a selection that ends too early can make the result appear incomplete. If you are working with filtered data, inspect which rows are visible and consider whether you intend to fill hidden rows too. Do not assume a visual selection covers every row in a long worksheet; the Name Box can help you check or enter a range such as D2:D500 before using Fill Down.

Tables, merged cells, and protected sheets

In an Excel table, entering a formula in one cell of a calculated column will often copy that formula to the other rows in the column automatically. If it does not, check whether the range is actually an Excel table: click inside it and look for the Table Design tab. A plain range with heading formatting is not necessarily a table. You can also select the intended formula cells and use Fill Down directly.

Excel has an option that controls automatic formula filling in tables. In Microsoft 365 for Windows, open File > Options > Proofing > AutoCorrect Options, then check the AutoFormat As You Type tab for Fill formulas in tables to create calculated columns. This option is specific to table behavior; it does not prevent the regular Fill Down command from working in a normal range. Excel for Mac has different settings dialogs, so use the table’s formula behavior and the available Excel preferences rather than following the Windows path exactly.

Merged cells can prevent a fill operation because the destination range no longer has a uniform cell layout. If practical, unmerge the affected cells, fill the formula into a consistent range, and then apply formatting separately. A protected worksheet can also block edits. Check Review > Unprotect Sheet; if the sheet requires a password, you need permission or the password from its owner. Excel does not allow a fill command to override sheet protection.

In Microsoft 365, a formula that returns a dynamic array may spill into cells below or beside its starting cell. If the spill range is occupied, Excel can show a #SPILL! error, and manually filling into the occupied output area is not the right fix. Check the cells blocking the spill range and whether the formula is intended to produce one result per row or an array of results. This differs from copying an ordinary single-cell formula down a column.

A quick troubleshooting sequence

Work through these checks in order; each identifies a different kind of failure, from the fill command not reaching the cells to a formula that is present but not calculating:

Click the first formula cell and confirm it begins with an equals sign and calculates as expected.
Select the source and the full destination range, then run Home > Fill > Down.
Inspect a filled formula in the middle of the range and confirm its references point to the intended row.
If the formula appears as text, check the cell format, leading apostrophes or spaces, and Formulas > Show Formulas.
If results do not refresh, check Formulas > Calculation Options > Automatic and request recalculation if needed.
If the operation is blocked or incomplete, look for sheet protection, merged cells, blank neighboring rows, or a dynamic-array spill range.

These checks also distinguish copying from calculation. A formula can be copied successfully but return a value that looks unchanged because the referenced values are identical, the references are fixed, or calculation has not refreshed. Conversely, the cell may remain blank simply because it was never part of the selected fill range.

Frequently Asked Questions

Why does Excel copy the same formula instead of changing the row number?
Check whether the reference includes dollar signs, such as $B$2, which lock both its column and row. Also check whether the formula is text, or whether you are viewing formulas rather than results. A normal relative reference such as B2 changes to B3 when copied one row down.

Why does double-clicking the fill handle stop early?
Excel estimates the fill length from a neighboring column. A blank or broken section in that adjacent data can make it stop. Select the exact destination range and use Home > Fill > Down when you need to control the end row.

Why does Ctrl+D not copy my formula?
On Windows, Ctrl+D fills down from the top cell of the selected range. Include the formula cell at the top and the intended blank cells below it. On Mac, try Command+D, or use Home > Fill > Down from the ribbon.

Why does my formula show as text after I copy it?
The destination cells may be formatted as Text, or the formula may contain a leading apostrophe or space. Set the cells to General and re-enter the formula. If formulas are visible throughout the worksheet, turn off Formulas > Show Formulas.

How do I stop Excel from automatically copying a formula in a table?
For Microsoft 365 on Windows, go to File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type and clear Fill formulas in tables to create calculated columns. This changes automatic behavior for table calculated columns; you can still fill formulas manually when needed.

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

More in Errors & fixes

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

Spotted an error in this guide? Let us know.