Excel Absolute Cell References When Copying Formulas
Question details
The user needs to understand why a copied formula continues to reference $A$63 and how to make the row, column, or both adjust.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A formula such as =$A$63*R64 is being copied or used while inserting rows, but the reference to A63 needs to update in some cases.
- Observed behavior
- The $A$63 reference remains unchanged when the formula is copied because both its column and row are locked as absolute references.
Select the cell containing the formula and inspect its references in the formula bar. Decide whether the column, the row, or neither should remain fixed before changing the dollar signs.
Change the formula from an absolute reference to a relative or mixed reference
Use this solution when the copied formula should update its row, column, or both instead of keeping A63 fixed.
Dollar signs determine which parts of a cell reference stay fixed. In =$A$63*R64, both the A column and row 63 are absolute, so copying the formula does not change that reference.
Use $A63 to lock only the column, A$63 to lock only the row, or A63 to allow both the column and row to adjust. If the formula is copied down, $A63 changes to $A64 while the column remains A.
In Excel, select the formula cell and click the formula bar or press F2. Place the cursor on the A63 reference.
Change =$A$63*R64 to =$A63*R64 when the column A must stay fixed but the row should adjust as the formula is copied.
Change the reference to =A63*R64 when both the column and row should change during copying.
With the cursor on A63 in the formula, press F4 repeatedly to cycle through A63, $A$63, A$63, and $A63. On some laptops, use Fn+F4.
Press Enter, select the corrected cell, and drag its fill handle or use Copy and Paste to apply the formula to the destination cells.
Use WPS Spreadsheet to Control Absolute and Relative References
WPS Spreadsheet supports the same absolute, mixed, and relative cell reference syntax, making it easy to edit formulas and copy them across rows or columns while preserving only the references you need.
- 1. Open the spreadsheet: Launch WPS Spreadsheet and open the workbook containing the formula.
- 2. Select the formula cell: Click the cell with the formula, then click the formula bar or press F2 to edit its reference.
- 3. Adjust the dollar signs: Change $A$63 to $A63, A$63, or A63 depending on whether the column, row, or both should adjust.
- 4. Copy the corrected formula: Press Enter, select the cell, and drag the fill handle or use Ctrl+C and Ctrl+V to copy the updated formula.

Frequently Asked Questions
Why does $A$63 stay the same when I copy an Excel formula?
The dollar signs make both the column A and row 63 absolute. Excel is designed to keep that reference unchanged when the formula is copied.
How do I keep the column fixed but let the row change?
Use a mixed reference such as $A63. The column remains A, while the row changes when you copy the formula vertically.
How can I let both the row and column change?
Remove both dollar signs and use A63. This fully relative reference adjusts based on the formula's new position.
What does pressing F4 do while editing a cell reference?
When the cursor is positioned on a reference, F4 cycles through relative, absolute, and mixed formats: A63, $A$63, A$63, and $A63. Laptop users may need to press Fn+F4.
Will inserting rows always change an absolute reference?
No. An absolute reference such as $A$63 is intended to remain fixed when copied. If you need the reference to follow a copied formula or row, use a relative or mixed reference instead.




