How to show, hide and restore missing ribbon in Excel
In this short tutorial, you will find 5 quick and easy ways to restore Excel ribbon in case it is missing and learn how to hide the ribbon to get more room for your worksheet.
Ribbon is the central point of whatever you do in Excel and the area where most of features and commands available to you reside. Do you feel the ribbon takes up too much of your screen space? No problem, one click of your mouse, and it is hidden. Want it back? Just another click!
How to show ribbon in Excel
If the ribbon has disappeared from your Excel UI, don’t panic! You can quickly get it back by using one of the following techniques.
Show collapsed ribbon in full view
If the Excel ribbon is minimized so that onlytab names are visible, do one of the following to get it back to a normal full display:
- Press the ribbon shortcut Ctrl + F1 .
- Double-click on any ribbon tab to make the entire ribbon visible again.
- Right-click any ribbon tab and clear the check mark next toCollapse the Ribbonin Excel 2019 – 2013 orMinimize the Ribbonin Excel 2010 and 2007.
- Pin the ribbon. For this, click on any tab to temporarily view the ribbon. A small pin icon will appear at the lower right corner in Excel 2016 and 2019 (the arrow in Excel 2013), and you click on it to always show the ribbon.
Unhide ribbon in Excel
If the ribbon ishidden completelyincluding the tab names, here’s how you can restore it:
- To unhide the ribbontemporarily, click at the very top of your workbook.
- To get the ribbon backpermanently, click theRibbon Display Optionsbutton in the top-right corner and choose theShow Tabs and Commandsoption. This will show the ribbon in the default full view with all the tabs and commands.
Similar methods can be used to hide ribbon in Excel, and the next section explains the details.
How to hide ribbon in Excel
If the ribbon takes up too much space at the top of your worksheet, especially on a small screen laptop, you can collapse it to show only the tab names or hide the ribbon altogether.
Minimize the ribbon
To see only the tab names without commands like in the screenshot below, use any of the following techniques:
- Ribbon shortcut. The fastest way to hide Excel ribbon is to press Ctrl + F1 .
- Double-click a tab. The ribbon can also be collapsed by double-clicking anactivetab.
- Arrow button. Another quick way to hide the ribbon in Excel is to click the up arrow in the lower-right corner of the ribbon.
- Pop-up menu. In Excel 2013, 2016, and 2019, right-click anywhere on the ribbon and selectCollapse the Ribbonfrom the context menu. In Excel 2010 and 2007, this option is calledMinimize the Ribbon.
- Ribbon Display Options.Click theRibbon Display Optionsicon at the top-right corner and chooseShow Tabs.
Hide ribbon completely
If you aim to have the largest amount of screen space for a workbook area, use the Auto-hide option to get Excel in kind of full screen mode:
- Click theRibbon Display Optionsicon on the top-right corner of the Excel window, to the left of theMinimizeicon.
- ClickAuto-hide Ribbon.
This will totally hide the ribbon, including all tabs and commands.
Excel ribbon missing – how to restore it
If all of a sudden the ribbon disappears from your Excel, it’s most likely to be one of the following cases.
Tabs show up but commands disappeared
Perhaps you have inadvertently hidden the ribbon with an errant keystroke or mouse click. To show all the commands again, click Ctrl + F1 or double-click any ribbon tab.
Whole ribbon missing
Most probably your Excel somehow got into a "full screen" mode. To restore the ribbon, click theRibbon Display Optionsbuttonat the top-right corner, and then clickShow Tabs and Commands. This will lock the ribbon at the top of the Excel window where it belongs. For the detailed instructions, please see How to unhide ribbon in Excel.
Contextual tabs disappeared
If theTool Tabsspecific to a particular object (such as a chart, image, or PivotTable) are missing, that object has lost focus. For the contextual tabs to appear again, simply select the object.
Add-in’s tab missing
You’ve been using some Excel add-in (e.g. our Ultimate Suite) for a while, and now the add-in’s ribbon is gone. Chances are the add-in was disabled by Excel.
To fix this, clickFile>Excel Options>Add-ins>Disabled Items>Go. If the add-in is in the list, select it and click theEnablebutton.
That’s how you hide and show ribbon in Excel. I thank you for reading and hope to see you on our blog next week!
Show or hide the ribbon in Office
The ribbon is a set of toolbars at the top of the window in Office programs designed to help you quickly find the commands that you need to complete a task.
Show Ribbon options
At the top-right corner, select the Ribbon Display Options icon.
Choose an option for the ribbon:
Show Tabs and Commands keeps all the tabs and commands on the ribbon visible all the time.
Show tabs shows only the ribbon tabs, so you see more of your document, and you can still quickly switch among the tabs.
Auto-Hide ribbon hides the ribbon for the best view of your document, and only shows the ribbon when you select More, or press the ALT key.
Collapse the ribbon or expand it again
Double-click any of the ribbon tabs or press CTRL+F1 to collapse the ribbon if you need to see more of your document.
To see the ribbon again, just double-click any ribbon tab, or press CTRL+F1.
If the ribbon isn’t visible at all
If the ribbon isn’t visible at all (no tabs are showing), then you probably have it set to Auto-hide. Select Moreat the top right of the screen. This will temporarily restore the ribbon.
When you return to the document, the ribbon will be hidden again. To keep the ribbon displayed, select one of the Show options above.
Minimize the ribbon
You can minimize the ribbon if you need to see more of the document you are creating. To collapse the ribbon, select the Minimize the Ribbon arrow at the top right.
To see the ribbon again, select the arrow again.
Maximize Space by "Auto-Hiding" the Ribbon in Office 2007
Updated May 25, 2007, 12:02am EDT
The Ribbon feature in Microsoft Office 2007 is full of features that make it easier to navigate through options, but it takes up a lot of space. If you think the Ribbon is too big, you can put it into a pseudo “auto-hide” mode and still retain all the functionality, but with a much smaller footprint.
To put the Ribbon into minimized mode, just right-click an open area on the Ribbon and choose Minimize the Ribbon.
Here is how your Word document screen looks without the Ribbon… much cleaner!
With the Ribbon hidden you can still pull up the menus by clicking a tab which relates to a type of activity. The Ribbon will automatically hide once you move your mouse away from it.
You might notice the small toolbar below the Ribbon, which is known as the Quick Access Toolbar. You can add or delete any items to this menu, and you can also choose to show it in the title bar above the Ribbon to save even more space. Just right-click and choose “Show Quick Access Toolbar Above the Ribbon”
Here’s what my Outlook message window looks like with everything minimized as much as possible.
You can also add items to the Quick Access toolbar that you want to be accessible at all times by clicking the little drop-down arrow. The “More Commands” at the bottom of this menu will let you assign virtually anything to the toolbar.
These settings are specific to the application that you set them in, so you can have the ribbon automatically hidden in Word but not in PowerPoint.
You might have noticed all the different colors of the windows in the screenshots above… You can change the color scheme for Office easily.
Excel VBA Video Training / EXCEL DASHBOARD REPORTS
Show/Hide Custom Toolbars & Remove/Restore Excel’s Native Toolbars
Got any Excel Questions?Excel Help
Hide & Restore Excel Toolbars in Excel VBA
One of the most exciting parts of Excel is perhaps its ability to be customized to show the end user something quite different. For example, many build their own custom toolbar and distribute them with their Spreadsheet. However, the one question that come up time and time again is ‘how can I hide all of Excel’s toolbars and show only mine when they are using my spreadsheet?’ There are many ways to do this with some being extremely complicated (un-necessarily) through to totally flawed code which leaves the user Starting at a blank screen. The golden rule when/if changing any part of Excel is to make sure it all goes back to how it was when they are not in our specific spreadsheet. In other words,restore the users settings!
Attach Your Toolbar to the Workbook
For this example I will assume you have a custom toolbar called "MyToolbar" and you wish to hideALLof Excel’s built in toolbars and show only "MyToolbar". Before we do so though, it isVITALthat you attach your custom toolbar to the Workbook that will be using it. This will also stop users from being able to make changes stick and ensure you do not get the "The Macro could not be found", or where clicking a toolbar button opening up the Workbook so it can run the macro being clicked. To attach the custom toolbar and over-come these issues, follow the steps below;
1) Open the Workbook that should have the custom toolbar.
2) Right click on any grey unused part of any toolbar and choose "Customize".
3) On the "Toolbars" page check "MyToolbar" (or the applicable name) so it becomes visible.
4) Click "Attach" and then from the "Attach Toolbar" dialog select your toolbar and then click "Copy".
5) Click "Ok" then "Cancel" and it’s done!
You should now be aware that,ANYchanges made to your custom toolbar will not stick (between closing and re-opening the Workbook it’s attached to) unless you first (before any changes) go back to the "Attach Toolbar" dialog and select your toolbar, this time from the right side ("Toolbars in workbook") and then "Delete". Now make any changes needed and then follow steps 1 to 5 again.
Coding the Toolbar Show and Restore
The 2 macros below are what can be used to show your toolbar, remove all native toolbars and most importantly restore them back when done;
The best way to enure these 2 macros are run at the correct time, is to place aRunStatement in the Workbook_Activate, Workbook_Deactivate procedures of the Workbook Object (ThisWorkbook). To get there quickly, right click on the Excel icon top left next to "File" on theWorksheet Menu Barand select "View Code". In here place the code below;
Note the deletion of the custom toolbar when the Workbook closes, this is what prevents any changes sticking unless you have first deleted it (as shown above), made the changes and then attached it again.IMPORTANT:Do not run theApplication.CommandBars("MyToolbar").Deletewhen the custom toolbar isNOT attached.
Special! Free Choiceof Complete Excel Training CourseORExcel Add-ins Collection on all purchases totaling over $64.00. ALL purchases totaling over $150.00gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
Instant Download and Money Back Guarantee on Most Software
Excel VBA Video Training / EXCEL DASHBOARD REPORTS
Excel Trader PackageTechnical Analysis in Excel With $139.00 ofFREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft