Fix Excel Formulas That Show the Same Value When Dragged
Question details
The user wants formulas to change appropriately when dragged into adjacent Excel cells.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user drags the fill handle to copy a formula down a range.
- Observed behavior
- The destination cells display the same result even though automatic calculation and the fill handle are enabled.
Select the original cell and look at its formula in the formula bar. Identify which cell references should move as you fill the formula.
Use Relative References in the Source Formula
Use this solution when the formula contains only constants or references locked with dollar signs.
Select the original cell and check the formula bar. A formula such as =-100*(1+5%) contains only constants, so it remains identical when filled.
In the formula bar, enter a relative reference where the input should change. For example, use =-C4*(1+5%) to calculate from C4.
Remove dollar signs from references that should move. For example, change $C$4 to C4; keep dollar signs where a row or column must stay fixed.
Drag the fill handle down, then select a destination cell and check its formula in the formula bar. The next row should refer to C5 in the example.

Fill Formulas with Relative References in WPS Spreadsheet
Use WPS Spreadsheet to edit a formula, fill it down, and verify that its references change in each row.
- 1. Open the workbook: Open WPS Spreadsheet and select Open to choose your Excel workbook.
- 2. Edit the formula: Select the source cell and enter a formula with a relative reference in the formula bar, such as =-C4*(1+5%).
- 3. Fill the range: Drag the fill handle from the source cell down through the destination cells.
- 4. Check the references: Select a filled cell and inspect the formula bar to confirm that the reference changed to the intended row.

Frequently Asked Questions
Why does a formula with only numbers stay the same when I drag it?
A formula such as =-100*(1+5%) has no cell references to adjust. Replace the changing input with a reference, such as C4, before dragging the fill handle.
What do dollar signs mean in an Excel formula?
Dollar signs lock a column, a row, or both when a formula is copied. For example, $C$4 stays fixed, while C4 changes relative to the destination cell.
Why do different formulas still show the same result?
The referenced cells may contain the same values. Select each destination cell and compare the formulas in the formula bar.
How can I keep one reference fixed while filling a formula?
Add dollar signs to the reference that must remain fixed, such as $C$4, while leaving references that should move relative, such as D4.




