TheExcelAddict .com
Microsoft Excel 'Quick Tip'

Hiding An Individual Sheet

Sometimes you will have a sheet in your workbook that contains necessary information, such as tables or tax rates, that may only need to be updated infrequently and you may prefer to have it hidden from view. This 'Quick Tip' will show you how to hide a worksheet in Excel.
  1. Make sure the sheet you want to hide is the active sheet.
  2. From the Format menu, select Sheet, and Hide. The sheet will now be hidden from view. (XL2002: right-click the sheet tab and select Hide).
To unhide a sheet that is hidden, from the Format menu, select Sheet, and Unhide. Select the sheet 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 TheExcelAddict.com/Newsletter.htm and you could win a really cool prize.
You'll be amazed how much time you'll save just by learning a few of these tips.
Copyright All Rights Reserved by

Close this window