Fix Excel Formulas That Do Not Update When Copied Across Cells
Question details
The user needs Excel formulas to update correctly when copied across a row.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A formula is copied horizontally using the fill handle, and its references and results should update for each new cell.
- Observed behavior
- The copied formula appears to retain the original references or displays results that have not updated.
Select the original formula cell and check its formula in the formula bar. Note which references should move across columns and which should stay fixed.
Enable automatic calculation and copy the formula again
Use this when copied formulas display old results because Excel is set to manual calculation.
In Excel, select Formulas > Calculation Options > Automatic.
Select the formula cell, then drag the fill handle at its lower-right corner across the desired cells.
Select a filled cell and inspect the formula bar to confirm that the references point to the intended cells.
Correct relative and absolute references before filling
Use this when copied formulas still point to the original cells instead of moving across columns.
Work with copied formulas in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and use formulas and the fill handle without changing your existing Excel installation.
Frequently Asked Questions
Why do copied formulas show old results in Excel?
Excel may be set to manual calculation. Select Formulas > Calculation Options > Automatic to recalculate formulas automatically.
How do I keep a cell reference fixed when copying a formula?
Add dollar signs to the parts that must stay fixed. For example, $B$2 fixes both the column and row, while $B2 fixes only the column.
Why does a copied formula still refer to the original column?
The column reference may have a dollar sign, as in $B2 or $B$2. Select the formula cell and edit the reference in the formula bar if the column should move.
How can I check whether Excel adjusted a copied formula?
Select one of the filled cells and inspect the formula bar. A relative reference such as B2 should change to C2 when copied one column to the right.
