What is the Excel Sheet Tab?
Excel Sheet tab is a visual label that looks like a file folder tab. In Excel, a sheet tab shows the of a worksheet contained in the workbook.
Excel by default displays the Excel tab or Sheet tab. Each Excel workbook contains at least one worksheet. We can create a number of worksheets in a workbook according to our requirements. Each worksheet shows as a tab at the bottom of the Excel window. These tabs help to manage the worksheets and move from one worksheet to another easily.
What is the Excel Scroll Bar?
Excel scroll bar is a navigation bar in a worksheet using to move to the right side and to move to the downward.
In addition to the sheet tab, Excel displays Vertical Scroll Bar to the right side and Horizontal Scroll Bar to the bottom of the Excel screen. These scroll bars help to scroll up-and-down and side-to-side through a worksheet, respectively. The arrow keys on the keyboard or the scroll wheel on the mouse helps to move the scroll bars.
How to Hide & Restore the Scroll Bar, Sheet Tab in Excel?
- Sometimes, while Excel opens it hides the scroll bar and sheet tab(s) accidentally.
- Sometimes, as per our requirement generally to increase the viewing area of the worksheet, hide the horizontal and vertical scroll bars manually.
Whatever is it, please note that changes in scroll bars and sheet tables are only applicable to the current workbook, not to other opened workbooks.
(i) Go to the File tab.
(ii) Select Options.
(iii) Then select Advanced from the left sidebar ➪ scroll down to the Display options for this workbook section (about halfway down) ➪ select the Show horizontal scroll bar, Show vertical scroll bar and Show sheet tabs checkboxes
(iv) Click on OK or press Enter to close the dialog box and return to the worksheet.
Resize the Horizontal Scroll Bar in Excel
If there are a number of worksheets in a workbook, then the names of all tabs cannot be read at a glance. The only way to fix this is to shrink the size of the horizontal scroll bar manually.
Place the mouse pointer over the vertical ellipsis (three vertical dots) next to the horizontal scroll bar ➪ the mouse pointer changes to a double-headed arrow ➪ drag to the right to shrink the horizontal scroll bar or drag to the left to enlarge the scroll bar.
Insert a New Sheet Tab in Excel
In a workbook, we can insert a Tab in 3 ways:
(01) Insert a New Sheet Tab: Using the Plus (+) icon right of the Tab Bar
To insert a new sheet tab/ Excel tab in a workbook, click the tab after which we want to insert the worksheet ➪ then click the plus icon (+) to the right of the tab bar.
(02) Insert a New Sheet Tab: Using the Excel Shortcut
Alternatively, the best way to insert a new sheet tab is to press Excel shortcut Shift+F11, a new worksheet is inserted before the selected tab.
(03) Insert a New Sheet Tab: Using the Ribbon
Alternatively, click the tab before which we want to insert the worksheet and then press right click on the mouse ➪ Click on Insert ➪ Worksheet is selected by default ➪ Click on OK or press the Enter.
Rename the Sheet Tab in Excel
Each workbook comprises one or more worksheets, and each worksheet is made up of individual cells. Each cell contains a value, a formula, or text. A worksheet also has an invisible draw layer, which holds charts, images, and diagrams. Each worksheet in a workbook is accessible by clicking on the sheet tab at the bottom of the workbook window.
By default, new tabs are named as Sheet1, Sheet2, etc., in sequential order. That means if there are multiple worksheets in a workbook, and each sheet has its name displayed in a sheet tab. It is helpful to rename each tab according to the database subject (max 31 characters long) to help us organize and find the data easily.
There are three ways to rename a sheet tab. Remember that each tab must have a unique name.
(01) Rename the Sheet Tab: Using the Mouse Double Click
Simply double click on the tab want to rename ➪ type a new name and press Enter.
(02) Rename the Sheet Tab: Using the Excel Shortcut
Use Excel Shortcut – Alt+O+H+R ➪ type a new name and press Enter.
(03) Rename the Sheet Tab: Using the Mouse Right Click
Right-click on the selected Tab and click on Rename ➪ type a new name and press Enter.
Move or Copy the Sheet Tab in Excel
If we can make an exact copy of a tab (worksheet), we should try to avoid copy-paste to another new worksheet rather we prefer to use Move or Copy Tab to another location in the same workbook or another open workbook.
We can move or copy the sheet tab in two ways:
(01) Move or Copy the Sheet Tab: Using Mouse Right Click
(i) Right-click on the sheet tab(s) want to move or copy ➪ select Move or Copy ➪ Open the Move or Copy dialog box, the currently active workbook is selected by default in the To Book drop-down list.
If we want to copy or move the tab to another existing workbook, make sure that this workbook should be opened and select it from the list. But if we want to copy or move the tab to another new workbook, just select (new book) option from the list.
(ii) Then we move to the Before sheet list box just below the To Book, select the worksheet (tab) before which we want to insert the copied (or moved) tab.
(iii) After that, we go to the third option Create a copy. If we want to copy the tab, but not moving it, make sure the Create a copy box is checked and click OK. As a result, the duplicate tab is created. If the Create a copy box is not checked, the tab will be moved to the chosen location instead of copied.
(iv) Click on OK or press the Enter to apply the activity.
(02) Move or Copy the Sheet Tab: Using the Excel Shortcut
(i) The above process, we can do it by using Excel shortcut: Select the tab(s) want to move or copy ➪ press Alt+E+M to open the Move or Copy dialog box ➪ then press Shift+Tab helps to go to the To Book drop-down list. Press Alt+Down Arrow to open the drop-down list. Select either (new book) or any one of the opened workbooks we want to copy or move the tab. Press single Enter.
(ii) Then press Tab to move to the Before sheet list box section and choose the worksheet (tab) by up or down arrow keys before which we want to insert the copied (or moved) tab. Remember that if we select the (new book) option, then Before sheet section remains blank.
(iii) In the third step, press Alt+C to select the Create a copy checkbox.
(iv) At last, click on OK by the Spacebar or press Enter to apply the activity.
Delete the Sheet Tab in Excel
We can delete the unnecessary tab(s) from a workbook in two ways:
(01) Delete the Sheet Tab: Using the Mouse Right Click
Right-click on a tab or on the multiple tabs (select by pressing Ctrl key) want to delete ➪ Select Delete from the list ➪ Excel window appears for getting confirmation from the user to delete it permanently, click on Delete or press Enter. A worksheet or Tab has removed from the workbook.
(02) Delete the Sheet Tab: Using Excel Shortcut
Simply select the tab or tabs by pressing Ctrl key to want to delete ➪ Press Alt+E+L ➪ Excel window appears for getting confirmation from the user to delete it permanently, click on Delete or press Enter. A worksheet or Tab has removed from the workbook easily.
Hide or Unhide the Sheet Tab in Excel
Microsoft Excel shows sheet tab(s) at the bottom of the worksheet by default, which helps to navigate from one worksheet to another worksheet easily.
Most of the times, Excel users make different types of the dashboard, kinds of summary and apply a combination of formula in different worksheets based on the master database, but they would rather not show that data to other users. In this situation, they prefer to hide the worksheet(s). Remember that Excel allows hiding all worksheets except at least one.
We can hide the tab(s) from a workbook in three ways:
(01) Hide the Sheet Tab(s): Using the Mouse Right Click
Select one or multiple worksheet tabs we want to hide in the Tab bar.
⇒ Tips to select multiple tabs or worksheets:
- If we want to select multiple adjacent tabs, click on the first tab and hold the Shift key and then click on the last tab. Therefore, multiple adjacent tabs or contiguous tabs are selected at a glance.
- If we want to select multiple non-adjacent tabs or non-contiguous tabs, then click on the individual tab one by one holding the Ctrl key.
After selecting the Tab or multiple tabs, right-click on the selection and select Hide from the context menu. Thus the selected tabs will be hidden from the Tab bar.
(02) Hide the Sheet Tab(s): Using the Excel Shortcut
Select the contiguous tabs by Shift key or non-contiguous tabs by Ctrl key ➪ then press Alt+H+O+U+S. Therefore, all tabs would be hidden.
(03) Hide the Sheet Tab(s): Using the Ribbon
Select the contiguous tabs by Shift key or non-contiguous tabs by Ctrl key ➪ Go to the Home tab ➪ Click on the drop-down Format in the ‘Cells’ group ➪ Under Visibility section, point to the Hide & Unhide, a list opens and select the Hide Sheet.
If there are a lot of tabs, they may not all display at once, depending on the size of the Excel window. There are a couple of ways we can navigate from one tab to another.
We’ll find that three horizontal dots on one or both ends of the tab bar. If we click on the three dots on the left end, we navigate to the first tab in the left direction. If we click on the three dots on the right end, we navigate to the last tab in the right direction.
We can also click the right or left arrows on the left side of the tab bar to scroll through the tabs.
The best way to move from one tab to the adjacent tab by using the Excel shortcut.
- Ctrl+Page Down: Navigate towards the right side
- Ctrl + Page Up: Navigate towards the left side
Sheet Tab Color in Excel
If there are a number of tabs in a workbook, then tab identification, tab navigation becomes difficult. Thus we would like to use the same tab color with similar activity and make a group. For example, all types of ‘Summary tabs’ in a workbook to make a group with the same type of color. Similarly, all pivot table tabs to make a group with the same tab color. Therefore, we can easily identify the tabs by tab colors.
We can color the tab(s) in three ways:
(01) Color the Sheet Tab(s): Using the Mouse Right Click
Select one or multiple worksheet tabs we want to make a group with a similar color ➪ right click on the selection with mouse ➪ go to the Tab Color ➪ a right-side color palette window opens ➪ choose any color and click on it.
(02) Color the Sheet Tab(s): Using the Excel Shortcut
Select Tab or Tabs
Select one or multiple worksheet tabs we want to make a group with similar color ➪ press Alt+H+O+T ➪ choose any color and click on it.
(03) Color the Sheet Tab(s): Using the Ribbon
Select one or multiple worksheet tabs we want to make a group with similar color ➪ go to the ‘Home‘ tab ➪ click on the ‘Format‘ drop-down under Cells section ➪ place the cursor on Tab Color ➪ a right-side color palette window opens ➪ choose any color and click on it.
Latest posts by Sudipta Mondal (see all)
- Excel SUMIFS Function - October 27, 2019
- How to use INDEX MATCH Function in Excel with 04 Best Examples - October 13, 2019
- 09 Steps to Reduce Excel File size || Evaluate Existing Formulas || - September 5, 2019
Advance Excel Forum
How to Restore Missing Sheet Tab/ Excel tab & Missing Scroll Bar?