How to Unhide Sheets in Excel Application? 3 Easy Methods
In this article, you will learn how to unhide sheets in Excel application. It is a very important feature in the Excel application. For example, you have opened a workbook containing some hidden sheets. And now you want to unhide these sheets for some changes or other aspects. So, you may unhide these sheets by following these important methods.
How to unhide sheets in Excel application?
To unhide one or more hidden sheets in your workbook, here are the steps for how you can quickly unhide them: The above screenshot for your help.
Method-01
- Right-click on the sheet tab. A context menu will appear; select Unhide. The Unhide dialog box will appear.
- In the Unhide dialog box, select the hidden sheet you want to display and click OK (or double-click the sheet name).
Method-02:
In this method, you learn how to unhide a sheet in Excel from the ribbon bar.
- Open your Excel workbook containing one hidden sheet or more.
- Navigate to the Ribbon Bar, and click on the “Home” Tab.
- Within the Home tab, find the “Format” option. A dropdown list will be opened.
- Choose the “Hide & Unhide” option.
- Now click on the “Unhide Sheet“.
- Select the “Hidden Sheet“.
- Click “Ok“.
Method 3: How to unhide sheets in Excel using VBA?
The below VBA code is used to unhide all hidden or very hidden sheets in an Excel workbook. A very hidden sheet can only be unhidden with VBA code. You can assign the property xlSheetHidden or xlSheetVeryHidden.
Sub UnHide()
Dim sheet As Worksheet
For Each sheet In Worksheets
sheet.Visible = True
Next
End Sub
