If an Excel formula will not drag down, first check that the fill handle is enabled: in Excel for Microsoft 365 on Windows, go to File > Options > Advanced and select Enable fill handle and cell drag-and-drop. If it is enabled, use Ctrl+D to fill a selected range, then check cell formatting, formula references, and calculation mode if the results still look wrong.
Quickly identify what is going wrong
“Not working” can describe several different problems: the small square will not appear, dragging changes the formula unexpectedly, the cells show the formula as text, or the formula copies but its result does not update. Identifying which one you see makes troubleshooting much quicker. Click the formula cell and inspect both the formula bar and the destination cells.
- No fill handle: Check the fill-handle setting, whether the sheet is protected, and whether the cell is merged with another cell.
- Formula copies but gives an unexpected answer: Inspect relative and absolute references in the copied formula.
- The formula appears literally in the cell: Check for Text formatting, a leading apostrophe, or Show Formulas mode.
- The formula is present but the answer is stale: Check calculation mode and whether the formula actually refers to changing cells.
Also make sure you are dragging the fill handle, not the cell border. The fill handle is the tiny square at the lower-right corner of the selected cell. When the pointer is over it, the cursor changes to a thin black plus sign; dragging the border instead moves the cell.
How Excel fills a formula down
Dragging the fill handle copies a cell’s contents into neighboring cells. For a formula, Excel normally adjusts relative cell references based on each formula’s new position. That behavior is useful for row-by-row calculations, but it can look like an error when a reference was meant to stay fixed.
For example, with quantities in A2:A4 and prices in B2:B4, enter this in C2:
With quantities 3, 5, and 2 in A2:A4 and prices 12, 8, and 20 in B2:B4, this formula in C2 calculates the first row’s total:
=A2*B2
Dragging it down produces formulas that refer to A3 and B3, then A4 and B4. The results are 36, 40, and 40. Excel is not simply making an identical copy; it is adapting the references relative to each destination row. If the formula contains a fixed reference, such as a tax rate in one cell, that reference needs to be locked with dollar signs.
Use a dependable fill method
If dragging is awkward or unreliable, use a built-in fill command. These methods are especially helpful for long ranges, touchpads, or workbooks where the fill handle is difficult to target.
- Fill Down with the ribbon: Select the formula cell and the cells below it that should receive the formula. Choose Home > Fill > Down. Excel copies the top cell’s contents through the selected range.
- Use the keyboard: Select the cell containing the formula plus the destination cells, then press Ctrl+D on Windows. In Excel for Mac, use Command+D. The formula in the top cell fills downward.
- Double-click the fill handle: Position the pointer on the fill handle and double-click. Excel usually fills down to match the length of data in an adjacent column. This is convenient for a table, but it may stop early if that neighboring column has a blank row.
- Copy and paste: Copy the formula cell, select the destination range, and paste. This also adjusts relative references by default. Use Paste Special if you need a different result, such as values rather than formulas.
For the ribbon or keyboard method, include the starting formula cell in the selection. If you select only blank cells below it, Fill Down may have no formula at the top of the selection to copy. Before filling thousands of rows, try the method on a small section and check the resulting references.
Check the fill-handle and sheet settings
In Excel for Microsoft 365 on Windows, open File > Options > Advanced. Under Editing options, turn on Enable fill handle and cell drag-and-drop. If the option is off, you will not be able to use the corner handle to copy cells or formulas. After changing it, select the cell again and look for the small square at its lower-right corner.
A protected worksheet can also prevent changes. Check the Review tab for Unprotect Sheet; if the sheet is protected, you may need permission or the password before filling cells. Merged cells can interfere with selecting a consistent range, too. If the formula cell or destination area is merged, unmerge the cells where appropriate and try again. Be careful: unmerging may affect how existing content is laid out.
Excel for Mac has similar fill-handle behavior, but settings are found through Excel’s preferences or settings rather than the Windows File > Options dialog. Menu wording can vary by release. If you cannot find the option, use the Home tab’s Fill command or the keyboard method instead. Excel for the web also supports filling cells, although the available settings and interface differ from the desktop app.
Fix references that change incorrectly
When a copied formula returns the wrong number, compare the formula in the original cell with one of the filled cells. In a reference such as A2, both the column and row are relative, so copying down changes the row. In $A$2, both are fixed. The mixed references $A2 and A$2 lock only the column or only the row, respectively.
Suppose each row has a quantity in A2:A4, and a single tax rate of 8% is stored in F1. To calculate tax per row, use this in B2 and fill down:
With quantities 100, 50, and 25 in A2:A4 and 8% in F1, this formula returns 8, 4, and 2 in B2:B4:
=A2*$F$1
The reference to A2 shifts to A3 and A4, while $F$1 stays fixed. If you instead used F1, filling down would change it to F2 and F3, which may be blank or contain unrelated values. You can add or remove the dollar signs while editing a reference; on Windows, F4 cycles through reference types in many Excel formula-editing contexts. On Mac, the shortcut can depend on the keyboard and system settings, so typing the dollar signs directly is a reliable alternative.
A common misconception is that every reference should be locked before filling. Lock only the parts that must not move. If every row should use its own corresponding input cells, relative references are correct and should change as the formula is filled down.
When formulas display or results do not update
If a cell shows a string beginning with an equals sign instead of a result, the cell may be formatted as Text. Select the affected cells, choose Home > Number Format > General, then re-enter the formula. A practical way to re-enter it is to click the cell, press F2, and press Enter. Changing the format alone does not always convert a formula that Excel already stored as text. Also look for a leading apostrophe before the equals sign, which tells Excel to treat the entry as text.
If many cells show formulas instead of results, Show Formulas may be switched on. On Windows, press Ctrl+` (the grave-accent key, often near the upper-left corner of the keyboard) to toggle the display, or use Formulas > Show Formulas. On Mac, use the ribbon command if the keyboard shortcut differs on your layout. This setting changes what Excel displays; it does not replace the formulas with text.
If the formula is visible but its result is old, go to Formulas > Calculation Options > Automatic. In Manual calculation mode, Excel may not recalculate formulas whenever inputs change. You can request a recalculation with F9 on Windows, though setting Automatic is usually more suitable for an ordinary workbook. Calculation settings can affect other open workbooks in the same Excel session, so check the setting when results seem unexpectedly stale.
Finally, confirm the formula points to the cells you intend. Filling down does not make an unrelated formula depend on nearby data. If a formula contains typed-in numbers rather than cell references, copying it may repeat the same calculation and result in every row.
Special cases that can block or change filling
Several workbook features alter the usual experience. If a destination cell already contains data, filling down overwrites it. Excel may warn you, but inspect the selected range before confirming so that existing values or formulas are not lost. A filter or hidden rows can also make a selection harder to assess; verify which cells are selected before using a fill command.
In an Excel Table, a formula entered in a calculated column may automatically fill through the column. If it does not, check that the formula was entered inside the table and that the table column is consistent. Tables can be useful for expanding data because new rows can inherit calculated-column formulas, but they do not fix a formula with incorrect references.
If the workbook is shared or opened in another Excel version, the interface and available options may differ. Basic fill operations are longstanding Excel features, but dynamic-array formulas and newer functions have separate spill behavior. A formula that returns multiple results may not be intended to be copied down one row at a time; check whether it is a single-cell calculation or a formula designed to spill into neighboring cells.
Prevent the problem in future worksheets
Before filling a formula across a large dataset, check one copied result. Confirm that each row points to the right inputs and that any fixed rates, lookup cells, or headings use the right absolute or mixed references. A small test can catch a reference shift before it propagates through a report.
- Use an Excel Table when the data naturally belongs in a structured, expanding list.
- Keep input columns distinct from calculation columns so it is easier to spot overwritten data.
- Use clear headers and avoid merged cells inside the data range.
- Check the first and last filled formulas, not just the displayed results.
- Save a copy before making broad edits to an important workbook.
These habits also make formula errors easier to trace. A formula that is copied correctly can still be logically wrong, so verify both its references and the arithmetic of a representative row.
Frequently Asked Questions
Why is the small square missing from the corner of my cell?
In Excel for Windows, go to File > Options > Advanced and enable Enable fill handle and cell drag-and-drop. Also check whether the sheet is protected or the cells are merged.
Can I fill a formula down without dragging?
Yes. Select the formula cell and the destination cells, then press Ctrl+D on Windows or Command+D on Mac. You can also choose Home > Fill > Down.
Why does the copied formula show the wrong cell references?
Excel adjusts relative references as a formula moves. Use dollar signs to lock a row, a column, or both when that reference must stay fixed, then check a copied formula before filling the full range.
Why does Excel show the formula instead of the answer?
Check whether the cell is formatted as Text, has a leading apostrophe, or whether Show Formulas is on. Change Text to General and re-enter the formula if necessary.
Why does the formula copy but not recalculate?
Check Formulas > Calculation Options > Automatic. In Manual mode, results may remain unchanged until recalculation is requested or the calculation setting is changed.
Related
- Excel Data Validation List Without a Cell Reference?
- Excel Data Validation List: Can You Select Multiple?
- Excel Data Validation List: Remove Duplicates
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel #NAME? Error: What It Means and How to Fix ItThe Excel #NAME? error means Excel cannot recognize something written in a formula, such as a function name,…
- Excel Won’t Let You Delete a Row? Try These FixesTo delete a worksheet row in Excel for Microsoft 365 on Windows, select its numbered heading, then choose…
- Excel AVERAGEIF #DIV/0! Error: Causes, Checks, and FixesExcel’s AVERAGEIF returns #DIV/0! when it has no numeric values to average among the cells that meet the…
- Excel COUNTIFS Not Working With Dates? Fix the CriteriaExcel COUNTIFS usually fails with dates because the cells contain text instead of real date values, the criteria…
- Excel An Unexpected Error Has Occurred? Causes and FixesIf Excel says “An unexpected error has occurred,” save any recoverable work, close and reopen Excel, and check…
- Excel Not Allowing Copy and Paste? How to Fix ItIf Excel is not allowing copy and paste, press Esc, select a normal cell, and try Ctrl+C followed…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.