< Back

Excel: Collapse the ribbon when you don't need it

Sun Oct 14, 2018 4:20 am

If you are working with large data in Excel you may prefer to minimize the Excel ribbon menu on top to see more of your data in the sheet below. You can follow these steps to minimize the ribbon.

With Excel 2010/2013 you can use the keyboard shortcut Ctrl F1 to quickly minimize/expand the Ribbon.


Ribbon down - the normal state

Whether you're using it or not, the ribbon takes up about four rows of your worksheet, but it's actually pretty easy to minimize the ribbon and reclaim this space while you work.


Ribbon up or minimized - you can see a few extra rows

You can also click directly on the ribbon tabs, as explained below to quickly minimize/pin the Ribbon (Excel 2013)

You can "toggle" the ribbon into a minimized state and back again as below:
  • Click any tab in the ribbon. Click the small Minimize arrow icon at the right.


    When the ribbon is minimized, you'll notice that it has an elastic behavior. If you click a tab, the Ribbon will expand and let you select a command.It will snap back to to minimized again after you're done.
  • To get the ribbon back click any tab in the ribbon. Click the Pin icon at the right.

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.

    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.

  • Click the ???Ribbon Display Options??? button again, and then select ???Show Tabs and Commands??? to restore the ribbon and its functions.