Show Sheet Tab in Excel when hidden

Accidentally when you open the Excel file to work, you do not see the Sheet Tab bar appear to select Sheet. You do not know what to do, so let's learn about the display of Sheet Tab in Excel when hidden in this article.

Accidentally when you open the Excel file to work, you do not see the Sheet Tab bar appear to select Sheet. You do not know what to do, so let's learn about the display of Sheet Tab in Excel when hidden in this article.

Picture 1 of Show Sheet Tab in Excel when hidden

Here TipsMake.com guides you how to display Sheet Tab in Excel when hidden, invite you to follow.

If you go into Excel but accidentally lost the Sheet Tab bar as shown below.

Picture 2 of Show Sheet Tab in Excel when hidden

To display the Sheet Tab in Excel again when hidden, do the following:

Step 1: Select File -> Options .

Picture 3 of Show Sheet Tab in Excel when hidden

Step 2: In the Excel Options window, select Advanced on the left, in the right side, scroll down to Display options for this workbook , check the box in the box before Show sheet tabs and select OK.

Picture 4 of Show Sheet Tab in Excel when hidden

Thus Sheet Tab will be displayed.

Picture 5 of Show Sheet Tab in Excel when hidden

If you want to show a sheet, do the following:

To hide the sheet, right-click the sheet name to hide and select Hide .

Picture 6 of Show Sheet Tab in Excel when hidden

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

Picture 7 of Show Sheet Tab in Excel when hidden

In the Unhide section, select the sheet to display and select OK .

Picture 8 of Show Sheet Tab in Excel when hidden

So the sheet will be displayed.

Picture 9 of Show Sheet Tab in Excel when hidden

Above TipsMake.com guided you to display Sheet Tab in Excel when hidden. Hope this article will help you. Good luck!

You've just finished reading the article "Show Sheet Tab in Excel when hidden" edited by the TipsMake team. You can save show-sheet-tab-in-excel-when-hidden.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.

« PREV : How to cut and split...
How to copy sheet... : NEXT »