How to Unhide Sheets in Excel


Home >> How to Use Excel Tutorial >> Excel Tips and Trick >> How to Unhide Sheets in Excel



In this tutorial, it will be explained how to unhide sheets in excel. The ways of how to unhide worksheets in excel 2013, 2016, or the other versions of this software are similar in principles. You should be able to practice the steps given here for whatever version you have with no/very little modification.


Why do We Need to Know How to Show Hidden Sheets in Excel?


In the data processing process on the spreadsheet, sometimes there is a need to hide our worksheets. This is needed because probably the function of their contents is just as a support for the data processing process or maybe the contents are confidential data so we do not want to show them to other people. But after hiding them, there are times when we need to show them again when we need to revise the contents of those worksheets. If we cannot do it, then, of course, it will be very troublesome because that means the revision that we need to do cannot be done.

As an example of this need in our job, imagine if we do a pretty complex data processing for the annual company performance analysis. For a comprehensive analysis process such as this, usually there are many data and processing process involved so we can get an optimal result. For that, maybe we will need some worksheets to just support the data processing that we do so we can get the analysis result that we want.

To make it easier for other people when they see the analysis result, then we need to hide some of the worksheets contents that just function as the analysis support. However, we surely want that when the people who are involved in the analysis process open the spreadsheet file, they can show them back so the data processing for the analysis can be done. For that, the people who also have the task to do the analysis need to understand how to unhide hidden sheets in excel.

Some methods can be utilized to do it. By understanding each method of how to unhide sheets in excel, then the understanding should help you when there is a need to hide and unhide the worksheets in your spreadsheet file dynamically.


What is How to Unhide Sheets in Excel?


How to unhide sheets in excel is a function in this spreadsheet tool with the usage objective to unhide the worksheets that are previously hidden so they can be accessed again. This function of how to unhide sheets in excel is needed especially if you need to do a data processing by using more than one worksheets with the unique function for each.


How to See Hidden Sheets in Excel?


The following will explain the steps for the three methods on how to unhide sheets in excel. The first two methods can only be used to show one worksheet each time they are used while the last method can be used to show more than one.


Method 1: Format Menu

  1. In the Home Tab, click Format

    How to Unhide Sheets in Excel - Screenshot of Step 1-1

  2. Highlight Hide & Unhide then click Unhide Sheet…

    How to Unhide Sheets in Excel - Screenshot of Step 1-2

  3. Pick the worksheet that you want to unhide

    How to Unhide Sheets in Excel - Screenshot of Step 1-3

  4. Done!

    How to Unhide Sheets in Excel - Screenshot of Step 1-4




Method 2: Right-Click

  1. Right-click on one of your worksheets

    How to Unhide Sheets in Excel - Screenshot of Step 2-1

  2. Click Unhide...

    How to Unhide Sheets in Excel - Screenshot of Step 2-2

  3. Pick the worksheet that you want to unhide

    How to Unhide Sheets in Excel - Screenshot of Step 2-3

  4. Done!

    How to Unhide Sheets in Excel - Screenshot of Step 2-4




Method 3: Custom Views

If you use this method, then you need to save the view before your worksheets are hidden so it to be loaded again when you want to unhide them.

Saving the View

  1. In the View Tab, click Custom View

    How to Unhide Sheets in Excel - Screenshot of Step 3-1-1

  2. Click on the + sign

    How to Unhide Sheets in Excel - Screenshot of Step 3-1-2

  3. Give the name for the view then click OK

    How to Unhide Sheets in Excel - Screenshot of Step 3-1-3


Loading the View

  1. In the View Tab, click Custom View

    How to Unhide Sheets in Excel - Screenshot of Step 3-2-1

  2. Highlight the view name where you save the view in which all the worksheets that you want to show are still there then click OK

    How to Unhide Sheets in Excel - Screenshot of Step 3-2-2

  3. Done!

    How to Unhide Sheets in Excel - Screenshot of Step 3-2-3



Exercise


After you have understood the three methods of how to unhide sheets in excel from the tutorial part above, now is the time you practice them to sharpen your understanding!

Download the exercise file of how to unhide sheets in excel and do the instruction below.

Link to the exercise file:
Download here

Instruction:

Try to show the worksheet with the name A using method 1, with the name B using method 2, then do method 3 by simulating how to save and load the view of your worksheet!

What is the result? Can you do the instruction?


Additional Notes

  • The Custom Views method will also load the tables look that you use in excel with the table look which are loaded are the ones when the view is saved
  • Sometimes there are hidden worksheets with a Very Hidden status. The hiding process with this status is usually used when the content is very confidential and you don’t want it to be seen by other people. If you want to show the sheets with this status, then you need to know how to use VBA codes and write the code that is needed correctly




Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


Hand-Picked CE Tutorials

Excel Calculation

How to Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division Excel Calculation

Average Excel Calculation



Excel Formula

VLOOKUP Excel Formula

Excel IF Function

SUM Formula in Excel

COUNTIF Formula in Excel

COUNT Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text Excel

Excel Worksheet Definition

Excel Range Definition

How to Add Columns in Excel



Excel Consultation

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2021 Compute Expert