ASAP Utilities, description of our Excel toolsEnglish (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:
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.
Starting this utilityIn the Excel menu choose: ASAP Utilities » Formulas » Change formula reference style (e.g. A1 to $A1 etc.)...
« Return to the list of “Formulas” tools.
Download ASAP Utilities
Additional keywords for this tool:
relative, absolute, references
Follow ASAP Utilities on Facebook
List of all utilities
Printer friendly page
^ Back to Top