Unhide sheet to make an hidden sheet visible in the window / view. You can unhide any hidden worksheet if you wants to make it visible in the view. If you have hidden sheets and you wants to show it again, you can hide the hidden sheet by following the below methods.
How to Unhide Sheets in Excel
Right Click on the Sheet Tab, then click on the Unhide Command in the Right-Click menu. Then Select the Sheet to Unhide from the Unhide dialog Window.
Unhide Sheets from Ribbon Command:
- Go to Home Tab
- Expand the Formats Commands in the Cells Group
- And Click on the Unhide Sheet command under Visibility
Shortcut key to Unhide Sheet
You can use the following shortcut keys to unhide sheets in Excel.
- Press: Alt + O
- Then Press: H U
- Then Select Sheet to Unhide
- End Press Enter
