Hide and Unhide Sheet Tabs

In this topic, you will learn how to hide and unhide sheet tabs.


  1. From the Home Tab and the Cells Group, select Format.

    Step 1
  2. Under Visibility, select Hide Sheet.

    Step 2

    Note: Sheet1 is hidden.  



    Now, unhide the sheet.


    Step 3
  4. Select Format from the Cells Group.

    Step 4
  5. Under Visibility, select Unhide Sheet.

    Step 5
  6. Click OK.

    Step 6

After completing this topic, you are able to hide and unhide sheet tabs.