How to display Sheet Tab in Excel when hidden, not displayed

In Excel, when you open it for the first time, you will see the sheets displayed by default and the user just needs to use them right away. But unfortunately when you open the Excel file again and do not see this Sheet tab, it is likely that the Excel file has been disabled to prevent this sheet tab from being displayed. The solution is that you need to check and allow the Sheet Tab to be displayed in Excel when hidden , then you will see the sheet displayed, and you can work on that sheet already.

I. Cause Sheet Tab in Excel is hidden

- It is possible that the user accidentally hid unnecessary sheet tabs.

- If there are too many sheets in the workbook, Excel will automatically hide the tabs to save space.

- The option to display sheet tabs has been disabled.

- Workbook is locked and requires a password.

- If the Excel working window is rearranged, the sheet tabs may be hidden.

II. Instructions for displaying Sheet Tab in Excel when hidden

In this article, TipsMake will demonstrate how to display Sheet Tab in Excel using Excel 2016 . For other versions of Excel such as Excel 2013 and 2010, do the same.

The picture below is when Excel is opened but the Sheet tab is not displayed for use:

How to display Sheet Tab in Excel when hidden, not displayed Picture 1

To display Sheet Tab in Excel when hidden, follow these steps:

Step 1: Click on the File menu -> select Options .

How to display Sheet Tab in Excel when hidden, not displayed Picture 2

Step 2: In the Excel Options window interface-> select Advanced -> next, on the right side, scroll down to the Display options for this workbook section -> re-check the box before Show sheet tabs -> and select OK .

How to display Sheet Tab in Excel when hidden, not displayed Picture 3

As a result, the Sheet Tab will be displayed again as shown below:

How to display Sheet Tab in Excel when hidden, not displayed Picture 4

Step 3: If you want to hide or show any sheet, do the following:

To hide a sheet -> right-click on the sheet name you want to hide -> and select Hide to hide.

How to display Sheet Tab in Excel when hidden, not displayed Picture 5

To display the sheet -> right-click on any sheet name -> and click Unhide to display.

How to display Sheet Tab in Excel when hidden, not displayed Picture 6

In the Unhide section -> select the sheet you need to display -> and click OK .

How to display Sheet Tab in Excel when hidden, not displayed Picture 7

As a result, the Sheet will be displayed again.

How to display Sheet Tab in Excel when hidden, not displayed Picture 8

So you know how to display Sheet Tab in Excel when hidden ! Basically the steps for you to follow are quite simple. You will go to Excel Options and tick Sheet Tab again in Display options for this workbook and check the results again and you're done.

In addition, if you want to increase Sheet Excel or lock Sheet Excel  , please refer to the shares introduced and guided by TipsMake. Good luck!

Kareem Winters

Update 18 June 2024