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 2019 Avantix® Learning Inc.

You may also like

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