Hide or Unhide Excel Worksheets

by Avantix Learning Team | Updated February 12, 2022

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

You can hide or unhide Excel worksheets using the Ribbon, the right-click menu or keyboard shortcuts. If you hide worksheets, you can still reference them in other worksheets or workbooks. If you have Excel 365, you can now quickly unhide multiple worksheets or all worksheets. If you have trouble hiding or unhiding a worksheet, protection may have been enabled or a user has used VBA (Visual Basic for Applications) to hide the sheet.

Recommended articles: How to Hide Excel Formulas from Clients, Colleagues and Other Users

The following are several methods to hide or unhide worksheets in Excel.

Hiding a worksheet by right-clicking

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

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

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:

Cells group in the Ribbon in Excel with commands to hide and unhide worksheets.

Hiding a worksheet using the Ribbon and keyboard shortcuts

To hide a worksheet in an Excel workbook using the Ribbon and keyboard shortcuts (key tips):

  1. Display the worksheet that you want to hide.
  2. Press Alt. The Ribbon should appear with key tips.
  3. Press H > O > U > S. This is a sequential shortcut so press each key in order.

Below is the cells group in the Ribbon with key tips displayed:

Cells group in the Ribbon in Excel with key tips to show or hide worksheets.

Unhiding a worksheet 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 want to unhide.
  4. Click OK.

If Unhide is disabled, there are no hidden sheets.

Unhiding a worksheet 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 want to unhide and click OK.

Unhide worksheet dialog box in Excel.

If Unhide is disabled, there are no hidden sheets.

Unhiding a worksheet using the Ribbon and keyboard shortcuts

To unhide a worksheet in an Excel workbook using the Ribbon and keyboard shortcuts (key tips):

  1. Press Alt. The Ribbon should appear with Key Tips.
  2. Press H > O > U > H (press H then O then U then H). A dialog box appears.to activate the Home tab.
  3. Use the up and down arrow keys to select the sheet you want to unhide.
  4. Press Enter to select OK.

Unhiding all worksheets or multiple worksheets

If you have Excel 365, you can now unhide multiple sheets or all sheets:

To unhide all worksheets by right-clicking (or unhide multiple sheets):

  1. Right-click any worksheet tab. A drop-down menu appears.
  2. Choose Unhide. A dialog box appears.
  3. Click the first worksheet and Shift-click the last worksheet if you want to unhide all worksheets. Alternatively, Ctrl-click specific sheets if you want to unhide some of the worksheets.
  4. Click OK.

You can use this method if you access the dialog box through the Ribbon as well.

This article was first published on January 15, 2015 and has been updated for clarity and content.

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.

More resources

How to Merge Cells in Excel (with Shortcuts)

3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells

How to Highlight Errors, Blanks and Duplicates in Excel Worksheets

10 Great Excel Navigation Shortcuts to Move Around in Workbooks

How to Replace Blank Cells with a Value from the Cell Above in Excel

Related courses

Microsoft Excel: Intermediate / Advanced

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

Microsoft Excel: Introduction to Power Query to Get and Transform Data

Microsoft Excel: New and Essential Features and Functions in Excel 365

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

VIEW MORE COURSES >

Our instructor-led courses are delivered in virtual classroom format or at our downtown Toronto location at 18 King Street East, Suite 1400, Toronto, Ontario, Canada (some in-person classroom courses may also be delivered at an alternate downtown Toronto location). Contact us at info@avantixlearning.ca if you'd like to arrange custom instructor-led virtual classroom or onsite training on a date that's convenient for you.

Copyright 2022 Avantix® Learning

You may also like

How to Password Protect Your Excel Worksheets and Workbooks

How to Password Protect Your Excel Worksheets and Workbooks

You can password protect worksheets and workbooks in Excel. If you want to prevent other users from opening or modifying an Excel workbook, you can encrypt the file with a password. You can also protect workbook structure where you can prevent users from deleting, renaming, moving or unhiding worksheets. Password protection can be added to your Excel file in several ways.

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 |18 King Street East, Suite 1400, Toronto, Ontario, Canada M5C 1C4 | Contact us at info@avantixlearning.ca

Summary
How to Hide or Unhide Excel Worksheets (and Unhide All Sheets)
Article Name
How to Hide or Unhide Excel Worksheets (and Unhide All Sheets)
Description
You can hide or unhide Excel worksheets using the Ribbon, the right-click menu or keyboard shortcuts. If you hide worksheets, you can still reference them in other worksheets or workbooks. If you have Excel 365, you can now quickly unhide multiple worksheets or all worksheets. If you have trouble hiding or unhiding a worksheet, protection may have been enabled or a user has used VBA (Visual Basic for Applications) to hide the sheet.
Author
Publisher Name
Avantix Learning

Pin It on Pinterest

Share This