Hide Worksheets Tab in Excel

In Microsoft Excel, if you do not want to show your spreadsheets tab then you can easily hide the tabs. To achieve this follow the below steps.

Step 1:

We can start with one example to hide all tabs in excel. The below excel book having multiple worksheets as shown in the below picture.

Hide All Worksheets

Step 2:

To hide all worksheets go to menu bar and click File->Options, a window will appear as below image.

Hide Sheets in Menu Option

Step 3:

Now click Advanced option in the left side bar and go to "Display option for this workbook" option to uncheck "Show sheet tabs" as shown in the below picture.

Uncheck Show Sheet Tabs

Step 4:

The output will be displayed as shown in the below picture.

Hidden Worksheets Tab

Thank You Visit Again!!!...