To copy a formula all the way down in Excel, select the cell with the formula and double-click its fill handle, the small square at the cell’s bottom-right corner. Excel fills the formula down beside a continuous column of data. You can also drag the handle to a chosen row or select the destination range and press Ctrl+D. These methods copy the calculation while adjusting relative cell references for each row.
What You’ll Need
- An Excel worksheet with a formula already entered in the first row you want to calculate.
- A clear idea of how far down the formula should go. A neighboring column with continuous data helps Excel determine the endpoint when you double-click the fill handle.
- Microsoft Excel for Microsoft 365 on Windows for the steps below. The same fill-handle methods are available in Excel for Mac and Excel for the web; keyboard shortcuts and ribbon layout can differ slightly.
Step-by-Step
- Enter and check the first formula. Click the cell where the first result should appear, type the formula, and press Enter. For example, with quantities in A2:A10 and unit prices in B2:B10, enter
=A2*B2in C2. If A2 contains 3 and B2 contains 12.50, the result in C2 should be 37.50. Confirm that the result and cell references make sense before filling down; copying a mistake simply repeats it. - Choose the rows that should receive the formula. Decide whether you want Excel to fill only to the last row of nearby data or to a specific row. If the adjacent data column has no gaps, double-clicking the fill handle is usually quickest. If there are blank rows, or you need a precise endpoint, dragging or selecting a range is safer.
- Use the fill handle to fill down automatically. Select C2, then point to the tiny square at the lower-right corner of its selection border. When the pointer becomes a small black plus sign, double-click. Excel copies the formula down alongside the neighboring continuous data, such as the values in column B. Check the last filled row: Excel’s stopping point is based on nearby data, and a blank in that data can make the fill stop early.
- Drag the fill handle to an exact row. Select the formula cell and move the pointer over its lower-right corner until the black plus sign appears. Hold the mouse button and drag down to the last destination cell, then release. For instance, drag from C2 to C10 to fill through row 10. Watch the highlighted range as you drag so you do not stop one row short or extend into rows that should remain empty.
- Fill a selected range with a keyboard command. Select the formula cell and all the cells below it that should contain the formula. For example, select C2:C10 if C2 already has the formula and C3:C10 are the destinations. On Windows, press Ctrl+D. Excel uses the top cell of the selected range as the source and fills its contents down through the selection. You can also use Home > Fill > Down. On Mac, Control+D is commonly the Fill Down shortcut; if it does not work with your keyboard setup, use the ribbon command. In Excel for the web, the ribbon command is a useful alternative when a shortcut is intercepted by the browser.
- Check how the references changed. Click a few filled cells and look at the formula bar. In the example, C3 should refer to A3 and B3, and C10 should refer to A10 and B10. These are relative references, so Excel updates them as it copies. If a reference was meant to stay fixed, use dollar signs in that reference before filling; a reference such as $F$1 stays anchored while other relative references adjust.
- Verify the bottom of the filled range. Check that the last intended row has a result and that there are no extra formulas below it. Compare a middle row with the source formula to make sure the references track the correct row. If results look unexpected, use Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then correct the formula or select the right range and fill again.
- Consider converting a range to an Excel table for recurring work. If you regularly add rows to a dataset, select the data and choose Insert > Table, confirming whether the table has headers. Enter the formula in the first data row of its column. Excel tables generally fill a calculated column through the existing table and apply that formula to new table rows. Check the first few results, especially if the workbook has existing formulas or table settings that affect calculated columns.
Common Mistakes
Double-clicking when the neighboring column contains gaps. The fill handle’s double-click behavior depends on adjacent data, so a blank cell can cause Excel to stop before the actual end of your records. Use drag-to-fill or select the exact range and press Ctrl+D instead. If the data column is not next to the formula column, do not assume Excel will infer the intended endpoint.
Filling one row too far or not far enough. This often happens when dragging without checking the selection outline, or when choosing a range that excludes the formula cell. For a keyboard fill, include the source formula cell at the top of the selected range. For a drag, inspect the destination row before releasing the mouse.
Locking references unintentionally. A copied formula with dollar signs can keep pointing at the same row or column. That is correct for a fixed value, such as a rate stored in one cell, but wrong when each row should use its own inputs. Conversely, a reference that should stay fixed may shift if it is left relative. Review each reference and use absolute or mixed references only where the calculation needs them.
Copying a formula that is already wrong. Filling down does not validate the logic. If the first formula uses the wrong input column, omits a needed condition, or includes an unintended range, every copied formula may be wrong in the same way. Check the first result and inspect the references before filling a large block.
Overwriting existing content. Dragging or filling a range can replace values or formulas in destination cells. Confirm that the cells below the source are intended to be filled. If they contain useful information, make a copy of the worksheet or save a separate version before changing the range.
Tips
For a one-time fill with a known endpoint, selecting the full range and using Home > Fill > Down is predictable. It avoids relying on the neighboring column and makes the destination range visible before you change it. Remember that the formula cell must be the top cell in the selected range for Fill Down to use it as the source.
Use the fill handle when the formula should follow a simple row-by-row pattern. As it copies, ordinary references such as A2 become A3, A4, and so on. Absolute references, marked with dollar signs, remain fixed, while mixed references lock only the row or column specified. This distinction is useful when a calculation combines row-specific data with one shared input.
When using a structured dataset that will grow, an Excel table can reduce repeated manual filling. A table also helps keep formulas aligned with the table’s rows. If Excel does not extend a table formula as expected, check whether the new row is actually inside the table and whether the formula column contains consistent calculated-column formulas.
After filling, use the formula bar to spot-check the first, middle, and last cells. Also compare the number of results with the number of records you intended to calculate. A quick review catches a range that stopped early, extended too far, or shifted to an unintended column.
Troubleshooting
The formula fills only a few rows. If you double-clicked the handle, inspect the adjacent column for a blank or a break in its data. Fill by dragging to the intended final row, or select the exact range and use Ctrl+D on Windows. If the formula is in a table, verify that the destination rows are part of that table.
The cells show the same result or point to the wrong inputs. Click a filled cell and examine the formula bar. If references have dollar signs where they should move, edit the source formula and fill again. If row references have moved but the answer is still identical, the calculation may legitimately return the same value, or its inputs may be unchanged. Check the referenced cells rather than judging by the displayed result alone.
The cells show the formula text instead of a result. Check whether the cells are formatted as Text. Change the format to General, then re-enter the formula by selecting the cell, pressing F2, and pressing Enter. Also check whether Show Formulas is enabled: on Windows, Ctrl+grave accent toggles formula display in many Excel setups; you can also check Formulas > Show Formulas. On Mac, use the Show Formulas control on the Formulas tab if the shortcut differs.
The result does not update after source values change. Check the calculation setting under Formulas > Calculation Options. If it is set to Manual, choose Automatic or recalculate the workbook. This setting affects when Excel recalculates formulas; it does not change how the fill handle copies them.
The shortcut does something else. Make sure the intended range, including the source formula cell at the top, is selected before using Fill Down. A laptop keyboard or browser may intercept a key combination. Use Home > Fill > Down instead, or use the fill handle. On Mac, the keyboard mapping can vary, so the ribbon command is the dependable fallback.
Frequently Asked Questions
What is the fastest way to copy a formula down an Excel column?
When the neighboring column has continuous data, select the formula cell and double-click its fill handle. Excel fills down to the adjacent data’s endpoint. For a precise range, select the source and destinations and use Ctrl+D on Windows.
How do I copy a formula down without changing a cell reference?
Make the reference absolute by adding dollar signs to its column and row, such as $F$1, before copying. Use this only for a value that must stay fixed. References without dollar signs normally adjust to match each destination row.
Can I fill a formula down without dragging?
Yes. Select the source formula cell and the cells below it, then use Ctrl+D on Windows or choose Home > Fill > Down. Double-clicking the fill handle is another no-drag option when adjacent data is continuous.
Why does double-clicking the fill handle stop early?
Excel typically uses the continuous data beside the formula column to decide how far to fill. A blank or data break in that neighboring column can stop the operation. Select the intended destination range manually or drag the handle to the last row.
Will Excel copy the formula to new rows automatically?
In an Excel table, a formula entered in a calculated column will generally fill through the table and apply to new table rows. In a regular cell range, new rows may need to be filled separately. Check the result after adding rows, particularly in a workbook with customized table settings.