How to hide sheets in Excel [3 methods]

April 22, 2022

Learn how to hide sheets in Excel using three different ways: with the mouse right-click, using the ribbon, or using a keyboard shortcut.

Why would you need to hide a worksheet in Excel? Well, maybe you have some source data, and you don't want it to be visible, or you simply want to keep all your drop-down lists hidden from the public eye. Whatever the reason, you can hide as many sheets as you need using a few quick methods. Just remember, at least one sheet needs to remain visible.

How to hide sheets in Excel with right-click menu

The fastest way to hide sheets in Excel is using your mouse right-click. All you need to do is:

  • Select the sheet or group of sheets to hide. If you struggle, use this article to learn how to group worksheets in Excel.
  • Right-click the selection and choose Hide from the menu.
How to hide sheets in Excel with right-click menu

Boom! The selected sheets are now hidden and no longer visible in the Excel window.

How to hide worksheet using the ribbon

The second method to hide a worksheet in Excel is using the ribbon. Here are the steps:

  1. Select any visible sheet or grouped sheets that you want to hide.
  2. Navigate to the Home tab, locate the Cells group, and click Format.
  3. In the dialox box, look for the Visibility section, click Hide & Unhide, and select Hide Sheet.
Hide worksheets in Excel using the ribbon menu

Keyboard shortcut to hide Excel sheets

While Microsoft Excel provides no keyboard shortcut for hiding sheets, you can hide a worksheet using just your keyboard. To do so, press the following keys one by one (in a sequence, not all together): ALTHOUS

How to hide Excel sheet using only your keyboard

Don't worry. You don't have to remember these keys. When you hit ALT, Excel will open the keyboard menu. From there, you can select the corresponding letter:

  • H - selects the Home menu
  • O - opens the Format panel
  • U - selects the Hide & Unhide menu
  • S - selects Hide Sheet
How to hide worksheets in Excel using a keyboard shortcut

How to tell if there are hidden sheets

If your Excel workbook doesn't have any hidden sheets, the Unhide button is grayed out and cannot be pressed. If one or multiple sheets are hidden, then the Unhide button can be pushed, and you can use one of the above methods to unhide them. You can unhide multiple sheets at once, or one by one.

What to do next?

As you've seen, it's really simple to hide worksheets in Excel. If you need to unhide any hidden worksheets, it's just as easy.

If you have any Excel questions or how to work faster and more productively, don't hesitate to reach out. Write a comment, and I will get back to you as soon as possible.

About me
Radu from ExcelExplained

My name is Radu Meghes, and I'm the owner of excelexplained.com. Over the past 15+ years, I have been using Microsoft Excel in my day-to-day job. I’ve worked as an investment and business analyst, and Excel has always been my most powerful weapon. Its flexibility and complexity make it a highly demanded skill for finance employees. I launched excelexplained.com back in 2017, and it has become a trusted source for Excel tutorials for hundreds of thousands of people each year.

If you'd like to get in touch, you can contact me on LinkedIn.

Thousands of people have benefited from my free Excel lessons. My only question is, will you be next?

Essential Functions

Popular Articles

Excel is a very complex application, and understanding it on your own may prove difficult and time-consuming. I have created ExcelExplained.com to help you better understand each function and provide useful examples for different tasks. If you can’t find the answer to your question in one of the published articles, please leave a comment or send me an email, and I will do my best to help you out.

Affiliate Disclosure: When you purchase a product through a link on our website, I may earn an affiliate commission. There are no additional costs to you.
Copyright © 2017-2022 ExcelExplained.com
>