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.
The fastest way to hide sheets in Excel is using your mouse right-click. All you need to do is:
Boom! The selected sheets are now hidden and no longer visible in the Excel window.
The second method to hide a worksheet in Excel is using the ribbon. Here are the steps:
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):, , , ,
Don't worry. You don't have to remember these keys. When you hit, Excel will open the keyboard menu. From there, you can select the corresponding letter:
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.
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.
Thousands of people have benefited from my free Excel lessons. My only question is, will you be next?