Software

Display or hide Excel sheet tabs

You may not always want to see the sheet tabs at the bottom of a workbook window. Here's a simple way to turn off the display.
By default, Excel displays an identifying sheet tab at the bottom of the window. Not only do the tabs identify all the sheets in the window, you can click a tab to quickly assess that sheet. You can quickly turn off that display as follows:

  1. From the Tools menu, choose Options.
  2. Click the View tab.
  3. Uncheck the Sheet Tabs option in the Window Options section, and click OK.

About

Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

1 comments
lockhaca
lockhaca

To do this in 2007 click the office button, excel options, choose the advanced category in the right column. Scroll down to display options for this workbook and uncheck show sheet tabs, close the excel options window.

Editor's Picks