How to Unhide Sheets in Excel Application? 2 Easy Methods

In this article, you will learn how to unhide sheets in Excel application. This is a very important feature in Excel application. For example, you have opened a workbook containing some hidden sheets. Now you want to unhide these sheets for some changes or other aspects. So, you may unhide these sheets by following these methods.

How to Unhide Sheets in Excel Application
Unhide Sheets in Excel Application

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:

Method-01

  1. Right-click on the sheet tab. A context menu will appear; select Unhide. The Unhide dialog box will appear.
  2. 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.

  1. Open your Excel workbook containing one hidden sheet or more.
  2. Navigate to the Ribbon Bar, and click on the “Home” Tab.
  3. Within the Home tab, find the “Format” option. A dropdown list will be opened.
  4. Choose the “Hide & Unhide” option.
  5. Now click on the “Unhide Sheet“.
  6. Select the “Hidden Sheet“.
  7. Click “Ok“.

Similar Posts