If an Excel formula does not update when you drag it down, first check that Excel is set to calculate automatically, that the cells contain formulas rather than text, and that the references behave as intended. Select a cell with a working formula, drag its fill handle down, and inspect the resulting formula in the next row; the difference between the two formulas usually reveals the cause.
What dragging a formula is supposed to do
When you drag a formula’s fill handle—the small square at the lower-right corner of the selected cell—Excel copies the formula into adjacent cells. By default, ordinary cell references are relative, so Excel adjusts them to match each new row or column. This is why a formula that refers to A2 and B2 normally changes to refer to A3 and B3 when filled down one row.
For example, with prices in A2:A3, quantities in B2:B3, and a total formula in C2, enter =A2*B2 in C2. If A2 is 12 and B2 is 3, the result in C2 is 36. Dragging the fill handle from C2 to C3 should create =A3*B3 in C3. If A3 is 8 and B3 is 4, C3 should return 32.
That adjustment is useful, but it can look like a failure when the formula is meant to keep pointing at a particular cell. Before changing settings, determine whether Excel failed to fill the formula, filled it without changing a reference, or changed the reference but did not recalculate the result. Those are different problems with different fixes.
Check whether Excel filled the formula
Click the destination cell and look in the formula bar. If it contains the expected formula, filling worked; investigate the references, calculation mode, or displayed result. If it is blank, still contains an old value, or contains a formula from an unexpected row, check how the fill was performed and whether the cell can be edited.
- Use the fill handle: Select the formula cell and drag the small square at its lower-right corner down through the intended rows.
- Use Fill Down: Select the formula cell and the cells below it, then choose Home > Fill > Down. On Windows, Ctrl+D is the keyboard shortcut; on Mac, Control+D is commonly used. The ribbon command is a useful alternative if a keyboard layout or shortcut differs.
- Copy and paste: Copy the formula cell, select the destination range, and paste. Relative references generally adjust as they do with a fill.
If dragging appears to select or move cells rather than fill them, the fill handle may be disabled. In Excel for Microsoft 365 on Windows, open File > Options > Advanced and, under Editing options, select Enable fill handle and cell drag-and-drop. On Mac, settings are arranged differently; use Home > Fill > Down as a direct alternative, or look for the fill-handle option in Excel’s preferences.
Relative, absolute, and mixed references
A formula can fill correctly while its reference stays fixed—or shifts in a way you did not expect—because of dollar signs in the reference. A reference such as A2 is relative: both its column and row can change. A reference such as $A$2 is absolute: neither changes when the formula is copied. Mixed references lock only one part: $A2 locks the column, while A$2 locks the row.
For a fixed rate, with a subtotal in B2 and the rate in F1, enter =B2*$F$1 in C2. If B2 is 100 and F1 is 0.08, the result is 8. Filled down, the B reference becomes B3, B4, and so on, while $F$1 remains fixed. If you instead use =B2*F1, the next row will refer to F2, which may be blank or hold a different value. The formula did update, but not according to the intended design.
To diagnose this, compare the formula bar in the original cell with the one below it. If needed, edit the original formula’s dollar signs and fill down again. In Windows Excel, F4 while editing or selecting a reference cycles through reference styles; on Mac, the shortcut can depend on the keyboard and function-key settings, so typing the dollar signs directly is reliable.
Make sure the cells contain formulas, not text
Excel will not calculate an entry stored as text. A formula may appear in the grid instead of its result if the cell was formatted as Text before the formula was entered, or if an apostrophe was typed before the equals sign. For instance, an entry beginning with an apostrophe followed by =A2*B2 is treated as text, not as a working formula. Filling that entry down may copy text rather than a formula.
Select a problem cell and inspect the formula bar. If the formula appears there but the grid displays it literally, select the affected cells, change the number format to General using Home > Number Format, and re-enter each formula. Changing the format alone may not convert an existing text entry; press F2 and then Enter in a cell to make Excel interpret it again. For a large range, first test the method on a copy or a few cells and verify the results before applying it broadly.
Also check for an accidental leading space before the equals sign. A formula must start with = as the first character of the entry. If Excel shows formulas throughout the worksheet rather than their results, check Formulas > Show Formulas. Turning that view off restores result display; it does not change the formulas themselves.
Check Excel’s calculation setting
Sometimes the formula changes correctly but its displayed result does not. In Excel for Microsoft 365 on Windows, open Formulas > Calculation Options and select Automatic. In Manual calculation mode, Excel may wait for a recalculation command instead of updating results immediately after edits or fills. The calculation setting can affect other open workbooks too, so check it if several files appear not to recalculate.
After selecting Automatic, check whether the result changes. If calculation is intentionally set to Manual, use Formulas > Calculate Now to recalculate the workbook, or Formulas > Calculate Sheet to recalculate the active sheet. F9 recalculates in Windows Excel, but the ribbon commands are easier to identify and use across different keyboards. On Mac, use the Formulas tab’s calculation commands where available; the exact shortcut can differ.
Calculation mode is not the same as formula filling. A formula that is missing from the destination cell needs to be filled or copied; pressing a recalculation command will not create it. Conversely, if the destination contains the correct formula but an old result, recalculation is the relevant check.
Look for sheet protection, tables, and fill patterns
A protected worksheet may prevent changes to locked cells. If Excel refuses to fill or edit a destination, check Review > Unprotect Sheet. You may need the password set by the workbook’s owner. Protection is distinct from calculation: an existing formula might still display a result even when the cell cannot be edited.
Excel tables behave somewhat differently from ordinary ranges. When you enter a formula in a table column, Excel often fills the formula through that calculated column automatically. If a table column contains inconsistent formulas, inspect several rows and decide which formula should be standard before correcting the column. A blank row, an adjacent column, or a table boundary can also affect how far a double-click on the fill handle extends. Dragging to a clearly selected range or using Home > Fill > Down gives you more control over the destination.
Be careful not to confuse copying a formula with extending a series. If you drag a cell containing a number, date, or pattern, Excel may continue a series rather than repeat a value. For formulas, check the formula bar in the filled cells. If the fill produced an unexpected pattern, undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then select the intended range and use Fill Down.
When the result looks unchanged
A formula can update correctly and still show the same result. For example, rounding, formatting, or identical input values can make two results look alike. A cell formatted to display zero decimal places might show 12 for both 12.2 and 12.4. Temporarily increase the displayed decimal places from the Home tab, or compare the underlying values in the formula bar, before concluding that the formula failed.
Another possibility is that the formula points to cells that contain the same value in each row. Check the references and their source data, not just the visible result. If the formula uses a fixed reference intentionally, confirm that the fixed cell contains the value you expect. If the formula returns an error, such as a division-by-zero error, filling down may be working normally while a source value in that particular row needs attention.
For formulas that use functions, the same reference rules apply. A function can be copied down, but its cell references may shift, stay fixed, or mix the two depending on the dollar signs. If the formula is long, test one destination row and inspect its formula before filling thousands of rows. This makes it easier to catch a reference error before it is repeated throughout a dataset.
A quick troubleshooting order
Use these checks in order; each one separates a different kind of failure without changing more of the workbook than necessary:
- Click the destination cell and confirm whether it contains a formula.
- Compare its formula-bar contents with the original formula, especially row numbers and dollar signs.
- Check for text formatting, an apostrophe, a leading space, or Show Formulas being enabled.
- Confirm that the worksheet allows edits and that the fill handle is enabled if you are dragging.
- Set calculation to Automatic, or recalculate if Manual mode is deliberate.
- Check the referenced cells and number formatting if the formula is present but the displayed result seems unchanged.
Save a copy before making broad changes to a complex workbook. This is particularly helpful when correcting many formulas, changing calculation settings, or working in a shared file where the intended reference pattern is not obvious.
Frequently Asked Questions
Why does Excel copy the same formula instead of changing the row?
Check whether the row reference is locked, such as $A$2, or whether the entry is stored as text. A normal relative reference such as A2 should adjust to A3 when filled down one row.
Why does dragging down repeat the same number?
If the selected cell contains a constant rather than a formula, Excel may copy the value or extend a series. Check the formula bar. To fill a formula, start with a cell that actually contains one, then use its fill handle or Home > Fill > Down.
Why does my formula show in the cell instead of the answer?
The cell may be formatted as Text, the formula may begin with an apostrophe or space, or Show Formulas may be on. Check the entry and number format, and use Formulas > Show Formulas to check the worksheet display setting.
Will pressing F9 fix a formula that did not fill down?
No. F9 recalculates formulas; it does not copy a formula into an empty cell. Fill the destination first, then recalculate if the formula is present but its result is stale.
Why does a formula calculate correctly in one row but not the next?
Compare the references and the source values row by row. The second formula may point to a blank or unintended cell, or its source data may produce an error. Relative and absolute references determine how those references change when filled.
Related
- Combine Two Cells in Excel and Keep Both Text
- Combine in Excel: Text, Cells, and Data
- Company Contact List Template for Excel
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- F4 Dollar Sign in Excel Not Working? Causes and FixesIf F4 will not add dollar signs to a cell reference in Excel for Microsoft 365 on Windows,…
- VLOOKUP Not Working With Leading Zeros? Here’s WhyVLOOKUP often fails with leading zeros because Excel may store one lookup key as text, such as “00123,”…
- VLOOKUP Dates Not Working? Find and Fix the CauseVLOOKUP dates usually fail because Excel is comparing a real date value with text, a date-time value, or…
- Excel Print Area Cut Off? Fix Margins, Scaling, and Pages in ExcelIf an Excel print area is cut off, first check the worksheet in File > Print to see…
- Excel Not Copying Formula When Dragging? How to FixIf Excel is not copying a formula when you drag, first check that the fill handle is enabled:…
- Excel Not Responding on Windows 11? Fix It SafelyIf Excel says “Not responding” on Windows 11, first give it a moment—large calculations or files can temporarily…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.