Collapse the Ribbon to get more space on screen

Excel 2016 2010 2007
When you need as much space as possible on screen to view a document, you can collapse (or minimize) the Ribbon and then restore it very simple.
Minimized Ribbon Excel 2013

To collapse (or minimize) the Ribbon, do one of the following:

  • Double-click the label of the tab you're currently using.
  • Click the Minimize the Ribbon button:
Minimize Ribbon button Excel 2013
  • Press Ctrl+F1.
  • In the Ribbon displays options list, choose Show Tabs:
    Ribbon displays options Excel 2013

While the Ribbon is minimized, click any tab to turn it back on temporarily. It will automatically hide when you're done using it.

Display Minimized Ribbon Excel 2013

To tottaly hide the Ribbon (a new feature in Excel 2013), just choose Auto-hide Ribbon in the Ribbon displays options list:

Ribbon displays options Excel 2013

It hide Ribbon and displays three dots near the upper-right corner of the screen instead. Click the three dots button to redisplay the Ribbon temporarily. When you click back in the document, the Ribbon hides itself again:

Ribbon hides Excel 2013

To expand the Ribbon back to its normal size when you want to have it displayed again, do one of the following:

  • Double-click the current tab again.
  • While the Ribbon is minimized, click any tab to turn it back on temporarily and the click the Expand the Minimized Ribbon button:
    Expand Minimized Ribbon button Excel 2013
  • Press Ctrl+F1.
  • In the Ribbon displays options list, choose Show Tabs and Commands:
    Ribbon displays options Excel 2013

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.