Update Excel Cell References When Copying Worksheet Sections
Question details
Update formula references so a copied worksheet section uses the correct denominator.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user copies a worksheet section containing formulas and wants the denominator reference to follow the new section.
- Observed behavior
- An absolute reference such as $G$28 continues to point to the original cell after the section is copied.
Identify the denominator cell in the original section and the corresponding cell in the destination section. Check whether the copy moves across columns, down rows, or both.
Use a Relative or Mixed Reference for the Denominator
Use this method when the destination denominator is in the same relative position in each copied section.
In $G$28, both the column and row are locked. A reference such as G$28 allows the column to change but keeps row 28 fixed; $G28 keeps column G fixed but allows the row to change. G28 allows both to change.
Select the formula cell and click the formula bar. Replace $G$28 with G$28 if the denominator should move across columns while staying in row 28.
Use $G28 if only the row should change, or G28 if both the column and row should change when the section is copied.
Select the worksheet section, copy it, and paste it into the new location. Excel adjusts the unlocked parts of each reference by the distance moved.
Select a pasted formula and inspect its reference in the formula bar. Confirm that it points to the denominator in the new section.

Set the Denominator Manually in Each Section
Use this approach when denominator cells are not in consistent positions across sections.
Adjust Copied Formula References in WPS Spreadsheet
Open your workbook in WPS Spreadsheet and change the denominator to a relative or mixed reference before copying the section.
- 1. Open the workbook: In WPS Spreadsheet, open the workbook containing the section you want to copy.
- 2. Edit the reference: Select a formula cell and use the formula bar to replace $G$28 with G$28, $G28, or G28, depending on which parts should change.
- 3. Copy the section: Select the section, copy it, and paste it into the destination cells.
- 4. Verify the formula: Select a pasted formula and check the denominator reference in the formula bar.

Frequently Asked Questions
Why does $G$28 stay the same when I copy a formula?
The dollar signs lock both column G and row 28. Edit the reference in the formula bar to remove the dollar sign from any part that should change.
How do I keep the denominator row fixed while copying across?
Use a mixed reference such as G$28. When copied to the right, the column changes to H, while row 28 stays fixed.
How do I keep the denominator fixed when filling a formula down?
Lock the denominator row with a reference such as G$61. For example, filling =I40/G$61 down changes the numerator row but keeps the denominator in row 61.
What if the denominator is not in the same relative position in every section?
Edit the denominator in the first formula of each copied section, then use the fill handle to copy that formula down. Check the filled references in the formula bar.




