"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

How To Hide Worksheets In Excel

Did you know you can hide worksheets in Excel?

"Why would I want to do that?", you may ask. Well, sometimes you may have worksheets that you do not use very often but they are an important part of your workbook, such as tables containing data referenced by other sheets. To prevent accidental changes to these sheets, or just to reduce the number of sheet tabs you have to navigate through, you can hide one or more of these sheets from view.

  1. Click on the sheet tab you want to hide (hold down CTRL key to select multiple sheet tabs).
  2. From the Format menu, select Sheet and click Hide.

To unhide any hidden sheets, just click Format, Sheet, Unhide, select the sheet(s) you want to unhide and click OK.

Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.