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.
Show Sheet Tab in Excel when hidden Picture 1
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.
Show Sheet Tab in Excel when hidden Picture 2
To display the Sheet Tab in Excel again when hidden, do the following:
Step 1: Select File -> Options .
Show Sheet Tab in Excel when hidden Picture 3
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.
Show Sheet Tab in Excel when hidden Picture 4
Thus Sheet Tab will be displayed.
Show Sheet Tab in Excel when hidden Picture 5
If you want to show a sheet, do the following:
To hide the sheet, right-click the sheet name to hide and select Hide .
Show Sheet Tab in Excel when hidden Picture 6
To display the sheet, right-click on any sheet name and click Unhide .
Show Sheet Tab in Excel when hidden Picture 7
In the Unhide section, select the sheet to display and select OK .
Show Sheet Tab in Excel when hidden Picture 8
So the sheet will be displayed.
Show Sheet Tab in Excel when hidden Picture 9
Above TipsMake.com guided you to display Sheet Tab in Excel when hidden. Hope this article will help you. Good luck!
You should read it
- How to hide and hide sheets in Excel and show them again
- How to hide and show Sheet in Excel
- How to display sheet tabs in Excel
- How to hide the Sheet Tabs (sheet bar) in Excel
- How to create a password protection for Excel sheets
- Recover deleted Sheet in Excel
- How to Unprotect Excel Sheet
- Steps to export data from photos to MS Excel sheet on Android
- Shortcut switch Sheet in Excel
- How to lock Excel Sheet, set a password for the sheet in Excel
- How to separate sheets into separate Excel files
- How to copy sheet from Excel file to another Excel file
May be interested
How to cut and split images in PDF files simply and easily
How to write mathematical formulas in Word 2010
How to insert brackets in Word, Excel square brackets, curly brackets, double quotation marks
How to indent words in Word - Indent the first line of paragraphs in Word
How to print out of A4 size paper in Word
How to merge 2 pages into 1 page in Word