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.


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.

Editor's Picks

Free Newsletters, In your Inbox