ASAP Utilities, description of our Excel tools

English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語

Formulas » Change formula reference style (e.g. A1 to $A1 etc.)...

This utility will change the formula reference style in the formulas you your selected cells.

You can change the reference style to:

Relative referencing (A1)

Relative rows and absolute columns ($A1)

Absolute rows and relative columns (A$1)

Absolute referencing ($A$1)

For example a cell with the formula '=A1*(B12/100)' changed to absolute referencing becomes '=$A$1*($B$12/100)'.

The advantage of this utility is that you can quickly change the reference style in multiple formulas at once.

Screenshots

Starting this utility

In the Excel menu choose: ASAP Utilities » Formulas » Change formula reference style (e.g. A1 to $A1 etc.)...

« Return to the list of “Formulas” tools.

« Previous
Copy formulas without changing their cell references...

Next »
Replace the range names used in formulas with their cell references (on selected sheets)

Excel 2010 with ASAP Utilities in the menu

Download ASAP Utilities

Additional keywords for this tool:
relative, absolute, references

Follow ASAP Utilities on Facebook

Printer friendly page

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at: