I recall a hotkey that can lock all the cell references in a formula. ex. A1+B1 to $A$1+$B$1
B BLUTO Nov 9, 2005 #1 I recall a hotkey that can lock all the cell references in a formula. ex. A1+B1 to $A$1+$B$1
C Chip Pearson Nov 9, 2005 #2 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
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
