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



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.



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

Question? Ask it in our Excel Forum

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Custom Data Views Controlled by a Drop Down Menu in Excel
Tutorial: This trick allows you to easily perform a nice visual analysis of data in Excel without m...
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 all...
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 ...
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...