How to hide the Sheet Tabs (sheet bar) in Excel
The Sheet Tab is the sheet that contains the worksheets of a Workbook, here you can see which Workbooks this sheet currently contains. Typically, the Sheet Tab Bar is shown in the lower left corner of the Excel window.
During use, unfortunately you accidentally turn off (hide) the Sheet Tab bar, or you get a file from other people who have hidden the Sheet Tab bar before. So how to display the Sheet Tab bar? Today Dexterity Software will guide you how to customize hide, Sheet tab bar depending on user needs. How to do the following:
Step 1: Go to File and select Options .
Step 2: Excel Options window appears, click the Advanced tab (1) => Find Display Options for This Workbook (2) => To display the Sheet Tab bar, select the Show sheet tabs (3) ; To hide the bar, uncheck => Click the OK button (4) .
Step 3: Ad tried hiding the Sheet Tab bar by deselecting Show sheet tabs . As a result, the bar has been hidden:
Note: To check if the calculated sheet is hidden, move the mouse to the Sheet tab, right-click the open Sheet name (1) , select Unhide (2) .
Unhide window will appear and list which sheets are hidden. If you want to open a window, double-click the name of the sheet.
Good luck!
You should read it
- How to display sheet tabs in Excel
- How to hide and hide sheets in Excel and show them again
- How to hide and show Sheet in Excel
- Part 4: Hide Sheet, Sheet tab, Scroll Bar, Workbook
- How to create a password protection for Excel sheets
- Tips with spreadsheets (sheet) in Excel
- Show Sheet Tab in Excel when hidden
- How to Add a New Tab in Excel
- Shortcut switch Sheet in Excel
- Recover deleted Sheet in Excel
- How to lock Excel Sheet, set a password for the sheet in Excel
- Tip Hide professional Excel spreadsheets
Maybe you are interested
Set location in Google Sheets
Parentheses in Google Sheets
Excel 2016 - Lesson 12: Formatting pages and printing spreadsheets in Excel
Here's What to Do Before Sharing an Excel Spreadsheet
Tips for formatting cells in Excel for professional spreadsheets
Google Sheets Functions to Simplify Your Budget Spreadsheets