Turning Off Worksheet Tabs

At the bottom of the Excel window you typically see tabs that represent each of the worksheets in your workbook. Click on a tab and the contents of the worksheet are displayed. Excel allows you to control whether these tabs are displayed or not; simply follow these steps if you are using Excel 2007:

1. Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
2. Click Advanced at the left side of the dialog box.
3. Scroll through the list of options until you see the Display Options for This Workbook section. (Click here to see a related figure.)
4. Clear the Show Sheet Tabs check box to turn off the worksheet tabs.
5. Click on OK.

If you are using an older version of Excel, follow these steps instead:

1. Choose Options from the Tools menu. Excel displays the Options dialog box.
2. Make sure the View tab is selected. (Click here to see a related figure.)
3. Clear the Sheet Tabs check box to turn off the worksheet tabs.
4. Click on OK.

Why would you want to turn off the worksheet tabs? The two typical answers are to provide more vertical space in which to display the content of the workbook and to make the Excel interface more similar to other spreadsheet programs that don't use tabs.