Thursday, November 22, 2012

Trick of the day: Lock cells

When you copy a formula, you sometimes need to lock some of the cell references with dollar signs (absolute reference): A1 => $A$1 or $A1 or A$1
Use this shortcut to make your life easier:

F4












Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)