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.

Profile Photo for Lori Kaufman Lori Kaufman
Lori Kaufman is a technology expert with 25 years of experience. She's been a senior technical writer, worked as a programmer, and has even run her own multi-location business.
Read Full Bio »