MS Excel Tips and Tricks Hide Worksheet(S)
December 15th, 2008
- You can hide Microsoft Excel worksheet from any work book
- Open the Workbook that you want to hide the excel worksheets from
- Select the sheet that you want to hide
- You can also select the multiple worksheets, changes will appear in all the sheets
- Go to Format menu
- Click Sheet and Hide
- You will see the selected Excel worksheets vanishing from the view
- If you want to unhide the sheets go to Format menu
- Select sheet and Unhide
- You will get a message window asking for confirmation to open a specific Excel sheet
- Select the Excel worksheet that you want to unhide
- You can unhide the multiple worksheets one by one, you cannot unhide them all together.
- Applicable to Microsoft Excel 2003 and Microsoft Excel 2007
If you have a question or suggestion, please post a comment.
Read more tips and tricks from our website
If you like this post, Please buy me a coffee
Categories: Excel, MS-Office, Office 2003
- Ms Excel Tips and Tricks Hide or Unhide Excel workbook
- MS Excel Tips and Tricks - Hide or Unhide scroll bar
- MS Excel Work Sheet Tips and Tricks
- Excel Tips and Tricks - Hide Gridlines
- MS Excel Tips and Tricks - How to insert Date and Time in Header or Footer
- MS Excel Tips and Tricks – Change the Cell format from Text to Number
- MS Excel Tips and Tricks – Remove or Add Fixed Decimal Points
- MS-Excel Tips and Tricks - Change the Gridline color
- Excel Tips and Tricks Cell Label, Cell Name, Range Name
- MS Excel Tips - Find Duplicates from 2 columns
