How to Keep the Ribbon Open in Excel on Windows and Mac

To keep Excel’s Ribbon open on Windows, select Ribbon Display Options near the upper-right corner of the window, then choose Show Tabs and Commands. If the Ribbon is simply collapsed, press Ctrl+F1 or double-click a tab to expand it. These options bring the command buttons back into view so they remain available while you work.

What You’ll Need

Excel for Microsoft 365 on Windows, or access to Excel for Mac or Excel for the web if you are following the platform-specific notes.
A workbook open in Excel. You do not need to change the workbook’s data or save a special file to show the Ribbon.
Access to the Excel window controls. If Excel is in full-screen mode, move the pointer to the top edge or leave full screen to reveal the controls.

Step-by-Step

Open the Excel window and find the Ribbon. The Ribbon is the area containing tabs such as Home, Insert, Page Layout, Formulas, and Data, along with groups of buttons beneath those tabs. If you can see the tab names but not their buttons, the Ribbon is minimized rather than completely hidden. If neither tabs nor buttons are visible, it may be set to auto-hide.
Open Ribbon Display Options. In Excel for Microsoft 365 on Windows, look near the top-right of the Excel window, close to the minimize and window controls, for the Ribbon Display Options button. Select it to open the display choices. Its position can shift slightly depending on the window size and whether Excel is maximized.
Choose “Show Tabs and Commands.” This is the setting that displays both the tab names and the command buttons underneath them. Do not choose Show Tabs if your goal is to keep the full set of commands visible: that option leaves only the tab names on screen, and you must select a tab to temporarily reveal its commands. Avoid Auto-hide Ribbon when you want the Ribbon to remain available; that option hides it until you move to the top of the window.
Check that the commands stay visible. Select a cell, then look below the tab names. You should see command groups such as Clipboard, Font, and Alignment on the Home tab. Select another tab, such as Insert, to confirm its buttons appear and remain displayed when you return to the worksheet. You can now work without reopening the Ribbon for each command.
Use the keyboard shortcut if you prefer. In the Windows desktop app, press Ctrl+F1 to toggle the Ribbon between its expanded and collapsed states. This is useful when the tab names are visible but the buttons are not. Because it is a toggle, pressing the shortcut again can collapse the Ribbon; if you are unsure which state you are in, use Ribbon Display Options and explicitly select Show Tabs and Commands.
Expand it by double-clicking a tab. When the tab names are visible, double-click one of them, such as Home. Double-clicking toggles the command area open or closed. A single click on a tab may only show that tab’s commands temporarily when the Ribbon is minimized, so use a double-click or the display-options setting if you want to leave it expanded.
On a Mac, use the Ribbon controls available in your version. Excel for Mac has a different window layout, so the Windows Ribbon Display Options button may not appear in the same place. Look for the Ribbon display control in the Excel window, or use the macOS menu bar and choose View > Ribbon if that command is available in your version. The Mac shortcut Command+Option+R can toggle Ribbon visibility in supported versions. If that shortcut does not work, use the View menu rather than assuming the Windows shortcut applies.
In Excel for the web, check the Ribbon display control. The browser version may arrange its controls differently from the Windows desktop app. If you see Ribbon Display Options, choose the option that shows both tabs and commands. If the control is not present, select a tab or the visible expand/collapse arrow in the Excel toolbar to reveal the commands. Browser shortcuts can be intercepted by the browser, so the on-screen control is the safer choice.
Reopen the workbook and confirm the view you want. The Ribbon is an Excel interface display setting, not a worksheet formatting option. After selecting Show Tabs and Commands, continue working or close and reopen Excel to see whether the setting is retained in your setup. If it changes on another computer or in another version of Excel, repeat the steps there; the Ribbon preference is not stored as part of the workbook’s cell data.

Common Mistakes

Choosing “Show Tabs” instead of “Show Tabs and Commands.” These options sound similar, but they do different jobs. Show Tabs leaves the row of tab names visible and saves vertical space, while hiding the command groups until you select a tab. For an always-open Ribbon, choose the option that explicitly includes both tabs and commands.

Using Ctrl+F1 once and expecting it to lock the Ribbon open. The shortcut toggles the display; it does not select a permanent “always open” mode. If it collapses the Ribbon, press it again or select the full-display option from Ribbon Display Options. The explicit menu setting is easier to confirm.

Clicking a tab once and assuming it will stay expanded. With a minimized Ribbon, one click can reveal commands temporarily. Those commands may disappear when you return to the worksheet. Double-click the tab to toggle the expanded state, or select Show Tabs and Commands from the display menu.

Confusing a hidden Ribbon with a small window. Excel may show fewer commands when its window is narrow, or groups may display compact controls. Maximize the window before troubleshooting. If the tab names and command area are both missing, check for auto-hide instead of repeatedly clicking worksheet cells.

Expecting the setting to travel with the workbook. Showing the Ribbon changes the Excel interface, not the workbook’s contents. A colleague, another computer, or a different Excel platform may display it differently. The file can still open normally even if the other person’s Ribbon is collapsed.

Tips

Use the explicit setting for a reliable result. If you want the full command area to remain on screen, Show Tabs and Commands is clearer than relying on a toggle shortcut.
Distinguish the three display modes. Auto-hide gives the most worksheet space but hides the Ribbon; Show Tabs keeps only the tab row; Show Tabs and Commands keeps the full Ribbon visible. Choose based on whether quick access or worksheet space matters more.
Remember that a visible Ribbon changes the worksheet area. The Ribbon takes up vertical space, which can leave fewer rows visible on a small display. You can maximize Excel or adjust display scaling if the worksheet feels cramped, without switching back to auto-hide.
Use keyboard access as a backup, not a replacement for the setting. Ctrl+F1 is handy for a quick temporary change on Windows. If you regularly need the Ribbon open, set the display mode explicitly and use the shortcut only when you intentionally want to collapse or expand it.
Check the platform before following shortcut advice. Windows, Mac, and browser versions do not have identical menus or key combinations. On Mac, use the View menu if the shortcut is unavailable; in a browser, prefer the on-screen control if the browser captures a key combination.
Do not change workbook security or macros to solve a display issue. A collapsed Ribbon is normally just a user-interface setting. You should not need to enable macros, edit the workbook, or alter Excel’s security settings to show standard commands.

Troubleshooting

The Ribbon still disappears after choosing the full display option. Reopen Ribbon Display Options and verify that Show Tabs and Commands is selected, rather than Auto-hide or Show Tabs. If the Ribbon is expanded but disappears only after you select a tab, double-click the tab to change its toggle state. Then select another tab and return to the worksheet to check whether the commands remain.

You cannot find Ribbon Display Options. First maximize the Excel window; controls can be less obvious when the window is small. Look along the upper-right edge of the Excel app, not inside the worksheet. If the Ribbon is merely minimized, press Ctrl+F1 on Windows or double-click a tab. In Excel for Mac, use View > Ribbon when available. Excel for the web can place or label its display control differently, so check the toolbar’s expand/collapse control.

The shortcut does nothing. Make sure Excel, rather than another app or the browser, is active. Some laptop keyboards require holding Fn as well as Ctrl+F1 because the function keys have a hardware action assigned to them. If the shortcut still does not respond, use the menu or double-click a Ribbon tab. On Mac, use the Excel menu-bar command if the shortcut is not supported by your keyboard or version.

The Ribbon is visible but commands are missing or compact. Maximize Excel and check whether the window is in a simplified Ribbon layout. A compact layout can show fewer buttons at once without hiding the whole Ribbon. Look for a Ribbon layout or expand control in the window and choose the fuller layout if available. You can also widen the window; some groups compress when there is not enough horizontal room.

The Ribbon changes after reopening Excel or switching devices. Set the display mode again on the computer or platform where it changed. The Ribbon is part of Excel’s interface, so another user profile, device, or web session may have a different display preference. If Excel repeatedly resets the option on the same computer, close Excel normally, reopen it, and check for Office updates or managed-device policies that may control interface settings.

You are in full-screen mode and cannot see the controls. Move the pointer to the top edge of the screen to reveal the window controls, or exit full screen using the control provided by your operating system. Then select the Ribbon display option. Full-screen behavior can differ between Windows and Mac, so use the visible window controls rather than relying on a shortcut from another platform.

Frequently Asked Questions

Why does my Excel Ribbon keep collapsing?

It may be set to Show Tabs or Auto-hide Ribbon, or it may have been toggled closed with Ctrl+F1 or a double-click on a tab. Select Ribbon Display Options > Show Tabs and Commands on Windows to keep the full command area visible.

Does keeping the Ribbon open change my workbook?

No. It changes how Excel’s interface is displayed, not the worksheet’s data, formulas, or formatting. Other people can open the same workbook with a different Ribbon display mode.

Can I keep the Ribbon open in every workbook?

The setting applies to Excel’s interface rather than being saved inside an individual workbook. It may be remembered in your Excel setup, but it is not a workbook-level setting you can use to force the same display for every person or device.

What is the difference between “Show Tabs” and “Show Tabs and Commands”?

Show Tabs displays tab names but hides their command buttons until you select a tab. Show Tabs and Commands displays both the tabs and their buttons, which is the choice for keeping the full Ribbon open.

What is the Windows shortcut to show or hide the Ribbon?

Press Ctrl+F1 in the Excel desktop app. It toggles the Ribbon, so it can either expand or collapse it depending on its current state. Use the display menu when you need to select a specific mode.

Does the same method work in Excel for Mac?

The idea is the same, but the controls can be in different places. Check View > Ribbon in the Mac menu bar or use the Mac Ribbon control. The Windows shortcut is not the Mac shortcut; if a Mac key combination is unavailable, use the menu.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.