Welcome toExcel2007.Tips.Net
Helpful Links
Car Tips
Cleaning Tips
Family Tips
Pest Tips
Newest Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
Subscribe
Hiding Worksheet Tabs
Summary: Look at the bottom of a worksheet and chances are you will see tabs for all the worksheets in the current workbook. Want to hide those tabs? You can do so by using the steps described here.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:
- Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
- Click Advanced at the left side of the dialog box.
- Scroll through the list of options until you see the Display Options for This Workbook section. (Click here to see a related figure.)
- Clear the Show Sheet Tabs check box to turn off the worksheet tabs.
- 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.
Related Tips:
Create Rock-Solid Lists! Bulleted and numbered lists can help make your writing clearer and easier to follow. If not done properly, however, they can be a nightmare to work with. Discover the ins and outs of Word's lists with this great reference available in two versions. Check out Word Bullets and Numbering today!