What is the shortcut for Toggle Reference Type?
Windows: F4. Mac: F4.
📊Excel Shortcut
Toggle Reference Type
Detailed guide to use "Toggle Reference Type" in Excel
Shortcut Keys
The highlighted keys show where to press. Press the required keys together.
Windows
F4
Windows shortcut: F4
Mac
F4
Mac shortcut: F4
In Action
This shows a representative pseudo-Excel example of what happens after the shortcut runs. The actual Excel UI may differ slightly.
Auto-playing example
Active: E2Selection: E2Sheet: Sheet1Step 1/2
You can scroll the sheet horizontally
↶↷BIUGeneral
Name Box
E2
Formula Bar
fx=B2*F2◢ | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Month | Sales | Cost | Margin | Plan | Rate |
| 2 | Jan | 2000 | 1400 | 600 | 1800 | 0.9 |
| 3 | Feb | 1850 | 1300 | |||
| 4 | Mar | 2100 | 1500 | 600 | 1890 |
Sheet1
Edit100%
Basic Info
- Category
- Editing
- Difficulty
- ★★☆(Intermediate)
How to Use
- 1Select the target cell/range if needed
- 2Press the highlighted keys shown above together
- 3Toggle Reference Type is executed
Practice
Practice this shortcut and build reliable muscle memory.
Usage Tip
Toggle relative and absolute references inside a formula.
Related Shortcuts
More In This Category
FAQ
How do I use Toggle Reference Type?
Use it after selecting the target cell or range to speed up edits and fixes.
What shortcuts should I practice after Toggle Reference Type?
Practice copy, line break in cell, and reference toggle next and you can move through common Excel work much faster.
Where can I practice Toggle Reference Type?
Use the page button to start a focused drill right away. If you switch to full practice, you can review copy, line break in cell, and reference toggle in the same flow.
What is the action preview for Toggle Reference Type?
A visual pseudo-Excel simulation showing the before and after state when you run the shortcut.