By holding down the Ctrl key while clicking you might select multiple tabs at one time.

On theHometab, click onFormat, which can be found in theCellsgroup.

UnderVisibility, selectHide & Unhide, thenHide Sheet.

Hide and Unhide Worksheets and Workbooks in Excel 2007 & 2010

you could also simply right-press the tab, and selectHide.

Unhide a WorksheetTo unhide a worksheet, you just do the opposite.

On theHometab, click onFormatin theCellsgroup and then underVisibility, selectHide & Unhide, thenUnhide Sheet.

sshot-3

Or, it’s possible for you to right-select any visible tab, and selectUnhide.

In theUnhidepop up window, snag the worksheet to unhide and click OK.

Hiding a WorkbookTo hide the entire Workbook, select theViewtab, and then click theHidebutton.

sshot-11

Youll see the Workbook has disappeared.

Unhide a WorkbookSelect theViewtab and clickUnhide…

… and your Workbook will be visible again.

Just a few simple ways to hide and unhide your Excel worksheets and workbooks.

sshot-4

sshot-5

sshot-12

sshot-6

sshot-14

sshot-16

sshot-15

sshot-8

sshot-9

sshot-10

sshot-7