Normally, Excel users like to see and use all the tabs and ribbon so as to enjoy all the available Excel functions. While on the other hand, some of the professionals, who need maximum availability of the space, may like to collapse the ribbon as it would vacate the maximum space at top of the window for them to work on cells.
You may just collapse the ribbon for a few seconds or may collapse the ribbon for a longer time – depending upon your need of the use.
You may collapse / restore the ribbon at any moment, but if you need the help, just see the instructions.
Method 1
Instructions
1: If you want a little more available space, at the top of the window, just click any tab for once and when it becomes highlighted, double-click it and the ribbon will collapse, instantly, and the tab titles will be available only.
2: If you want to revert back or restore the ribbon of a single tab, just click the tab only once and the specific ribbon of that tab will reappear.
3: To revert to full ribbon, double-click any tab and the full ribbon will be restored.
Method 2
Instructions
1: Click the ‘Ribbon Display Options’ at the top right corner of the Excel 2016. It will open up popup menu. Click the second option from top, i.e. ‘Show Tabs’. It will, instantly, collapse the ribbon to the tabs only format.
And see the ribbon has just collapsed.
2: If you want to revert the full ribbon, click any tab for once which you want to display. But, this will be just temporary restoration.
3: If you want to revert to full ribbon, double-click any tab and the full ribbon will be restored.
4: Alternatively, you may click the ‘Ribbon Display Options; and click the ‘Show Tabs and Commands’ and it will restore the ribbon.
That’s all!