$ Lock cells shortcut

A

Adam

Dear All

when i create a formula and want to lock some cells within the formula is there a shortcut to do this so I dont have to go into the formula and add the $ were appropriate

Adam
 
A

Alan

Click in the formula bar and hit F4 a few times, you'll see what it does,
Regards,
Adam said:
Dear All,

when i create a formula and want to lock some cells within the formula is
Click to expand...
there a shortcut to do this so I dont have to go into the formula and add
the $ were appropriate?
 
R

Ragdyer

Select the cell addresses in the formula bar and hit <F4>.
You can select more then a single address at a time.
You can also select the *entire* formula, and convert it with a single click
of <F4>.

AFAIK, there's no other shortcut to accomplish this on more then one formula
at a time!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
Adam said:
Dear All,

when i create a formula and want to lock some cells within the formula is
Click to expand...
there a shortcut to do this so I dont have to go into the formula and add
the $ were appropriate?
 
Top