Switch cell reference from absolute to relative in formula
Master this Excel shortcut with our comprehensive guide
Excel Formula-Related Shortcuts
F4
⌘ + T
How to Use This Shortcut
Keyboard Shortcut
F4
Instructions
1. Select a cell reference in a formula
2. Press F4
3. Cycle through absolute, mixed, and relative references
2. Press F4
3. Cycle through absolute, mixed, and relative references
Keyboard Shortcut
⌘ + T
Instructions
1. Select a reference in formula
2. Press Command + T
3. Toggle between absolute, relative, and mixed references
2. Press Command + T
3. Toggle between absolute, relative, and mixed references
💡 Pro Tip: Essential for copying formulas without changing specific row/column references.
Quick Actions
More Excel Formula-Related Shortcuts
Alt + =
Ctrl + Shift + U
Shift + F3