If an Excel formula will not pull down, select the cell containing it and drag the small square at its lower-right corner down the column; if that square is missing, enable the fill handle in Excel’s options. If the formula copies but the results do not change, check calculation mode, cell formatting, and the formula’s cell references.
People use “pull down” to mean dragging a formula into cells below it, usually with Excel’s fill handle. The steps below are for Microsoft Excel for Microsoft 365 on Windows. They also explain what to check when the handle is unavailable, when Excel repeats a value instead of adjusting a formula, or when a calculation appears stuck.
First, check what you are trying to fill
A formula is an instruction Excel calculates, while its displayed result is the value produced by that instruction. Pulling a formula down usually copies the instruction into each selected row and adjusts relative references. For instance, a formula that refers to cells in row 2 will typically refer to the corresponding cells in row 3 after being filled down one row.
Make sure the starting cell actually contains a formula. Click it and look at the formula bar: a formula begins with an equals sign. If the cell contains only a number or text, dragging it may copy or extend that value rather than copy a calculation.
Also distinguish formula filling from a drop-down list. A list arrow inside a cell is usually created with data validation; it is not the fill handle. If you mean that a list’s arrow is missing, check Data > Data Validation instead. If you mean that a formula will not copy into lower rows, continue with the checks below.
Enable the fill handle and drag correctly
In Excel for Microsoft 365 on Windows, open File > Options > Advanced. Under Editing options, select Enable fill handle and cell drag-and-drop, then select OK. Return to the worksheet and select the formula cell. A small square should appear at the selection’s lower-right corner. Point at the square until the pointer changes to a thin black plus sign, then drag down over the destination cells.
If the pointer is over the cell border rather than the small square, Excel may move the cell instead of filling it. If the square still does not appear, confirm that you selected one cell and that the worksheet is not protected in a way that prevents editing. On Excel for Mac, look under Excel > Preferences (or Excel > Settings in newer releases) > Edit for the fill-handle and cell-dragging option; labels can vary slightly by release.
You do not have to drag. Select the formula cell and the cells below it, then use Home > Fill > Down. The Windows shortcut is Ctrl+D. On Mac, Control+D is the usual Fill Down shortcut. This method is useful for a long range or when dragging is imprecise. It fills the selected range from its top row, so make sure the formula cell is at the top of the selection.
Use the right fill method for the range
Dragging is convenient for a short range, but double-clicking the fill handle can be quicker when there is a continuous column of neighboring data. Select the formula cell and double-click its lower-right fill handle. Excel generally fills down alongside the adjacent data to determine how far to go. It may stop early if that neighboring column contains a blank, and it may not choose the intended range if the data layout is irregular.
For a specific destination, drag to the last row or select the exact range and use Home > Fill > Down. To copy a formula horizontally, select the cells to the right and use Home > Fill > Right; the Windows shortcut is Ctrl+R. On a Mac, Control+R is commonly used for Fill Right. Check the selected range before using a fill command: Excel applies it to the cells you selected, not necessarily to every row in the worksheet.
Another option is to copy the formula cell, select the destination cells, and paste. This can be useful when the fill handle is hard to target, although ordinary paste may also bring formatting. If you need only the calculation, use the paste options to paste formulas rather than all cell contents.
Check whether the formula references should move
Most formulas use relative references. With values in B2 and C2, and a formula in D2 that multiplies them, filling down one row should update the references to the values in B3 and C3. For example, if B2 is 4 and C2 is 6, the formula in D2 returns 24; in the next row, it should use that row’s values.
With values in B2:B3 and C2:C3, and the formula beginning in D2, enter =B2*C2. If B2 is 4, C2 is 6, B3 is 5, and C3 is 3, filling the formula down returns 24 in D2 and 15 in D3. If D3 still shows 24, inspect the formula bar. A copied formula that still points to row 2 may contain absolute references, or it may have been copied as a value rather than filled as a formula.
A dollar sign locks a row or column reference. That is useful when every row should refer to one fixed input, such as a tax rate or multiplier, but it is a common reason a filled formula does not change as expected. With the amount in B2 and a rate of 5% in F1, enter =B2*(1+$F$1) in C2. If B2 is 100, the result is 105; filling down changes B2 to B3 while keeping the reference to F1 fixed. In the formula bar, compare the first and second rows to see whether each reference is locked or allowed to move.
When Excel copies the same result or shows the formula
If the formula has been filled correctly but the displayed result does not update, check calculation mode. Go to Formulas > Calculation Options and select Automatic. In Manual mode, Excel may keep showing an old result until the workbook is recalculated. Press F9 on Windows to recalculate open workbooks; on some Mac keyboards, you may need Fn+F9. Calculation settings can affect more than the selected cell.
If a cell displays the formula text instead of its result, check whether the cell is formatted as Text. Select the affected cells, choose Home > Number Format > General, then re-enter the formula by selecting the cell, pressing F2, and pressing Enter. Changing the format alone may not convert a formula that Excel already stored as text.
Also check whether Show Formulas is turned on. Go to Formulas > Show Formulas to switch between displaying formulas and displaying their calculated results. This setting can make a whole worksheet look as though formulas are not calculating, even when they are present. A leading apostrophe before an equals sign can also make an entry literal text instead of a working formula.
Look for worksheet and data-layout obstacles
A protected worksheet may prevent changes to locked cells. Check Review > Unprotect Sheet if you have permission to edit the sheet; a password may be required. Shared workbooks and organizational restrictions can also limit editing, so do not assume the fill command is broken if Excel reports that a cell cannot be changed.
Merged cells are another obstacle. A range that includes merged cells may not behave like a normal rectangular range when you drag or use Fill Down. If appropriate, unmerge the cells using Home > Merge & Center > Unmerge Cells, fill the formula in a regular range, and then decide whether the layout still needs merged cells. Merging is usually a presentation choice, not a requirement for calculations.
Filters and hidden rows can make the result of filling less obvious. A normal fill into a range may include rows that are hidden by a filter. If the requirement is to change visible rows only, select visible cells using Home > Find & Select > Go To Special > Visible cells only before applying an appropriate copy or fill operation, and verify the result carefully. Hidden rows are not automatically a signal that Excel will skip them.
Understand formulas in Excel tables
When data is formatted as an Excel table, a formula entered in one cell of a calculated column may be copied through the column automatically. If that does not happen, check whether the cell is inside the table and whether the table column already has inconsistent entries. The table’s automatic calculated-column behavior can be controlled in Excel’s AutoCorrect options, so a setting change may explain why one workbook fills automatically and another does not.
You can still use the fill handle or Home > Fill > Down in a table, but first confirm the destination rows belong to the table. If you want Excel to add a new table row, type in the row immediately below the table or use the table’s normal expansion behavior; filling into an unrelated range does not necessarily extend the table. Table formulas may also use structured references, which name columns rather than ordinary cell addresses. Those references can look different while still calculating correctly.
Common mistakes and a reliable troubleshooting order
A frequent misconception is that pulling down always creates a sequence. Excel may extend a recognizable series when you drag a value, while a formula fill copies the formula pattern. If you drag a single date or number and want a series rather than repeated copies, use the fill options that appear after dragging or provide enough starting values for Excel to identify the pattern. That behavior is separate from whether a formula is copied correctly.
Work through these checks in order to isolate the cause without changing unrelated workbook settings:
- Click the source cell and confirm the formula appears in the formula bar.
- Check that the fill handle is enabled and drag from the small square at the selection’s lower-right corner.
- Try selecting the destination range and using Home > Fill > Down or Ctrl+D on Windows.
- Inspect the copied formula for dollar signs and confirm its row references are appropriate.
- Set calculation to Automatic and check for Text formatting or Show Formulas.
- Check protection, merged cells, filters, and whether the range is inside an Excel table.
After filling, click a middle or final cell and inspect its formula. This catches errors that may not be obvious from the displayed numbers, such as every row pointing to the same source data. If the formulas look right but a result is wrong, investigate the inputs and calculation logic separately; successful filling does not guarantee that the original formula is correct.
Frequently Asked Questions
Why is the fill handle missing in Excel?
On Windows, open File > Options > Advanced and enable Enable fill handle and cell drag-and-drop under Editing options. Also check that the worksheet permits editing and that you have selected a cell rather than a shape or chart.
Why does Excel copy the same formula down?
The formula may use absolute references, the cells may have been pasted as values, or the displayed result may be stale because calculation is set to Manual. Compare the formula bar in two rows and check Formulas > Calculation Options.
How do I fill a formula down without dragging?
Select the formula cell and the cells below it, then choose Home > Fill > Down or press Ctrl+D on Windows. On Mac, use Control+D. The formula cell should be at the top of the selected range.
Why does Excel show the formula instead of the answer?
Check whether the cell is formatted as Text or whether Formulas > Show Formulas is enabled. Change a text-formatted cell to General, re-enter the formula, and turn off Show Formulas if the worksheet is displaying formulas throughout.
Does double-clicking the fill handle always fill to the last row?
No. Excel uses nearby data to estimate how far to fill, so blank cells or an uneven layout can make it stop sooner than expected. Drag to the intended row or select the exact range and use Fill Down when you need precise control.
Related
- Excel Number Format for Lakhs With Commas
- Excel Number Format for Millions With One Decimal Place
- Excel Number Format K: Show Values in Thousands
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- COUNTIF Excel Error Handling: Fixes and WorkaroundsCOUNTIF has no built-in error-handling argument, so wrap it in IFERROR when you want to replace an error…
- Python pandas Excel Import: Read Files and Fix ErrorsTo import an Excel workbook with pandas, use pd.read_excel(): df = pd.read_excel('sales.xlsx', sheet_name='January'). Install pandas and a compatible…
- Excel Not Giving Correct Sum? Find and Fix the CauseIf Excel is not giving the correct sum, first check that the formula includes the intended cells, that…
- Excel COUNTIFS #VALUE! Error: Causes, Checks, and FixesIn Excel, COUNTIFS returns #VALUE! most often because its criteria ranges are different sizes; make every range cover…
- Excel Undo and Redo Not Working? Causes and Fixes GuideIf Undo or Redo is unavailable in Excel, first check the Undo and Redo arrows on the Quick…
- Outlook Clean Up Folder Not Working? Fixes That HelpIf Outlook’s Clean Up Folder command is not working, first confirm you are using classic Outlook for Windows…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.