Collapse the Ribbon to get more space on screen

Excel 365 2016 2013 2007
When you need as much space as possible on screen to view a workbook, you can collapse (or minimize) the Ribbon to only its labels by double-clicking the label of the tab you're currently using.

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

  • Click the Minimize the Ribbon button:
Minimize Ribbon button Excel 2010
  • Or press Ctrl+F1.
Minimize Ribbon Excel 2010

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 2010

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
  • Press the Expand the Ribbon button:
    Expand Ribbon button Excel 2010
  • 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 2010
  • Press Ctrl+F1

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

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more