For Windows users

Change Formula References

This feature allows you to quickly switch each cell within the selected range between fixed and relative references.

The Change Reference Feature allows you to quickly switch between fixed and relative references for each cell within the selected range. This can be helpful when you are copying formulas to other cells and want to ensure that the references are adjusted properly.

With this feature, you can easily toggle between using absolute (fixed) references, relative references, or a mixture of the two for all cells in your selection. This will save you time and reduce errors in your spreadsheet calculations.

Save up to 2 hours of mundane work per day

debug formulas up to 5 times faster

Tools in this feature:

Absolute | $A$1

Absolute Row Relative Column | A$1

Relative | A1

Relative Row Absolute Column | $A1

More features in this category: