$ Lock cells shortcut

[Guest]

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

 

[Alan]

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

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?

 

[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 !
---------------------------------------------------------------------------

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?