Shortcut for Switching Between Absolute

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)

Shortcut for Switching Between Absolute & Relative References