00_lead_image_hiding_tabs

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.

01_clicking_file_tab

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

02_clicking_options

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

03_clicking_advanced

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.

04_clicking_show_sheet_tabs

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

05_clicking_ok

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