software

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

Rgds,

JunoonAre you looking for F9, maybe?quot;junoonquot; wrote:

gt; What is the shortcut key to freeze formulas in Excel???
gt;
gt; Rgds,
gt;
gt; Junoon
gt;
gt;

I tried F9, does not do anything...
what does it do????If you click in the formula bar (or hit F2) and hit F9, Excel will hardcode
the result of the formula in the cell.quot;junoonquot; wrote:

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

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

Gilles
quot;junoonquot; gt; wrote in message oups.com...
gt; What is the shortcut key to freeze formulas in Excel???
gt;
gt; Rgds,
gt;
gt; Junoon
gt;