Select the formula (or a part of a formula) in the formula bar,
and press F4 to cycle between the 4 reference styles.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"BLUTO" wrote in message
...
I recall a hotkey that can lock all the cell references in a
formula.
ex. A1+B1 to $A$1+$B$1