J
junoon
What is the shortcut key to freeze formulas in Excel???
Rgds,
Junoon
Rgds,
Junoon
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JMB
Are you looking for F9, maybe?
J
junoon
I tried F9, does not do anything...
what does it do????
what does it do????
J
JMB
If you click in the formula bar (or hit F2) and hit F9, Excel will hardcode
the result of the formula in the cell.
the result of the formula in the cell.
G
Gilles Desjardins
If you mean ABSOLUTE REFERENCE you use F4 to apply a $ sign in front of the
row and the column reference.
Gilles
row and the column reference.
Gilles