Collapse the Ribbon to get more space on screen

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

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 2016
  • Press Ctrl+F1.
  • In the Ribbon displays options list, choose Show Tabs:
    Ribbon displays options Excel 2016

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 2016

To totally hide the Ribbon, just choose Auto-hide Ribbon in the Ribbon displays options list:

Ribbon displays options Excel 2016

It hides 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 2016

To expand the Ribbon back to its standard 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 then click the Expand the Minimized Ribbon button:
    Expand Minimized Ribbon button Excel 2016
  • Press Ctrl+F1.
  • In the Ribbon displays options list, choose Show Tabs and Commands:
    Ribbon displays options Excel 2016

See also this tip in French: Comment réduire le ruban pour obtenir plus d'espace à l'écran dans Excel.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.