How to Unhide Sheets in Excel Application? 2 Methods
In this article, you will learn how to unhide sheets in Excel application. For example, you have opened a workbook containing some hide sheets. Now you want to unhide these sheets for some changes or other aspects. So, you may unhide these sheets by following methods.
How to unhide sheets in Excel Application?
If you want to unhide just one or two hidden sheets, here’s how you can quickly unhide them:
- 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).
How to Unhide a sheet in Excel from the ribbon bar?
- Open Your Excel Workbook
- Navigate to the Ribbon Bar:
- Locate the “Home” Tab:
- Within the Home tab find the “Format” Dropdown menu.
- Access “Hide & Unhide” Options:
- Select “Unhide Sheet”:
- Choose the Hidden Sheet:
