In Excel you can show or hide worksheets from sheets tab.

How to hide worksheets

  1. 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.

How to Show or Hide worksheets in Excel

***To cancel selection of multiple worksheets, click unselected sheet or right-click on selected sheet, then click ungroup sheet***

  1. 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 or Hide worksheets in Excel

How to show worksheets

  1. Right-Click on sheet tabs, then click Unhide…

How to Show or Hide worksheets in Excel

  1. on Unhide dialog select worksheets that you want to unhide, then click OK

How to Show or Hide worksheets in Excel