How to Collapse the Excel Ribbon (3 Fast Methods)

The ribbon is the most-stared-at feature in Microsoft Excel that most people have never thought to move. It just sits there, eating up four rows of vertical space, whether you're actively using it or staring at a dashboard trying to see your data. On a 13- or 14-inch laptop, that's not a rounding error. It's a real chunk of your usable screen.

Collapsing the ribbon in Excel takes about two seconds, and the screen space you get back is immediate. Yet I've watched experienced colleagues scroll endlessly through reports on cramped screens without ever questioning whether the ribbon had to be there. It's been collapsible since Excel 2013. Nobody told them. That's what this article is for.

What You'll Achieve, and When Collapsing the Excel Ribbon Actually Helps

Collapsing the Excel ribbon reclaims roughly four rows of worksheet space. On a standard 1080p monitor that might feel minor. On a 14-inch laptop, which is where I do most of my work, it changes how much of a dashboard fits without scrolling. I run a Dell XPS 15, and even there, complex multi-sheet workbooks feel tighter than they should when the ribbon is fully open.

The scenarios where this matters most: small-screen laptops, presenting data to a client where you want a cleaner view, and focused data-entry sessions where you've already set up your formulas and don't need the ribbon tabs at all. If you're working in Excel for the first time and still getting oriented, you might want to leave the ribbon visible until you know where things live. But if you've been using Excel for a while and you're just tired of scrolling, this is a fast fix.

There are three distinct ribbon states in Microsoft Excel, not two. Most users toggle between "ribbon visible" and "ribbon gone." The third option, Show Tabs Only, is often the most practical: your tab names stay visible, but all the command icons disappear until you click a tab. That's the mode I leave active on my laptop 90% of the time.

---

Step 1: Collapse the Excel Ribbon Using a Keyboard Shortcut or the Caret Button

The fastest way to collapse the ribbon in Excel on Windows is a keyboard shortcut. The second-fastest is a double-click. Most tutorials lead with the small caret arrow in the corner, which works, but it's not what I'd actually reach for.

Using Ctrl+F1 to Toggle the Ribbon (Windows)

Press Ctrl+F1 and the ribbon collapses to tabs only. Press it again and it expands back. That's the full instruction. I'd argue this one shortcut is worth memorizing on its own. It's the kind of low-effort change that quietly removes friction every time you open a workbook.

The biggest time-saver in Excel isn't a formula. It's knowing ten keyboard shortcuts and actually using them.

Ctrl+F1 earns its place on that list.

In some Microsoft 365 configurations as of 2026, Ctrl+F1 can conflict with third-party add-ins. If the shortcut doesn't respond, check the troubleshooting section below before assuming it's broken.

Using the Collapse Arrow if You Prefer the Mouse

1. Look for the small upward-pointing caret (^) at the bottom-right corner of the ribbon.
2. Click it once. The ribbon collapses to tab names only.
3. To expand, click any tab and the ribbon reappears temporarily. Click the pin icon that appears at the bottom-right to lock it open again.

The double-click method is what I'd actually use at my desk: double-click any ribbon tab and it collapses. Double-click again and it expands. No hunting for the caret, no keyboard required. Almost nobody mentions it in tutorials, which is a shame because it's the most intuitive of the three.

---

Step 2: Choose a Collapse Style with Excel's Ribbon Display Options

Once you've collapsed the ribbon once, it's worth spending thirty seconds choosing how you want it to behave, because the default toggle and the Ribbon Display Options menu give you meaningfully different results.

Auto-Hide vs. Show Tabs Only vs. Full Ribbon

Click the small box icon in the very top-right corner of Excel (to the left of the minimize button) to open the Ribbon Display Options menu. You'll see three choices.

Auto-Hide Ribbon removes the ribbon entirely, tabs and all. The Excel window goes nearly full-screen. To access any ribbon command, you click the top bar to reveal the ribbon temporarily, then it disappears again. Useful for presenting. Disorienting for everyday work. I've accidentally triggered this and spent an embarrassing amount of time figuring out where the ribbon went.

Show Tabs Only keeps the tab labels visible but hides all command icons. Click a tab to see its commands; click away and they disappear again. This is the mode that actually balances workspace and access. It's the one worth using.

Show Tabs and Commands is the default. Full ribbon, always visible. Nothing hidden.

To pin the ribbon after it auto-expands on a tab click, look for the pin icon at the bottom-right of the ribbon and click it. That locks the full set of ribbon tabs and groups back into place permanently until you change it again.

---

Step 3: Collapse the Excel Ribbon on a Mac

Mac users get a slightly different experience here, and it's worth calling out separately rather than burying it in a footnote.

The keyboard shortcut on Mac is Option + Command + R. This toggles the ribbon on and off via the View menu. You can also go to View → Ribbon to do the same thing with a click. The key difference from Windows: Mac's ribbon doesn't have that elastic "click a tab to peek, then it collapses again" behavior. On Mac, the ribbon is either fully visible or fully hidden. There's no middle-ground Show Tabs Only mode that behaves the same way. If you hide the ribbon entirely on a Mac, you bring it back the same way: Option + Command + R, or View → Ribbon.

For a fuller picture of how the Excel interface works across platforms, the Excel interface and navigation guide covers the differences worth knowing.

---

Common Mistakes When Hiding the Ribbon in Excel, and How to Fix Them

The most common stumble is accidentally activating Auto-Hide and losing the ribbon entirely. If your ribbon disappears and you can't even see the tab names, click anywhere along the very top edge of the Excel window. The ribbon will reappear temporarily. Then open Ribbon Display Options and switch back to Show Tabs Only or Show Tabs and Commands.

If Ctrl+F1 does nothing, or the ribbon feels frozen and unresponsive, a conflicting add-in is the likely cause. Restart Excel in Safe Mode by holding Ctrl while launching the application, which disables add-ins. If the ribbon responds normally in Safe Mode, you've found your culprit. Go to File → Options → Add-ins to identify and disable the conflict.

If the ribbon is greyed out rather than missing, the workbook may be in a protected or read-only state. Check the title bar for "(Read-Only)" and look under the Review tab for sheet or workbook protection settings. The ribbon itself isn't broken. It's responding to the file's permissions.

To get the ribbon back under any circumstances: Ctrl+F1 on Windows, Option + Command + R on Mac, or the Ribbon Display Options icon in the top-right corner. One of those three will always work.

---