This guide teaches you how to hide and unhide sheets in Excel.
Sometimes you might want to hide a specific sheet in an Excel file. For example, maybe you are giving an Excel presentation and want to hide all the irrelevant sheets so that it doesn’t clutter the user interface and confuse you while giving the presentation. Whatever the reason, Excel has a built-in feature that makes hiding sheets easy.
Of course, once you hid a sheet, it is only natural that you want to unhide sheets in Excel as and when needed. There is a built-in option for that too. Let me teach you how to do it in simple and easy steps with screenshots.
Table of contents:
How to hide sheets in Excel
Follow the steps below to hide a sheet in Excel:
Step 1: Open the Excel file in the Microsoft Excel application.
First of all, open the Excel document. You can either double-click on the Excel file or open Excel from the Start menu, click the “Open > Browse” option, select the Excel file, and click the “Open” button.
Step 2: Right-click on the sheet tab and select “Hide.”
To hide an Excel sheet, right-click on the sheet tab at the bottom and select the “Hide” option from the context menu.
This action immediately hides the sheet.
Step 3: Use Ctrl + Click to select and hide multiple sheets in Excel.
If you want to hide multiple sheets at once, hold down the Ctrl key on your keyboard and click on the sheet tabs to select them.
Next, right-click and select the “Hide” option.
The sheets are hidden instantly.
How to unhide sheets in Excel
Follow the steps below to unhide sheets in Excel:
Step 1: Open the Excel file.
If it is not already opened, open the Excel file with hidden sheets. You can either double-click on the file or open it directly from the Excel application. To open a file in Excel, open the application, go to “Open > Browse,” select the file and click/tap “Open.”
Step 2: Right-click on a sheet tab at the bottom and select “Unhide.”
After opening the Excel file, you will see all your sheets at the bottom. Right-click on any sheet tab of your choice and select the “Unhide” option.
Step 3: Select the select and click “Ok.”
The above action will show all the hidden sheets in a new dialog box. Select the sheet you want to unhide and click the “Ok” button.
To unhide multiple sheets, right-click on the sheet tab, select “Unhide,” select the sheet, and click “Ok.” a.k.a, do the same thing again.
How to see all hidden sheets in Excel
If you want to see what sheets are hidden in your Excel file, follow these steps.
- Open the Excel file.
- Right-click any sheet tab at the bottom.
- Select the “Unhide” option.
- The Unhide window shows all the hidden sheets in your Excel file.
- Close the Excel document if needed.
—
That is all. It is that simple to hide and unhide Excel sheets.
I hope this simple and easy how-to guide helped you.
If you are stuck or need help, send an email, and I will try to help as much as possible.
