If you use a separate sheet in your Excel workbook to store values or formulas referenced by other sheets, you may want to make that sheet invisible. Great news! In Excel, you can easily hide sheets in a workbook.
You can even hide the entire workbook completely, although it’s not very clear why you might want to do this. Anyway, we’ll show you how to hide worksheets and workbooks and show them again.
Hiding sheets
To hide the sheet (the tabs at the very bottom of the Excel window), right-click on the tab you want to hide, and in the context menu, click Hide (Hide). The shortcut will disappear, but not permanently removed.
You cannot hide all sheets in a workbook. If you try to hide the last visible sheet, you will get this warning:
The workbook must contain at least one visible sheet.
To hide, delete, or move selected sheets, you must first insert a new sheet or make the hidden sheet visible.
To display the sheet, right-click on any visible tab and select from the menu that appears Show (Unhide).
In the dialog box that appears Show hidden sheet (Unhide) select the sheet you want to make visible and click OK.
Note: You can only make one sheet visible at a time.
In addition, you can show hidden sheets in another way. Go to the tab Home (Home). In chapter Cells (Cells) click Framework (Format). In a command group Visibility (Visibility) click Hide and show (Hide & Unhide) and in the menu that opens, select Display Sheet (Unhide Sheet).
A dialog box will appear Show hidden sheet (Unhide). Select the desired sheet and click OK, as described above.
Hide the workbook completely
To completely hide the Excel workbook, click the View (View).
In section Window (Window) click Hide (Hide).
The Excel window will remain open, but the table area will be blank. To display the workbook, click View > Window > display (View > Window > Unhide).
A dialog box will appear Displaying a Hidden Book Window (Unhide) with a list of currently open workbooks. If you hid workbooks that are not currently open, then they will not be in this list.
If you hide the workbook and save the file, the next time you open that file, the workbook will still be hidden. The book will remain hidden until you show it yourself.
Note: All sheets that were already hidden when you hide the workbook will remain hidden when you display the workbook.