How to Show and Hide the Worksheet Tabs in Excel


If you’re short on screen space, you may want to hide parts of the Excel window, such as the ribbon and the worksheet tabs. We’ve already shown you how to hide the ribbon, so here we’ll show you how to hide the tabs.

To begin, click the “File” tab.


On the backstage screen, click “Options” in list on the left.


On the “Excel Options” dialog box, click “Advanced” in the list of items on the left.


Scroll down to the “Display options for this workbook” section (not the “Display” section) and select the “Show sheet tabs” check box so there is NO check mark in the box.


Click “OK” to accept the change and close the “Excel Options” dialog box.


You can also hide other items in Excel such as cells, rows, and columns and comments, formulas, and gridlines.

Lori Kaufman is a writer who likes to write geeky how-to articles to help make people's lives easier through the use of technology. She loves watching and reading mysteries and is an avid Doctor Who fan.