In Excel you can show or hide worksheets from sheets tab.
How to hide worksheets
- Select worksheets that you want to hide it. If you want to hide two or more adjacent worksheets press SHIFT and click, if nonadjacent worksheets press CTRL and click worksheets that you want.
***To cancel selection of multiple worksheets, click unselected sheet or right-click on selected sheet, then click ungroup sheet***
- Right-click on selected sheet, then click Hide on shortcut menu. Or on Home tab, in Cells group, click Format, Click Hide & Unhide, then click Hide Sheet
How to show worksheets
- Right-Click on sheet tabs, then click Unhide…
- on Unhide dialog select worksheets that you want to unhide, then click OK