Formula Errors

Update Excel Cell References When Copying Worksheet Sections

Ayan MasoodAyan Masood Nov 18, 2026 868 views

Question details

Update formula references so a copied worksheet section uses the correct denominator.

Update Excel Cell References When Copying Worksheet Sections
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.
Before you start

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.

Solution 1Recommended

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.

1
Edit the formula

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.

2
Choose the right row behavior

Use $G28 if only the row should change, or G28 if both the column and row should change when the section is copied.

3
Copy the section

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.

4
Check the denominator

Select a pasted formula and inspect its reference in the formula bar. Confirm that it points to the denominator in the new section.

Use a Relative or Mixed Reference for the Denominator
Copying down within a section: For a formula such as =I40/G$61, copying down changes I40 to I41 while keeping the denominator in row 61. Copying across also changes the denominator column.
WPS Spreadsheet

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. 1. Open the workbook: In WPS Spreadsheet, open the workbook containing the section you want to copy.
  2. 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. 3. Copy the section: Select the section, copy it, and paste it into the destination cells.
  4. 4. Verify the formula: Select a pasted formula and check the denominator reference in the formula bar.
Control how denominator references change when formulas are copiedOpen and edit Microsoft Excel XLS and XLSX filesUse a familiar spreadsheet interface to inspect and fill formulas
microsoft office alternative - wps office

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.