The magic F4 key during formula typing.

Are you not tired of having to add the $ sign in front of the absolute references when you type a formula.

Then use the F4 key while typing. This will adjust the reference type, abs to relative.

if you type A41 and then press F4

A41 will become $A$41

press F4

$A$41 will become A$41

press F4

A$41 will become $A41

press F4 a last time

$A41 will become A41

and it starts again.

Great Tip.


If you are not in the Formula typing, then F4 will repeat the last action.

Please Tweet, Like or Share us if you enjoyed.