Driver FixRecommendedSound, Wi-Fi or graphics acting up? Check drivers firstFind missing or outdated drivers fast.Check DriversHalloween DealsAmazon USHalloween week deals: useful picks before month-endAmazon US: current deals, useful picks and tech finds.Check DealsWindows FixRecommendedWindows errors stealing your time? Find the fix fastScan stability, cleanup and performance issues.Fix Now×
FREEDOM251

Freedom251 › Blog › Excel

How to Collapse the Ribbon Automatically in Word, Excel, and PowerPoint

By Freedom251 Team · · 6 min read

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

To collapse the Office ribbon, open Ribbon Display Options and choose Show tabs only to keep tab names visible while hiding command groups. Choose Auto-hide Ribbon (also called full-screen mode in some releases) to hide tabs and commands until you move the pointer to the top. Choose Always show Ribbon to keep tabs and commands permanently visible.

For a quick ordinary collapse or expansion, click inside the Office window and press Ctrl+F1, or double-click any ribbon tab. Word, Excel, and PowerPoint store this display choice independently, so repeat the setting in each program where you want it.

As an Amazon Associate I earn from qualifying purchases.

What each ribbon display state does

Office provides three distinct display states. They are easy to confuse because both Show tabs only and Auto-hide Ribbon reduce the ribbon’s height, but they behave differently when you need a command.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
State Vertical workspace Are tab names visible? Do command groups appear automatically? How to restore or change it
Show tabs only More space than an expanded ribbon, while retaining a navigation strip Yes No. Select a tab to reveal its commands temporarily Open Ribbon Display Options and choose another state; you can also use the expanded ribbon’s pin control when it appears
Auto-hide Ribbon or Full-screen mode Maximum document, worksheet, or slide space No, until you move the pointer to the top or open the display menu No. The ribbon is revealed only after that extra action Move to the top, open the ellipsis or Ribbon Display Options control, and choose Always show Ribbon or Show tabs only
Always show Ribbon Least vertical space Yes Yes. Tabs and command groups stay pinned Use Ribbon Display Options to switch to either collapsed state

Use Show tabs only when you want a compact interface but still need to see where formatting, formulas, or slide commands are located. Use Auto-hide Ribbon when uninterrupted workspace matters more than immediate command access. Keep Always show Ribbon when you frequently use commands or do not want a reveal step.

#1 Best Overall
Microsoft Office Home 2024 | Classic Office Apps: Word, Excel, PowerPoint | One-Time Purchase for a single Windows laptop or Mac | Instant Download
  • Classic Office Apps | Includes classic desktop versions of Word, Excel, PowerPoint, and OneNote for creating documents, spreadsheets, and presentations with ease.
  • Install on a Single Device | Install classic desktop Office Apps for use on a single Windows laptop, Windows desktop, MacBook, or iMac.
  • Ideal for One Person | With a one-time purchase of Microsoft Office 2024, you can create, organize, and get things done.
  • Consider Upgrading to Microsoft 365 | Get premium benefits with a Microsoft 365 subscription, including ongoing updates, advanced security, and access to premium versions of Word, Excel, PowerPoint, Outlook, and more, plus 1TB cloud storage per person and multi-device support for Windows, Mac, iPhone, iPad, and Android.

Quickly collapse or expand the ordinary ribbon

  1. Click anywhere inside the Word, Excel, or PowerPoint window so the program has keyboard focus.
  2. Press Ctrl+F1. This toggles the normal expanded ribbon and its collapsed form.
  3. Alternatively, double-click any visible ribbon tab, such as Home or Insert. Double-clicking again reverses the change.

This shortcut is useful for temporary space-saving, but use Ribbon Display Options when you specifically need Auto-hide Ribbon, Show tabs only, or Always show Ribbon. If the shortcut appears to do nothing, click in the document, worksheet, or slide area and try again; another window or pane may have focus.

Collapse the ribbon in Word

  1. Open a document.
  2. Locate Ribbon Display Options near the upper-right area of the Word window. The exact icon position can move slightly between releases.
  3. Select Show tabs only to leave the tab names visible while hiding the command groups.
  4. Select Auto-hide Ribbon for a full-screen document view. Move the pointer to the top edge when you need the tabs and commands.
  5. Select Always show Ribbon when you want the complete ribbon pinned on screen.

Reveal Word commands temporarily

With Show tabs only selected, click a tab to display its command groups for the current task. When the ribbon expands, use its pin option if you want the commands to remain visible. Returning to Show tabs only removes the command groups but keeps the tab strip available.

Use the keyboard instead

Press Ctrl+F1 or double-click a tab for a fast expanded-versus-collapsed toggle. This does not replace the display-options menu when you need Auto-hide Ribbon rather than an ordinary collapse.

Free tools Windows power users keep installed

One-click scans. No signup required.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
Rank #2
Microsoft Office Home & Business 2024 | Classic Desktop Apps: Word, Excel, PowerPoint, Outlook and OneNote | One-Time Purchase for 1 PC/MAC | Instant Download [PC/Mac Online Code]
  • [Ideal for One Person] — With a one-time purchase of Microsoft Office Home & Business 2024, you can create, organize, and get things done.
  • [Classic Office Apps] — Includes Word, Excel, PowerPoint, Outlook and OneNote.
  • [Desktop Only & Customer Support] — To install and use on one PC or Mac, on desktop only. Microsoft 365 has your back with readily available technical support through chat or phone.

Collapse the ribbon in Excel

  1. Open a workbook and select Ribbon Display Options.
  2. Choose Show tabs only to reclaim worksheet height while keeping the tab names available.
  3. Choose Auto-hide Ribbon to remove both tabs and commands until you move the pointer to the top or open the display control.
  4. Choose Always show Ribbon to keep every tab and command group visible.

For a quick change while working with a large table or chart, press Ctrl+F1 or double-click a tab. If formulas, formatting tools, or chart commands seem to have vanished while tabs remain, Excel is probably in Show tabs only; click the relevant tab to reveal the tools or switch back to Always show Ribbon.

Collapse the ribbon in PowerPoint

  1. Open a presentation and find Ribbon Display Options near the ribbon.
  2. Choose Show tabs only when you want more slide-editing area but still want tabs such as Home, Design, and Transitions visible.
  3. Choose Auto-hide Ribbon for the largest possible slide workspace. Move to the top edge to reveal the interface when needed.
  4. Choose Always show Ribbon to keep tabs and command groups pinned during editing.

PowerPoint supports the same Ctrl+F1 shortcut and double-click-on-a-tab behavior for ordinary collapse and expansion. Use the display-options menu for the three explicit states.

How to get a missing ribbon back

No tabs or commands are visible

The application is likely using Auto-hide Ribbon or full-screen mode. Move the pointer to the very top of the window. The tabs and commands should appear temporarily, along with an ellipsis or Ribbon Display Options control. Open that control and choose Always show Ribbon if you want the complete interface to remain pinned, or choose Show tabs only if you want a compact tab strip.

Rank #3
Microsoft 365 Personal | 12-Month Subscription | 1 Person | Premium Office Apps: Word, Excel, PowerPoint and more | 1TB Cloud Storage | Windows Laptop or MacBook Instant Download | Activation Required
  • Designed for Your Windows and Apple Devices | Install premium Office apps on your Windows laptop, desktop, MacBook or iMac. Works seamlessly across your devices for home, school, or personal productivity.
  • Includes Word, Excel, PowerPoint & Outlook | Get premium versions of the essential Office apps that help you work, study, create, and stay organized.
  • 1 TB Secure Cloud Storage | Store and access your documents, photos, and files from your Windows, Mac or mobile devices.
  • Premium Tools Across Your Devices | Your subscription lets you work across all of your Windows, Mac, iPhone, iPad, and Android devices with apps that sync instantly through the cloud.
  • Easy Digital Download with Microsoft Account | Product delivered electronically for quick setup. Sign in with your Microsoft account, redeem your code, and download your apps instantly to your Windows, Mac, iPhone, iPad, and Android devices.

Tabs are visible but commands are missing

This is the expected behavior of Show tabs only. Select a tab to reveal its command groups for the current operation. To keep those groups visible, open Ribbon Display Options and select Always show Ribbon.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Ctrl+F1 appears ineffective

First click inside the Office window, then press the shortcut again. Double-clicking a visible tab is an alternative. The control’s location and the exact label can vary by version, so the Ribbon Display Options menu is the reliable way to select a specific state.

The ribbon changed in one program but not another

Ribbon display choices apply to the Office program you are using. A choice made in Word does not automatically change Excel or PowerPoint. Open each application and repeat the procedure if you want the same behavior everywhere.

Rank #4
Microsoft 365 Family | 12-Month Subscription | Up to 6 People | Premium Office Apps: Word, Excel, PowerPoint and more | 2TB Shared Cloud Storage | Windows Laptop or MacBook Instant Download | Activation Required
  • Designed for Your Windows and Apple Devices | Install premium Office apps on your Windows laptop, desktop, MacBook or iMac. Works seamlessly across your devices for home, school, or personal productivity.
  • Includes Word, Excel, PowerPoint & Outlook | Get premium versions of the essential Office apps that help you work, study, create, and stay organized.
  • Up to 2 TB Shared Cloud Storage | Store and access your documents, photos, and files from your Windows, Mac or mobile devices.
  • Premium Tools Across Your Devices | Your subscription lets you work across all of your Windows, Mac, iPhone, iPad, and Android devices with apps that sync instantly through the cloud.
  • Share Your Family Subscription | You can share all of your subscription benefits with up to 6 people for use across all their devices.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Support on Ko-Fi

Choosing the right state for your work

When Show tabs only is the best compromise

This mode preserves discoverability: you can see the tab names and reach any command with one click. It removes the command groups until they are needed, so the document, worksheet, or slide gains vertical space without hiding the navigation structure.

When Auto-hide Ribbon is worth the extra reveal step

Auto-hide provides the largest uninterrupted workspace. It is useful when reviewing a long document, examining a dense worksheet, or focusing on slide composition. The trade-off is that both tabs and commands disappear, so every command session begins by moving to the top of the display or opening the display menu.

What’s actually slowing this PC down?

Pick the symptom - the matching free tool is one click away.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

When Always show Ribbon is more practical

Keep the full ribbon visible if you are learning Office, switching among commands repeatedly, presenting instructions to other users, or working with features whose tabs are easy to overlook. It minimizes pointer travel and removes the need to remember where the hidden interface will reappear.

Best Value
SoftMaker Office Standard 2021 (5 users) for Windows, Mac and Linux [PC/Mac Download]
  • Alternative office suite: Word processor TextMaker, Spreadsheet program PlanMaker, Presentation software Presentations, Automation tool BasicMaker
  • Licensed for 5 users / household or 1 user / organization, perpetual lifetime license for Windows, Mac and Linux
  • User interface with modern ribbons or classical menus
  • Compatible with all modern Microsoft Office documents including DOCX, XLSX, PPTX
  • The complete office suite can be installed on a USB flash and used without installation

Version and platform differences

Microsoft documents these ribbon controls for current Microsoft 365 desktop applications and multiple perpetual desktop releases, including Office 2024, Office 2021, Office 2019, and Office 2016. Some Mac variants are included in that support coverage. Menu wording and the position of the display control can differ by release and update channel, but the concepts remain the same: Auto-hide Ribbon or Full-screen mode, Show tabs only, and Always show Ribbon.

If your build uses a slightly different icon or places Ribbon Display Options elsewhere, look near the upper-right portion of the ribbon or open the ellipsis menu when the interface is hidden. Select the state by name rather than relying on the icon’s shape, because icons can change between versions.

A repeatable setup for all three applications

  1. Open Word, Excel, and PowerPoint separately.
  2. In each program, open Ribbon Display Options.
  3. Choose Show tabs only for a consistent compact layout, Auto-hide Ribbon for maximum workspace, or Always show Ribbon for constant command access.
  4. Test the result by selecting a tab, moving the pointer to the top, or pressing Ctrl+F1, depending on the state you selected.
  5. If one program later behaves differently, change that program’s setting directly; the applications retain their display choices independently.

The setting controls visibility, not the availability of Office commands. A hidden command group has not been removed: it is revealed by selecting a tab in Show tabs only, by moving to the top in Auto-hide Ribbon, or by returning to Always show Ribbon.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.

ExcelMicrosoft OfficePowerPointproductivityRibbonWord

Leave a Reply

Your email address will not be published. Required fields are marked *

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Recommended PC Tool
Recommended PC Tool
PC Slower Than It Used to Be?Free scan - under a minute
Crashes, No Sound, or Screen Glitches?Free driver scan

Two free Windows tools

One Free Minute Could Fix That PC

Before you go - each of these free tools takes about a minute and tackles what quietly slows a Windows PC down.

Special offer. View Outbyte info, uninstall instructions, EULA, and Privacy Policy.