If you want to show or hide the worksheet tabs in Excel, there are a few ways to do it. You can use the Ribbon, or you can use the Tools palette. The Ribbon To show or hide the worksheet tabs in Excel, first open the Ribbon and click on one of the worksheet tabs. Then click on the arrow next to the tab and select Show Tab from the drop-down list. If you want to hide the tab, select Hide Tab from the drop-down list. If you want to show the tab, select Show Tab from the drop-down list and then click on it.


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.