Hide or Unhide a Worksheet by Hand in Excel

Add to Favorites

I'll show you how to hide worksheets in Excel so that a user cannot see them but you can still access data on them.

This method is the simplest way to hide a sheet and it will still allow you to easily access it when you need to.  This is especially good when you want to hide a source data tab or simply reduce clutter in the workbook.

Hide a Worksheet in Excel

  1. Right-click the worksheet tab that you want to hide and click Hide

 

Result:

Notice that Sheet1 is now gone.

Unhide a Worksheet in Excel

  1. Right-click a remaining worksheet tab and click Unhide

  2. Select the sheet that you want to make visible in the workbook and then hit the OK button.

Result:

Notes

This is a simple and easy way to hide a worksheet in Excel but it is not secure.  Anyone to whom you send this workbook can unhide the worksheet and read what's in it or change what's in it.

This method is good for hiding tabs that don't need to be visible to everyone and that might cause them confusion.  For example, you will often want to hide any tabs that contain raw data, because you don't want a user to accidentally corrupt that data; but only use this method to hide the raw data if it's not a big deal if the user does see it.


Downloadable Files: Excel File

Similar Content on TeachExcel
View Different Parts of a Worksheet at Once in Excel
Tutorial: View different sections of the same worksheet when the sections are far apart.  This allo...
Limit the Total Amount a User Can Enter into a Range of Cells in Excel
Tutorial: How to limit the amount that a user can enter into a range of cells in Excel.  This works ...
Loop through a Range of Cells in Excel VBA/Macros
Tutorial: How to use VBA/Macros to iterate through each cell in a range, either a row, a column, or ...
Hide Data Within a Worksheet in Excel
Tutorial: In Excel you can actually hide data that is stored within a worksheet. This allows you to ...
Hide or Protect a Tab in Excel - 2 ways
Tutorial: Two ways to hide worksheets in Excel. Method 1 You can create a little macro to assign a p...
Input Form to Get Data and Store it in Another Tab in Excel
Tutorial: How to make a user input form in Excel and have the data stored on another worksheet at th...