freezing formulas
 

What is the shortcut key to freeze formulas in Excel???

Rgds,

Junoon

freezing formulas
 

Are you looking for F9, maybe?


"junoon" wrote:

What is the shortcut key to freeze formulas in Excel???

Rgds,

Junoon

freezing formulas
 

I tried F9, does not do anything...
what does it do????

freezing formulas
 

If you click in the formula bar (or hit F2) and hit F9, Excel will hardcode
the result of the formula in the cell.


"junoon" wrote:

I tried F9, does not do anything...
what does it do????

freezing formulas
 

If you mean ABSOLUTE REFERENCE you use F4 to apply a $ sign in front of the
row and the column reference.

Gilles
"junoon" wrote in message
oups.com...
What is the shortcut key to freeze formulas in Excel???

Rgds,

Junoon