Function Problems

Excel Absolute Cell References When Copying Formulas

John WilsonJohn Wilson Nov 12, 2026 870 views

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.

Excel Absolute Cell References When Copying Formulas
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the formula for editing

In Excel, select the formula cell and click the formula bar or press F2. Place the cursor on the A63 reference.

2
Remove the row lock

Change =$A$63*R64 to =$A63*R64 when the column A must stay fixed but the row should adjust as the formula is copied.

3
Allow both parts to adjust

Change the reference to =A63*R64 when both the column and row should change during copying.

4
Use the reference shortcut if available

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.

5
Copy the corrected formula

Press Enter, select the corrected cell, and drag its fill handle or use Copy and Paste to apply the formula to the destination cells.

Reference patterns: $A$63 locks both column and row, $A63 locks only the column, A$63 locks only the row, and A63 uses fully relative referencing.

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. 1. Open the spreadsheet: Launch WPS Spreadsheet and open the workbook containing the formula.
  2. 2. Select the formula cell: Click the cell with the formula, then click the formula bar or press F2 to edit its reference.
  3. 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. 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.
Edit and copy formulas using absolute, mixed, and relative cell references.Use a familiar spreadsheet interface with a formula bar and fill handle.Open, edit, and save Microsoft Excel .xlsx files with broad format compatibility.Work with a lightweight spreadsheet editor for everyday formula tasks.
microsoft office alternative - wps office

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.