How to Unhide Excel Sheet: A Quick and Simple Guide

Right-click the sheet tab you want to hide, or any visible sheet if you want to unhide sheets. On the menu that appears, do one of the following: To hide the sheet, select Hide. To unhide hidden sheets, select them in the Unhide dialog that appears, and then select OK .

Excel is a powerful tool that helps us organize and analyze data. However, when working with large spreadsheets, it can become cluttered and difficult to navigate. One way to clean up your workspace is by hiding unnecessary worksheets. In this article, we’ll show you how to hide and unhide worksheets in Excel.

First, download the tutorial workbook from This will be our test sheet. For demonstration purposes, we’ll use Sheet 1 as the test sheet and put two numbers in cell A1. On Sheet 2, we’ll link to Sheet 1 by hitting equals and selecting Sheet 1 cell A1.

To hide Sheet 1, right-click on the sheet tab and select “Hide” from the menu. The sheet will disappear from view, but you can still reference it in other sheets. To unhide Sheet 1, right-click on any sheet tab, select “Unhide” from the menu, and choose the desired sheet from the list.

Hiding worksheets in Excel allows you to clean up your workspace while still being able to reference hidden sheets. It’s a simple process that can help you stay organized and efficient when working with large spreadsheets.


Why can't I unhide an Excel spreadsheet?
If the workbook contains only very hidden sheets, you won't even be able to open the Unhide dialog box because the Unhide command will be disabled. If the workbook contains both hidden and very hidden sheets, the Unhide dialog will be available, but very hidden sheets won't be listed there.
How do I unhide Excel quickly?
On the Home tab, in the Cells group, click Format. Do one of the following: Under Visibility, click Hide &, Unhide, and then click Unhide Rows or Unhide Columns.