HomeApplicationOffice informationHow to hide the Sheet Tabs (sheet bar) in Excel

How to hide the Sheet Tabs (sheet bar) in Excel

How to hide the Sheet Tabs (sheet bar) in Excel Picture 1

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.

How to hide the Sheet Tabs (sheet bar) in Excel Picture 2

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 .

How to hide the Sheet Tabs (sheet bar) in Excel Picture 3

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) .

How to hide the Sheet Tabs (sheet bar) in Excel Picture 4

Step 3: Ad tried hiding the Sheet Tab bar by deselecting Show sheet tabs . As a result, the bar has been hidden:

How to hide the Sheet Tabs (sheet bar) in Excel Picture 5

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) .

How to hide the Sheet Tabs (sheet bar) in Excel Picture 6

Unhide window will appear and list which sheets are hidden. If you want to open a window, double-click the name of the sheet.

How to hide the Sheet Tabs (sheet bar) in Excel Picture 7

Good luck!

3.9 ★ | 16 Vote

You should read it

May be interested

  • How to adjust line spacing and line spacing in ExcelPhoto of How to adjust line spacing and line spacing in Excel
    how to adjust line spacing and line spacing in excel line spacing (the height of the line) makes your spreadsheet look better and more synchronized. today dexterity software will guide you how to adjust the height of the line so fast and most beautiful offline!
  • How to use Conditional Formatting to conditional formatting in ExcelPhoto of How to use Conditional Formatting to conditional formatting in Excel
    excel has a condititional formatting tool that is quite adequate for the needs of users. however, the built-in formats of excel are not enough to meet your needs, excel supports users to easily create new rules.
  • Filter data that doesn't overlap in Excel - Filter for unique values ​​in ExcelPhoto of Filter data that doesn't overlap in Excel - Filter for unique values ​​in Excel
    in a spreadsheet with large information data, it is difficult to check and filter which data is duplicated and which is not. especially if you manually / eye check it is very time consuming. thankfully, excel has a tool that makes it possible for users to filter for duplicate values ​​in excel (unique values).
  • How to format currencies in ExcelPhoto of How to format currencies in Excel
    how to format currencies in excel. if you want to represent numbers as currency, you must format the numbers as currency. to do this, you use excel's format cellss tool.
  • How to automatically wrap lines in Excel (Wrap Text in Excel)Photo of How to automatically wrap lines in Excel (Wrap Text in Excel)
    the line break in excel is not as simple as pressing enter as in ms word software. today, dexterity software will guide you to the warp text tool to automatically wrap lines that match the width of the column!
  • Absolute and relative addresses in ExcelPhoto of Absolute and relative addresses in Excel
    absolute and relative addresses in excel. relative addresses are addresses that change when copying a formula. this is the default address when we formulate the formula. for example a1, b2 ... the absolute address is the one that was not changed when copying the formula. the absolute address is distinguished from the absolute address with the character $. for example $ a1 $ 1, $ b1 $ 2….

Office information