|
|||
![]() ![]() | |||
ASAP Utilities, description of our Excel tools![]() 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.
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 | |||
Home
Sitemap
Search
List of all utilities
Printer friendly page
^ Back to Top
© 1999-2019 - Bastien Mensink - ASAP Utilities - A Must in Every Office BV - The Netherlands
Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
![]() ![]() |