How to Hide the Top Bar in Excel and Restore It Quickly

In Excel for Microsoft 365 on Windows, hide the top bar by opening Ribbon Display Options near the upper-right corner and choosing Auto-hide Ribbon. To bring it back, move the pointer to the top of the window and choose Show Tabs and Commands. This hides the ribbon and gives the worksheet more room; it does not remove Excel’s window title bar.

What You’ll Need

Excel for Microsoft 365 on a Windows computer. The steps are similar in many recent desktop versions of Excel.
A workbook open in Excel. You do not need administrator access, a particular file type, or a change to workbook contents.

The phrase top bar can mean different parts of Excel. This guide focuses on the ribbon: the wide area containing tabs such as Home, Insert, and Data, along with their buttons. If you mean the formula bar where cell contents appear, see the separate instructions in Troubleshooting. The window title bar at the very top, which shows the workbook name and window controls, cannot generally be hidden as a separate Excel setting.

Step-by-Step

Open the workbook and locate the ribbon. The ribbon sits below the title bar. If you see tabs such as Home and View plus rows of buttons, the ribbon is expanded. If you see only the tab names, it is already partly collapsed, so you may want the full auto-hide setting rather than another collapse.
Open Ribbon Display Options. Look at the upper-right area of the Excel window, near the minimize and maximize controls. Select the Ribbon Display Options button. Depending on your Excel window size and layout, the button may appear as a small icon rather than a text label. If you cannot see it, maximize the Excel window or use the alternative method described in the next step.
Select Auto-hide Ribbon. In the menu, choose Auto-hide Ribbon. Excel hides both the tab row and the ribbon commands, leaving more of the worksheet visible. The workbook itself is not changed: this is a display preference, not an edit to the file. Auto-hide can make the sheet feel more like a full-screen workspace, but it also means commands are not permanently visible.
Bring the ribbon up when you need a command. Move the pointer to the very top edge of the Excel window. The ribbon should appear temporarily. Select the tab you need, such as Home or Data, and use a command. Depending on the command and your version, the ribbon may remain visible while you work or hide again after you return to the worksheet. If it disappears, move the pointer back to the top edge to open it again.
Choose a less-hidden setting if auto-hide gets in the way. When the ribbon is available, open Ribbon Display Options again and select Show Tabs. This keeps tab names visible but hides the command buttons until you select a tab. To keep both tabs and command buttons visible all the time, select Show Tabs and Commands. This is the standard expanded ribbon view.
Use the keyboard to collapse or expand commands. In Excel for Windows, press Ctrl+F1 to toggle the ribbon commands between expanded and collapsed. This is useful when you want to reduce the ribbon’s height without choosing full auto-hide. Ctrl+F1 generally leaves the tab names visible; it is not the same as Auto-hide Ribbon. To restore the full commands after using the shortcut, press Ctrl+F1 again.
Check the result in the workbook you are using. Scroll, select cells, and make sure you can still reach the commands you need. If you use ribbon tools frequently, Show Tabs may be a better everyday setting than Auto-hide Ribbon. You can change the display setting again at any time; it does not require saving the workbook or closing Excel.

On a Mac: Excel’s controls are arranged differently. Use the View menu and select Ribbon to show or hide the ribbon, or use the ribbon control available in your version of Excel. Mac keyboard shortcuts can differ from Windows, so do not assume Ctrl+F1 will work the same way. On Excel for the web, look for Ribbon Display Options near the upper-right corner; if the menu is not available in your current layout, use the ribbon control or expand the browser window.

Common Mistakes

Expecting Ctrl+F1 to remove every part of the top area. That shortcut collapses or expands ribbon commands. It does not necessarily hide the tab row, title bar, formula bar, or status bar. Choose Auto-hide Ribbon when you want the tabs and commands out of view.
Choosing Show Tabs and expecting the whole ribbon to disappear. This setting deliberately leaves the tab names visible. Click a tab to display its commands. For a completely hidden ribbon until you call it up, use Auto-hide Ribbon instead.
Confusing the ribbon with the formula bar. The formula bar is the line below the ribbon that displays or edits the active cell’s contents. Hiding the ribbon does not hide the formula bar. Conversely, turning off the formula bar will not remove the ribbon.
Looking for a permanent change to the workbook. Ribbon display is an Excel interface preference. Hiding it does not make the workbook open without a ribbon for every other person, nor does it remove commands from Excel. Other people may have their own display settings.
Clicking the window controls by mistake. Ribbon Display Options is close to minimize and maximize. If Excel becomes minimized or changes size, restore the window and look for the ribbon display control again; the workbook has not been damaged.

Tips

Pick the setting that matches your task. Use Auto-hide Ribbon for a presentation, a small laptop display, or a period when you are mainly reading a large worksheet. Use Show Tabs when you want a cleaner view but still want obvious access to Home, Insert, and other tabs. Use Show Tabs and Commands when you are formatting or editing frequently.
Try the collapsed ribbon before hiding it completely. Ctrl+F1 is a quick way to reclaim vertical space while keeping the tab row available. It can be a comfortable compromise for data entry because you can open a command group by selecting its tab.
Use the top edge deliberately. With Auto-hide Ribbon turned on, moving the pointer near the top of the Excel window is the fastest way to reveal the controls. On a touch screen, tap near the top instead. If Excel is maximized, move to the edge of the Excel window, not the top of a different monitor.
Remember that the view is reversible. There is no need to save a special copy of the workbook just to hide the ribbon. If Excel closes or the interface changes after an update, open Ribbon Display Options and select the view you prefer.
Make sure the worksheet, not another window, has focus. If Excel is behind another app or a dialog box is open, the pointer may reveal a different window’s controls. Click the workbook first, then move to the top edge.

Troubleshooting

The ribbon is still visible after I chose Auto-hide Ribbon. Check that you selected Auto-hide Ribbon rather than Show Tabs or Show Tabs and Commands. The latter options intentionally keep some or all of the ribbon on screen. Open Ribbon Display Options once more and confirm the selected mode.

I cannot find Ribbon Display Options. Maximize Excel and inspect the top-right corner of the window. In some layouts the button is compact, and a narrow window can hide or rearrange controls. You can also use Ctrl+F1 to collapse the commands as a temporary alternative, although that does not turn on full auto-hide. On a Mac, check the View menu for Ribbon controls.

The ribbon appears, then vanishes before I can use it. Move the pointer to the top edge again and click the tab you need. If you prefer the ribbon to stay available, choose Show Tabs or Show Tabs and Commands instead of Auto-hide Ribbon. On a touch device, tapping the tab is usually more reliable than trying to hover over it.

I meant the formula bar, not the ribbon. In Excel for Windows, select the View tab, then in the Show group clear the Formula Bar checkbox. To restore it, return to View and select Formula Bar again. This setting hides the input line above the grid but leaves the ribbon alone. Menu placement can vary slightly in Excel for Mac and Excel for the web, so look for Formula Bar under the View controls.

I meant the title bar or the row of worksheet tabs. The title bar is part of the Excel window, so Excel does not offer the same Auto-hide Ribbon option for it. Worksheet tabs are the sheet names along the bottom of the window, not the top ribbon. If your issue is that sheet tabs are missing, check the Excel display settings for whether worksheet tabs are shown and whether the workbook window is wide enough to display them.

The setting seems to change when I open another workbook. Ribbon visibility is an application-interface preference, not a setting embedded in each worksheet. If the appearance differs, verify the current Ribbon Display Options selection in the active Excel window. Also check whether you are using desktop Excel, Excel for the web, or a different account or device, since their layouts and preferences may not be identical.

Frequently Asked Questions

Can I hide the ribbon without hiding the tabs?
Yes. Choose Show Tabs in Ribbon Display Options. The tab names remain visible, while the command buttons are hidden until you select a tab. Auto-hide Ribbon hides the tabs as well as the commands until you reveal the ribbon.

What is the quickest way to make the ribbon smaller?
On Windows, press Ctrl+F1 to collapse or expand the ribbon commands. For a completely hidden ribbon, use Ribbon Display Options and choose Auto-hide Ribbon. The shortcut and the menu setting do different things.

Will hiding the ribbon affect my workbook or formulas?
No. It changes how Excel’s interface is displayed and does not edit worksheet data, formulas, formatting, or the workbook file. You can restore the ribbon whenever you need it.

Can I hide the ribbon in Excel for the web?
Usually, yes. Open Ribbon Display Options near the upper-right corner and choose the available compact or auto-hide option. The exact choices can depend on the web layout and browser window size. If you do not see the control, widen the browser or use the web app’s ribbon display control.

How do I get the normal ribbon back?
Move the pointer to the top of the window to reveal the ribbon, open Ribbon Display Options, and select Show Tabs and Commands. In Windows, Ctrl+F1 can also restore the command buttons if you only collapsed them with that shortcut.

Does hiding the ribbon hide the formula bar too?
No. The ribbon and formula bar are separate interface elements. Use View and the Formula Bar checkbox to hide or show the formula bar independently of the ribbon.

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.