Mon 12 May 2008, 16:32Delegate Barbara said...
Barbara has attended:
Excel Introduction course
Absolute reference formulas
How do you lock a reference formula?
Tue 13 May 2008, 05:48Trainer Tracy said...
RE: absolute reference formulas
Hi Barbara,
To answer your question to lock a formula you have to make it absolute by putting dollar signs around the reference. For example A1 becomes $A$1. A shortcut to this is clicking into the reference and pressing the function key F4.
Hope that helps
Tracy
