Excel like a finance pro.
← The libraryPractice · 2 questions →
Workbook shortcut
Collapse or expand the ribbon
Ctrl + F1 on Windows, ⌘ + Option + R on Mac.
OccasionalDifficulty 950 · Capable
When to use it
Collapses or expands the ribbon to gain screen space.
The shape of it
- Windows
Ctrl + F1
- Mac
⌘ + Option + R
Worked examples
Collapse
Press Ctrl + F1 → The ribbon collapses to tabs
More rows visible.
Expand
Ctrl + F1 again → Ribbon back
Toggle.
Key tips
Alt with the ribbon collapsed → Key tips still work
Commands stay reachable.
Worth knowing
- Double-clicking a tab does the same.
- Key tips work regardless.
- Full-screen (Ctrl + Shift + F1 in newer versions) hides more.
Where it goes wrong
- People collapse it by accident and think the ribbon is gone.
- Laptops may need Fn.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.