Let’s take a look.
As you build more complicated workbooks, you might want to hide certain worksheets to keep things simple.
The easiest way to hide a worksheet is to right-poke the worksheet tab and choose Hide from the menu.
The worksheet will disappear, and the tab will no longer be visible at the bottom.
The hidden worksheet won’t appear in the pop-up menu either.
To unhide a worksheet, right-punch a visible tab, then choose Unhide from the menu.
Excel will display a list of all hidden worksheets.
grab the worksheet you’d like to unhide, and click OK.
Note, there is no indication that a worksheet is hidden.
However, they can still find and unhide the worksheet if they know how.
you could also hide an unhide worksheets using the Format menu on the home tab of the Ribbon.
To show the hidden worksheet again, select Unhide Sheet from the same menu.
If Unhide Sheet is grayed out, there are no hidden worksheets.
