You can do this too

Download "The one essential add-in for all Excel users."


“Working in Excel will be fun again with all these extra supersmart tools”

Download »

ASAP Utilities, description of our Excel tools

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

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)

You can do this too

Download "The one essential add-in for all Excel users."
Download

Additional keywords for this tool:
relative, absolute, references

Follow ASAP Utilities on Facebook