How to Hide an Excel Menu Bar for Users
By Kathryn Hatashita-Lee
The Excel command ribbon replaces the menu bar with tabs and buttons that show or hide when you apply the Ribbon Display Options or the Excel Options. The Ribbon Display Options include the Auto-hide Ribbon command that hides the ribbon plus the status bar at the bottom of the screen. The ribbon also quickly restores to view with the Show Tabs and Commands button. To make it harder for your users to access the ribbon, you can adjust the Excel Options and deselect all the tabs. Only the File tab will remain on the ribbon and enable you to restore the ribbon to full view.
Ribbon Display Options Button
Click the “Ribbon Display Options” button near the upper-right corner of the Excel screen. This button displays a tiny arrow pointing up to two horizontal lines. The drop-down list displays three options: “Auto-hide Ribbon,” “Show Tabs” and “Show Tabs and Commands.”
Select “Auto-hide Ribbon” to hide the command ribbon. The worksheet will move up and take the place of the ribbon. The default green status bar at the bottom of the screen also hides from view.
Click the “Ribbon Display Options” button again, and then select “Show Tabs and Commands” to restore the ribbon and its functions.
Click the “File” tab on the ribbon, click "Options" and then select “Customize Ribbon” to view two lists in separate panes, including the Customize the Ribbon column.
Click the “Customize the Ribbon” drop-down list, and then select one of the three ribbon options: “All Tabs,” “Main Tabs” or “Tool Tabs.”
Remove the tick from each tab’s check box. For example, deselect “Home,” “Insert” and “Page Layout.”
Click “OK” to update the ribbon. Only the File tab remains on the ribbon.
When the ribbon hides, a button with three dots appears next to the Ribbon Display Options button. Selecting this Three Dots button will display the ribbon, the Quick Access Toolbar and the status bar to display the commands temporarily. Clicking in the worksheet hides the ribbon again.
To restore the ribbon through the Excel Options, click the “File” tab, select “Options,” click “Customize Ribbon” and then tick each tab’s check box. Click “OK” to restore the Excel ribbon.
To hide the commands but keep the tabs displayed, press and hold “Ctrl” and then press “F1.” To restore the commands, press and hold “Ctrl” and press “F1” again.
Information in this article applies to Microsoft Excel 2013 Home and Business. It may vary slightly or significantly with other versions or products.