Change Formula Reference Style (A1, $A1, A$1, $A$1)...

ASAP Utilities › Formulas › 6. Change Formula Reference Style (A1, $A1, A$1, $A$1)...

This tool changes the reference style used in formulas in your selected cells.
It allows you to quickly update multiple formulas at once. You can change cell references to:

Relative referencing (A1)

Absolute column, relative row ($A1)

Relative column, absolute row (A$1)

Absolute referencing ($A$1) Examples:

=A1*(B12/100) → =$A$1*($B$12/100) (converted to absolute referencing)

=C5*D2 → =C$5*D$2 (converted to absolute rows, relative columns)

=F10+G3 → =$F10+$G3 (converted to absolute columns, relative rows)

=SUM($A$1:$A$5) → =SUM(A1:A5) (converted from absolute to relative referencing)

=$B$2/$C$2 → =B2/C2 (converted from absolute to relative referencing) This is useful when you want to lock or unlock rows, columns, or both before copying formulas across your worksheet, without editing each formula manually.

Screenshots

Formulas › 6 Change Formula Reference Style (A1, $A1, A$1, $A$1)...

Starting this tool

Click ASAP Utilities › Formulas › 6. Change Formula Reference Style (A1, $A1, A$1, $A$1)...
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Additional keywords for this tool:
Convert relative to absolute references, Change cell reference type, Convert A1 to $A$1, Make Excel formula references absolute, Reference style converter, Switch between relative and absolute references, Lock cell references in formulas, Change formula to absolute referencing, Excel formula to $A$1 format, Convert Excel formulas to use fixed references, Absolute vs relative reference tool, Change Excel formulas from $A$1 to A1, Convert formula references without F4, Excel cell reference locking tool, Apply absolute referencing to multiple formulas

Choose your language preference below

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

Copy Formulas Without Changing Their Cell References...

Replace Named Ranges in Formulas with Cell References

Download

©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.