How to Hide Sheets in Excel
From this tutorial, you will learn how to hide sheets in Excel.
When we work by using Excel, we may sometimes need to hide some of the worksheets we have. This can be because we want to focus on some other worksheets exclusively at the moment or we just want to hide them from other people to see since they only consist of background data processing.
Whatever our reasons are, we need to know the way to do the hiding process. If you haven’t known them yet, then Compute Expert will introduce three ways to do that easily for you.
Want to know what are those three ways and how to implement them fast? Read this tutorial until its last part.
Disclaimer: This post may contain affiliate links from which we earn commission from qualifying purchases/actions at no additional cost for you. Learn more
Want to work faster and easier in Excel? Install and use Excel add-ins! Read this article to know the best Excel add-ins to use according to us!
Table of Contents:
How to Hide Sheets in Excel 1: Format Menu
Now, let’s discuss the first method to hide sheets in Excel. This first method utilizes your Excel ribbon at its Home tab.-
Select the worksheet tabs you want to hide at the bottom right part of your workbook. To select more than one tab, press and hold Shift (to select all the sheet tabs between the tabs you click) or Ctrl (to select only the tabs you click) and click on all the sheet tabs you want to hide
-
Go to the Home tab of your Excel ribbon and click the Format dropdown button there
-
Highlight the Hide & Unhide choice from the dropdown list with your pointer and click Hide Sheet
-
Done! The sheets which tabs you selected are now hidden
How to Hide Sheets in Excel 2: Right-Click
Another way to hide sheets in Excel is by right-clicking on the sheet tabs. Here are the detailed steps of it.-
Select the worksheet tabs you want to hide at the bottom right part of your workbook. To select more than one tab, press and hold Shift (to select all the sheet tabs between the tabs you click) or Ctrl (to select only the tabs you click) and click on all the sheet tabs you want to hide
-
Right-click on one of the sheet tabs you selected and click Hide
-
Done! The sheets which tabs you selected are now hidden
How to Hide Sheets in Excel 3: Keyboard Shortcuts (Only Windows)
The last way to hide sheets in Excel that we will discuss here is by using the keyboard shortcuts, more particularly the keyboard shortcuts for the Excel ribbon. Unfortunately, these shortcuts only work if you run Excel in Windows as Excel on Mac doesn’t have ribbon shortcuts.-
Select the worksheet tabs you want to hide at the bottom right part of your workbook. To select more than one tab, press and hold Shift (to select all the sheet tabs between the tabs you click) or Ctrl (to select only the tabs you click) and click on all the sheet tabs you want to hide
- Press Alt, H, O, U, and S buttons in a sequence on your keyboard
-
Done! The sheets which tabs you selected are now hidden
Excel articles/tutorials you might want to read:
