Hidden Sheets

mmatte77 

Hide or Unhide worksheets

Hide or unhide a worksheet

1. Select the worksheets that you want to hide.

   How to select worksheets

   To selectDo this

   A single sheet	Click the sheet tab.     If you don't see the tab that you want, click the scrolling buttons to the left of the sheet tabs to display the tab, and then click the tab.
   Two or more adjacent sheets	Click the tab for the first sheet. Then hold down Shift while you click the tab for the last sheet that you want to select.
   Two or more nonadjacent sheets	Click the tab for the first sheet. Then hold down Command while you click the tabs of the other sheets that you want to select.
   All sheets in a workbook	Right-click a sheet tab, and then click Select All Sheets on the shortcut menu.

2. On the Home tab, click Format > under Visibility > Hide & Unhide > Hide Sheet.

3. To unhide worksheets, follow the same steps, but select Unhide. The Unhide dialog box displays a list of hidden sheets, so select the ones you want to unhide and then select OK.

    

   Hope I was able to help you with this info.

    

    

   Nikolino

   I know I don't know anything (Socrates)

    

   * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.