How do I lock formulas in a group of cells

[PeterRyan203]

To lock or fix a formula in one cell I use the F4 key. But how can I easily lock or fix a formulas in a group of cells?

 

[stevebausch]

You lost me on F4, doesn't do a thing on my system, and Help for "Replace a formula with its result" doesn't say a thing about hotkeys.

However, if it works for you, great.

Why not select all the cells, see what happens?


Hold Ctrl key down, if you want to select un-connected areas.

 

[PeterRyan203]

On 2002-10-08 21:37, stevebausch wrote:
You lost me on F4, doesn't do a thing on my system, and Help for "Replace a formula with its result" doesn't say a thing about hotkeys.

However, if it works for you, great.

Why not select all the cells, see what happens?


Hold Ctrl key down, if you want to select un-connected areas.

 

[PeterRyan203]

On 2002-10-08 21:50, PeterRyan203 wrote:

On 2002-10-08 21:37, stevebausch wrote:
You lost me on F4, doesn't do a thing on my system, and Help for "Replace a formula with its result" doesn't say a thing about hotkeys.

However, if it works for you, great.

Why not select all the cells, see what happens?


Hold Ctrl key down, if you want to select un-connected areas.

You need to click the reference in the formula that you want to lock and then press F4. Continuous clicking will change the nature of the lock eg Full lock; Lock to Row; Lock to Column etc. Control key doesn't help.

 

[PeterRyan203]

You need to click the reference in the formula that you want to lock and then press F4. Continuous clicking will change the nature of the lock eg Full lock; Lock to Row; Lock to Column etc. Control key doesn't help.

 

[stevebausch]

Ahh...Gotcha! You could have used the official terms of Relative and Absolute, in the context of addressing.

Are you on a Mac, or a PC?

 

[PeterRyan203]

I'm on a PC.
Sorry about the terminology