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:
- Right-click the worksheet tab that you want to hide.
- 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):
- Select the worksheet that you want to hide.
- Click the Home tab in the Ribbon.
- In the Cells group, click Format. A drop-down menu appears.
- In the drop-down menu, under Visibility, select Hide & Unhide and then choose Hide Sheet.
Below is the Cells group in the Ribbon:
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):
- Display the worksheet that you want to hide.
- Press Alt. The Ribbon should appear with key tips.
- 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:
Unhiding a worksheet by right-clicking
To unhide a worksheet by right-clicking:
- Right-click any worksheet tab.
- From the drop-down menu, choose Unhide. A dialog box appears.
- Select the worksheet you want to unhide.
- 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):
- Click the Home tab in the Ribbon.
- In the Cells group, click Format. A drop-down menu appears.
- In the drop-down menu, under Visibility, select Hide & Unhide, and then choose Unhide. A dialog box appears.
- Click the sheet you want to unhide and click OK.
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):
- Press Alt. The Ribbon should appear with Key Tips.
- Press H > O > U > H (press H then O then U then H). A dialog box appears.to activate the Home tab.
- Use the up and down arrow keys to select the sheet you want to unhide.
- 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):
- Right-click any worksheet tab. A drop-down menu appears.
- Choose Unhide. A dialog box appears.
- 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.
- 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)
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 Lock Cells in Excel (Protect Formulas and Data)
It's easy to lock and protect cells in Microsoft Excel to prevent users from changing data or formulas. This involves a two-step process …
How to Stop or Control Green Error Checking Markers in Excel
In Microsoft Excel, errors are flagged with small green marker or triangle in the upper left corner of the cell. However, these indicators display when there may be an error but is, in fact, not an error.
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
