How to Hide/Unhide a worksheet in Excel
Posted by on 25th, 2008
This is a simple excel Tip on how to hide a worksheet and how to unhide it.
- Goto the Sheet you want to hide. Then from Menu choose Format -> Sheet -> Hide
The Sheet 1 would be now Hidden. To unhide it, you need to again goto Format -> Sheet -> unhide. When you click on unhide you would be asked which sheet to unhide from a list of hidden sheet (incase you have opted to hide many sheets,in our case only sheet1 is hidden).
You can see in the above picture that there is no Sheet1. Sheet 2 is only shown as sheet is hidden.
From the above popup select the sheet to unhide and Press Ok. Sheet 1 would be back Visible again.
Popularity: 6% [?]
If you enjoyed this post, make sure you subscribe to my RSS feed!
most broadband services are crappy, they can’t maintain high data transfer rates -’-
November 24th, 2010 at 5:28 pm