How to Hide Sheets in Excel Application? Helpful Guide
In this guide, we’ll navigate the simple steps of how to hide a sheet in Excel application. Normally when you open an Excel workbook, it shows the number of sheets at the bottom tab. After creating a complete data file, some sheets will contain formulas or some financial figures that you may hide from others.
So, Excel provides a straightforward solution for this—hiding sheets. Whether you’re guarding financial figures or simply streamlining your workbook, concealing a sheet is an essential technique.
How to hide sheets in Excel?
Before hiding a sheet or sheets in Excel, you must select them before hiding.
How to select worksheets in Excel
Follow the below steps if you want to select one or multiple or all worksheets in Excel:
- To select a single sheet, click on the sheet tab, e.g you want to select sheet1. Click on the Sheet1 tab.
- To select multiple contiguous sheets, click the first sheet tab, i.e., click on Sheet1, hold down the Shift key, and click on the last sheet i.e. Sheet4.
- To select multiple non–contiguous sheets, hold down the Ctrl key on the keyboard and click on the desired sheet tabs individually.
- To select all sheets, right-click any sheet tab, and then click on Select All Sheets, as noted in the above screenshot.
Once you have selected sheet or sheets, then you can use the following methods to hide sheet or sheets in Excel.
Method 1: By right-clicking the mouse
- Select one or more sheets you want to hide.
- Right-click the selected sheets and choose Hide from the context menu, as you can see in the above screenshot.
- Your sheet or sheets will hide from the list.
Method 2: Using the Ribbon Bar
Another way to hide worksheets in the Excel application is by clicking the Hide Sheet command on the ribbon bar.
- Select the sheet you want to hide.
- On the Home tab, in the Cells group, click Format.
- Under Visibility, point to Hide & Unhide, and click Hide Sheet.
