Expand or Collapse Ribbon in Excel (Ctrl + F1)
The Ribbon in Excel contains all the main commands and tabs. You can quickly expand or collapse it to save screen space using a keyboard shortcut.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + F1 | Cmd + Option + R |
What Does This Shortcut Do?
Pressing this shortcut toggles the Ribbon between expanded (show all tabs and commands) and collapsed (only tab names visible) modes. It helps maximize your worksheet space.
How to Use the Shortcut
- Open Excel
- Press Ctrl + F1 (Windows) or Cmd + Option + R (Mac)
- The Ribbon will toggle between expanded and collapsed
- Repeat the shortcut to switch back
Tips & Best Practices
- Collapse the Ribbon when working on large datasets to increase visible area
- Expand it again when you need access to commands and formatting options
FAQ
- Q: Can I use the mouse to collapse or expand the Ribbon?
- Yes, click the small arrow at the top-right of the Ribbon.
- Q: Is this shortcut available in all Excel versions?
- Yes, Ctrl + F1 works in most Windows versions of Excel. Mac shortcut may vary by version.