Excel keyboard shortcuts

Toggle absolute and relative references

Windows
F4
Mac
Cmd+T

While editing a formula, cycles the reference under the cursor through $A$1, A$1, $A1 and A1. Locked ($) parts do not move when the formula is copied.

More Formulas shortcuts