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: 9% [?]
