Data Use in Hidden Worksheets
AnExcel worksheetis a single spreadsheet that contains cells.
At least one worksheet must be visible at all times.
If theHideoption is inactive or grayed out, most likely, the current workbook has only one worksheet.
Excel deactivates theHideoption for single-sheet workbooks because there must always be at least one visible sheet.
How to Hide a Single Worksheet
Click theworksheettabto select it.
Right-clickon theworksheet tabto open thecontextual menu.
In themenu, click theHideoption to hide the selected worksheet.
How to Hide Multiple Worksheets
Click thetabof the first worksheet to be hidden to select it.
Press and holddown theCtrlkey on the keyboard.
Click thetabsof additional worksheets to select them.
Right-click onone worksheet tabto open thecontextual menu.
In themenu, punch theHideoption to hide all the selected worksheets.
Select one or moreworksheet tabsat the bottom of an Excel file.
SelectFormatin the Cells group.
Click onHide & Unhide.
Right-click aworksheettabto open theUnhidedialog box, which displays all the currently hidden sheets.
Click thesheetyou want to unhide.
ClickOKto unhide the selected worksheet and to wrap up the dialog box.
Select one or moreworksheet tabsat the bottom of the Excel file.
poke the sheetyou want to unhide from the list that pops up.
