How to hide the Excel ribbon or show tabs only

In Excel for Windows, press Ctrl+F1 to collapse the commands while leaving tabs such as Home and Insert visible. Press the shortcut again to bring back the commands. If the tabs are hidden too, reveal the ribbon at the top of the window and use Ribbon Display Options to keep it visible.

Collapse and restore commands with Ctrl+F1

The ribbon contains tabs and the commands below them. For example, Home contains font, alignment, and number-format controls.

  1. Press Ctrl+F1. Check that Home and Insert remain visible and the command area is folded away. Click a tab to see its commands temporarily. Click back in the worksheet to collapse the commands again.
  2. To keep the commands in view, press Ctrl+F1 again or pin the temporarily opened ribbon using the control at its lower-right edge. The icon varies by version.

Keep tabs only or pin the commands from Ribbon Display Options

  1. First click any tab to see the commands. In newer versions, look for the ribbon display arrow at the lower right of the ribbon. In older versions, look for Ribbon Display Options near the top-right of the window.
  2. Choose Show tabs only if you need more room for cells. Choose Always show ribbon if you use several commands in succession. Older versions may label these choices Show Tabs and Show Tabs and Commands.

Microsoft’s guide to ribbon display options in Excel

Restore the ribbon when the tabs are hidden too

If you have selected Full-screen mode or Auto-hide Ribbon, both the tabs and commands are hidden. To use a command again, click at the very top of the window. In full-screen mode, use the ellipsis at the upper right if it appears.

Once the ribbon appears, open Ribbon Display Options and choose Always show ribbon or Show Tabs and Commands. Click the worksheet to confirm the ribbon stays visible.

Microsoft’s guide to showing and hiding the ribbon in Office

Find a missing Developer or chart tab

When other tabs still show, check how the missing tab is enabled. For Developer, go to File → Options → Customize Ribbon and select Developer under Main Tabs. A contextual tab such as Chart Design appears when you select a chart.

Microsoft’s instructions for showing the Developer tab