OfficeTips Home || VBA Section || General Section ||  Download Section  ||  Privacy Policy

Shortcut for Switching Between Absolute & Relative References

Here is a quick way to cycle thru the relative and absolute cell address for a formula. When you type a formula in the formula bar, use a cell reference in relative address form (Lets say, use A1). After you type the reference, press F4 and the cell reference is automatically changed to an absolute cell reference (I.e. $A$1). You can also continue to press F4 to display mixed absolute and relative reference forms (which are A$1 & $A1)
 

Copyright 1999-2014 (c) Shyam Pillai. All rights reserved.