Hiding and Unhiding Worksheet Tabs in Microsoft Excel

by Avantix Learning Team | Updated November 24, 2019

Applies to: Microsoft Excel 2010, 2013, 2016, 2019 and 365 (Windows)

You can hide many things in Excel including worksheets, workbooks, rows, columns, formulas and comments. It’s not difficult to hide and unhide Excel worksheets. The trick is to remember that you’ve hidden them. If you do choose to hide worksheets, you can still reference them in other worksheets or workbooks and unhide them. If you have trouble unhiding a worksheet, protection may have been enabled or a user has used VBA (Visual Basic for Applications) to hide the sheet.

Recommended articles: Hiding Notes in Excel (Inserting, Editing, Showing, Hiding and Deleting Comments) or How to Hide Excel Formulas from Clients, Colleagues and Other Users

The following are three methods for hiding a worksheet.

Hiding a worksheet tab using the Ribbon and a mouse

To hide a worksheet in an Excel workbook using the Ribbon and a mouse (or track pad):

  1. Select the worksheet that you want to hide.
  2. Click the Home tab in the Ribbon.
  3. In the Cells group, click Format. A drop-down menu appears.
  4. In the drop-down menu, under Visibility, select Hide & Unhide and then choose Hide Sheet.

Below is the Cells group in the Ribbon in Excel 2010:

Cells group in the Ribbon in Microsoft Excel 2010.

Hiding a worksheet tab using the Ribbon and a keyboard

To hide a worksheet in an Excel workbook using the Ribbon and a keyboard

  1. Display the worksheet that you want to hide.
  2. Press Alt. The Ribbon should appear with Key Tips.
  3. Press H to activate the Home tab.
  4. Press O to select Format.
  5. Press U to select Hide & Unhide.
  6. Press S to select Hide Sheet.

Below is the cells group in the Ribbon in Excel 2010 with Key Tips displayed:

Cells group in the Ribbon in Excel 2010 with labels or bades.

Hiding a worksheet tab by right-clicking

To hide a worksheet in an Excel workbook by right-clicking:

  1. Right-click the worksheet tab that you wish to hide.
  2. From the drop-down menu, choose Hide.

Unhiding a worksheet tab using the Ribbon and a mouse

To unhide a worksheet in an Excel workbook using the Ribbon and a mouse (or trackpad):

  1. Click the Home tab in the Ribbon.
  2. In the Cells group, click Format. A drop-down menu appears.
  3. In the drop-down menu, under Visibility, select Hide & Unhide, and then choose Unhide. A dialog box appears.
  4. Click the sheet you wish to unhide and click OK.

Unhide worksheet dialog in Excel 2010.

Unhiding a worksheet tab using the Ribbon and a keyboard

To unhide a worksheet in an Excel workbook using the Ribbon and a keyboard:

  1. Press Alt. The Ribbon should appear with Key Tips.
  2. Press H to activate the Home tab.
  3. Press O to select Format.
  4. Press U to select Hide & Unhide.
  5. Press H to select Unhide Sheet. A dialog box appears.
  6. Use the up and down arrow keys to select the sheet you wish to unhide.
  7. Press Enter to select OK.

Unhiding a worksheet tab by right-clicking

To unhide a worksheet by right-clicking:

  1. Right-click any worksheet tab.
  2. From the drop-down menu, choose Unhide. A dialog box appears.
  3. Select the worksheet you wish to unhide.
  4. Click OK.

If Unhide is disabled, there are no hidden sheets. Unfortunately, you can only unhide one worksheet at a time using this method.

Subscribe to get more articles like this one

Did you find this article helpful? If you would like to receive new articles, join our email list.

To request this page in an alternate format, contact us.

Recommended Microsoft Excel training courses

Microsoft Excel: Intermediate / Advanced

Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools

Microsoft Excel: Introduction to VBA (Visual Basic for Applications)

Microsoft Excel: Introduction to Power Pivot and Power Query Business Intelligence Tools

VIEW MORE COURSES >

Copyright 2020 Avantix® Learning Inc.

You may also like

How to Delete a Pivot Table in Excel

How to Delete a Pivot Table in Excel

A pivot table can be deleted in an Excel workbook in several ways. You can delete a pivot table, convert a pivot table to values or clear data and customizations from a pivot table to reset it. When a pivot table is created from source data in a workbook,

How to Change Commas to Decimal Points and Vice Versa in Excel (5 Ways)

How to Change Commas to Decimal Points and Vice Versa in Excel (5 Ways)

Depending on your country or region, Excel may display decimal points or dots instead of commas for larger numbers. The decimal point (.) or comma (,) is used as the group separator in different regions in the world. You can change commas to decimal points or dots or vice versa in your Excel workbook temporarily or permanently.

How to Group by Month and Year in a Pivot Table in Excel

How to Group by Month and Year in a Pivot Table in Excel

You can group by month, year or other date period in a pivot table in Excel. One option is to group by date periods in a pivot table using the Grouping feature. Alternatively, you can also create calculations in source data to extract the month name and the year from a date field and use the fields in your pivot table.

Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.

Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca

Summary
How to Hide Microsoft Excel Worksheets (3 Ways)
Article Name
How to Hide Microsoft Excel Worksheets (3 Ways)
Description
Learn how to hide and unhide Excel worksheets. The trick is to remember that you've hidden them. If you do choose to hide worksheets, you can still reference them in other worksheets or workbooks and unhide them.
Author
Publisher Name
Avantix Learning Inc.

Pin It on Pinterest

Share This