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)
|
|