Since Microsoft Office 2007 ribbon tabs instead menu bar. Ribbon tabs is set of commands toolbar on top of window

excel 2016 show and hide collapse Ribbon tabs

Sometimes you want to hide ribbon tabs to maximize screen space, or you want to view all commands on ribbon tabs for easy to find

Show or hide ribbon tabs in Excel 2016

On top right corner click Ribbon display options as show below

excel 2016 show and hide ribbon tabs collapse

Auto-hide Ribbon

Auto-hide ribbon tabs. Click at the top of the application to show it. It best way when you want to more screen space

excel 2016 show and hide ribbon tabs collapse

Show Tabs

Show Ribbon tabs name only. Click on a tab to show commands on ribbon

excel 2016 show and hide ribbon tabs collapse

Show tabs and Commands

Show Ribbon tabs name and commands all time, easy to find and access command

excel 2016 show and hide ribbon tabs collapse

Collapse Ribbon tabs and show

Press Ctrl+F1 or Double click on Ribbon tabs name for collapse or show as show below

excel 2016 show and hide ribbon tabs collapse

Or click Collapse button on right corner for collapse Ribbon tabs

excel 2016 show and hide ribbon tabs collapse