HomeApplicationOffice information

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!

3.5 ★ | 2 Vote

You should read it

May be interested

  • How to lock Excel Sheet, set a password for the sheet in ExcelHow to lock Excel Sheet, set a password for the sheet in Excel
    lock sheet, set password for data sheet in excel to create security for your data file, do not let anyone edit or add data. tipsmake.com will guide you how to do in our article below.
  • How to separate sheets into separate Excel filesHow to separate sheets into separate Excel files
    to separate each excel sheet into separate excel files, simply use the vba macro code to finish.
  • How to copy sheet from Excel file to another Excel fileHow to copy sheet from Excel file to another Excel file
    while working with excel, there are times when you want to copy the sheet from one excel file to another excel file to facilitate data processing. if you do not know how to copy sheet, please refer to how to copy sheet in excel to other excel file in this article.
  • How to Unprotect an Excel SheetHow to Unprotect an Excel Sheet
    this wikihow teaches you how to unprotect a sheet within a microsoft excel workbook in windows or macos. if the sheet is protected by a password and you're not sure what it is, you can use google sheets or a vba script (in earlier versions...
  • Instructions for copying or moving Worksheet in Excel 2013Instructions for copying or moving Worksheet in Excel 2013
    the move or copy command allows you to easily move or copy the entire worksheet, including all data and formats in excel, in case you create a new sheet or a new book that wants to copy data from excel. old to.
  • Tips with spreadsheets (sheet) in ExcelTips with spreadsheets (sheet) in Excel
    in excel spreadsheets to manage excel data using sheet tabs, you can easily add, delete, rename or customize the settings as you like for the worksheets in excel worksheet. here are some basic tips when working with sheets in e
  • How to display the Ruler bar in ExcelHow to display the Ruler bar in Excel
    excel's ruler bar was accidentally hidden, making it difficult for you to adjust the table size. so how to retrieve the ruler?
  • Part 4: Hide Sheet, Sheet tab, Scroll Bar, WorkbookPart 4: Hide Sheet, Sheet tab, Scroll Bar, Workbook
    types of data hiding in excel - part 4: hide sheet, sheet tab, scroll bar, workbook
  • How to display 0 in front of a number in ExcelHow to display 0 in front of a number in Excel
    usually when we enter a sequence of numbers in excel that has a leading zero, it will disappear. so how to display 0 in the series in excel?
  • How to Unprotect Excel SheetHow to Unprotect Excel Sheet
    tipsmake today will show you how to unprotect worksheets in microsoft excel workbooks on windows or macos. if the sheet is password protected and you don't know it, you can use google sheets or a vba script (on earlier versions of excel) to remove the protection.

Office information