Show Tabs At Bottom Of Excel Spreadsheet

How to Show and Hide the Worksheet Tabs in Excel

@howtogeek
June 24, 2015, 10:24am EDT

If you’re short on screen space, you may want to hide parts of the Excel window, such as the ribbon and the worksheet tabs. We’ve already shown you how to hide the ribbon, so here we’ll show you how to hide the tabs.

To begin, click the “File” tab.

On the backstage screen, click “Options” in list on the left.

On the “Excel Options” dialog box, click “Advanced” in the list of items on the left.

Scroll down to the “Display options for this workbook” section (not the “Display” section) and select the “Show sheet tabs” check box so there is NO check mark in the box.

Click “OK” to accept the change and close the “Excel Options” dialog box.

You can also hide other items in Excel such as cells, rows, and columns and comments, formulas, and gridlines.

Where are my worksheet tabs?

If you can’t see the worksheet tabs at the bottom of your Excel workbook, browse the table below to find the potential cause and solution.

Note: The image in this article are from Excel 2016. Your view might be slightly different if you have a different version, but the functionality is the same (unless otherwise noted).

The window sizing is keeping the tabs hidden.

If you restore multiple windows in Excel, ensure that the windows are not overlapping. Perhaps the top of an Excel window is covering the worksheet tabs of another window.

The status bar has been moved all the way up to the Formula Bar.

Tabs can also disappear if your computer screen resolution is higher than that of the person who last saved the workbook.

Try maximizing the window to reveal the tabs. Simply double-click the window title bar.

If you still don’t see the tabs, click View > Arrange All > Tiled > OK.

The Show sheet tabs setting is turned off.

First ensure that the Show sheet tabs is enabled. To do this,

For all other Excel versions, click File > Options > Advanced—in under Display options for this workbook—and then ensure that there is a check in the Show sheet tabs box.

The horizontal scroll bar obscures the tabs.

Hover the mouse pointer at the edge of the scrollbar until you see the double-headed arrow (see the figure). Click-and-drag the arrow to the right, until you see the complete tab name and any other tabs.

The worksheet itself is hidden.

To unhide a worksheet, right-click on any visible tab and then click Unhide. In the Unhide dialog box, click the sheet you want to unhide and then click OK.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

How to Show Missing Worksheet Tabs in Excel 2013

Excel workbooks with multiple worksheets are a great way to coordinate data that might not necessarily belong on the same worksheet, but that is relevant enough to a single topic that it merits combination. Typically you can navigate between different worksheets within a workbook by clicking the tabs at the bottom of the window.

But these tabs can be hidden in a couple of different ways, and it is possible that every tab in the workbook is hidden, even the tab for the worksheet on which you are currently working. Our guide below will show you both how to unhide all of the worksheet tabs if they are hidden that way, plus it will show you how to unhide worksheets that have been hidden on an individual level.

Here is how to show your Excel 2013 tabs if they are all hidden –

  1. Open Excel 2013.
  2. Click theFiletab.
  3. ClickOptionsat the bottom of the left column.
  4. ClickAdvancedon theExcel Optionswindow.
  5. Check the box to the left ofShow sheet tabsin theDisplay options for this workbooksection of the menu.
  6. Click theOKbutton.

These steps are repeated below –

Step 1: Open your workbook in Excel 2013.

Step 2: Click theFiletab at the top-left corner of the window.

Step 3: ClickOptionsat the bottom of the column on the left side of the window.

Step 4: Click theAdvancedtab in the left column of theExcel Optionswindow.

Step 5: Scroll down to theDisplay options for this workbooksection, then check the box to the left ofShow sheet tabs.

Step 6: Click theOKbutton at the bottom of theExcel Optionswindow to apply your changes.

Here is how to show your Excel 2013 when only some of them are missing –

  1. Open your workbook in Excel 2013.
  2. Right-click a worksheet tab at the bottom of the window, then click theUnhideoption.
  3. Click a worksheet that you want to unhide, then click theOKbutton.
  4. Repeat steps 2 and 3 for each additional worksheet that you want to unhide.

These steps are also repeated below with pictures –

Step 1: Open your workbook in Excel 2013.

Step 2: Locate the worksheet tabs at the bottom of the window, right-click one of them, then select theUnhideoption from this shortcut menu.

Step 3: Click a worksheet that you want to unhide, then click theOKbutton.

Step 4: Repeat steps 2 and 3 for each additional worksheet that you want to unhide.

While this second method for unhiding individually missing worksheet tabs is fine when you only have a couple, it is very tedious when there are a lot of hidden tabs. Click here to find a helpful macro that will quickly unhide all of the hidden worksheets in an Excel 2013 workbook.

Share this:

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.

Where are my worksheet tabs?

If you can’t see the worksheet tabs at the bottom of your Excel workbook, browse the table below to find the potential cause and solution.

Note: The image in this article are from Excel 2016. Your view might be slightly different if you have a different version, but the functionality is the same (unless otherwise noted).

The window sizing is keeping the tabs hidden.

If you restore multiple windows in Excel, ensure that the windows are not overlapping. Perhaps the top of an Excel window is covering the worksheet tabs of another window.

The status bar has been moved all the way up to the Formula Bar.

Tabs can also disappear if your computer screen resolution is higher than that of the person who last saved the workbook.

Try maximizing the window to reveal the tabs. Simply double-click the window title bar.

If you still don’t see the tabs, click View > Arrange All > Tiled > OK.

The Show sheet tabs setting is turned off.

First ensure that the Show sheet tabs is enabled. To do this,

For all other Excel versions, click File > Options > Advanced—in under Display options for this workbook—and then ensure that there is a check in the Show sheet tabs box.

The horizontal scroll bar obscures the tabs.

Hover the mouse pointer at the edge of the scrollbar until you see the double-headed arrow (see the figure). Click-and-drag the arrow to the right, until you see the complete tab name and any other tabs.

The worksheet itself is hidden.

To unhide a worksheet, right-click on any visible tab and then click Unhide. In the Unhide dialog box, click the sheet you want to unhide and then click OK.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

How to Display Sheet Tabs in Excel 2010

Excel workbooks are actually collections of different spreadsheets that you can use to organize data within one file. But the sheet navigation at the bottom of the window takes up valuable screen real estate and, if you want that extra space to be able to view more cells at once, you might decide to hide those sheet tabs. If you have personally hidden the sheet tabs in Excel 2010, or if someone else uses your computer and they have hidden them, then it can be difficult to switch between sheets in a workbook. Fortunately it is a simple process to restore these sheet tabs to the bottom of your workbook screen so that you can effortlessly navigate between sheets.

Have you been considering a switch to Windows 8? Learn more about the different versions and pricing to decide if making that switch is in your best interest.

How to Unhide Sheet Tabs in Excel 2010

If unhiding your sheets is a temporary effect, then you will be happy to know that you can simply reverse the process outlined below to go back to hiding the sheets. But for the purpose of showing your worksheet tabs below your Excel spreadsheet, which is the default setting, you can simply follow this procedure.

Step 1: Launch Microsoft Excel 2010.

Step 2: Click theFiletab at the top-left corner of the window, then clickOptions.

Step 3: Click theAdvancedoption in the column at the left side of theExcel Optionswindow.

Step 4: Scroll to theDisplay options for this workbooksection, then check the box to the left ofShow sheet tabs.

Step 5: Click theOKbutton at the bottom of the window to apply the change.

How to Unhide a Single Worksheet Tab in Excel

If you are able to see some sheet tabs at the bottom of the screen, then you may need to unhide worksheets individually instead. This is a pretty common occurrence in a large Excel file, particularly if includes a lot of formulas that reference data which may not need to be visible or accessible to others who work with that file.

You can do this by right-clicking one of your visible worksheet tabs, then choosing theUnhideoption. This is going to open the Unhide dialog box.

Select the sheet name of the worksheet that you wish to unhide, then click theOKbutton.

What is a Worksheet Tab in Excel?

A worksheet tab in Excel is a small button below your cells that allows you to navigate between the different worksheets in your file.

If you haven’t renamed them, then they probably say something like Sheet1, Sheet2, Sheet3, etc. If you want to rename worksheet tabs in Excel, you can do so if you right-click on one of the tabs, then choose the Rename option.

Where Do Sheet Tabs Display in a Workbook in Excel?

The worksheet tabs in your workbook display near the bottom of the window. The example image below is from Microsoft Excel 2010, but still applies in future Excel versions such as Excel 2013, 2016, and Excel for Office 365.

Right-clicking these tabs provides you with the ability to rename them like we showed in the section above, as well as the ability to hide or unhide tabs, change the color of a tab, or even select all of the sheets in your workbook at the same time.

The “Select All Sheets” command is particularly useful if you have a lot of worksheets in your file and would like to apply the same action to each of those tabs. For example, if you select all of your sheets then type something into one of the cells in one of the selected worksheets, then the data that you have entered will appear in that same cell on each of the selected sheets. The same goes for a number of formatting options, too.

How to Add Tabs in Excel

While many Excel installations will provide three worksheet tabs by default, that may not be enough for the work that you are about to do.

Fortunately you can add a new Excel sheet tab by clicking the tab to the right of your last tab. If you hover over this tab it will sayInsert Worksheet. It also lets you know about the keyboard shortcut that can add a new worksheet tab, which isShift + F11.

Conversely you can delete a tab by right-clicking on it and choosing theDeleteoption.

How to Show Worksheet Tabs in Excel if They’re All Hidden

If you’ve read this article in an attempt to show your hidden worksheets, but are struggling to do so because there simply aren’t any tabs shown at all, then you may need to change a different setting.

Step 1: If you click theFiletab at the top-left of the window, to the left of theHometab, you will notice anOptionsbutton at the bottom of the left column. Note that if you’re working in Excel 2007, you will need to click the Office button instead.

Step 2: Click thatOptionsbutton, which opens theExcelOptionsmenu.

Step 3: Select theAdvancedtab at the left side of the window.

Step 4: Scroll down to theDisplay optionsfor this workbooksection, then check the box to the left ofShow sheet tabs.

Step 5: Click theOKbutton at the bottom of the window to apply the changes.

We have a number of other helpful articles about Excel 2010 on this site. Check out this page to see some articles that might help you with a problem you are having, or might give you an idea about how to customize Excel in a way that you didn’t know was possible.

Share this:

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.

Comments: