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 the File tab.
  3. Click Options at the bottom of the left column.
  4. Click Advanced on the Excel Options window.
  5. Check the box to the left of Show sheet tabs in the Display options for this workbook section of the menu.
  6. Click the OK button.

These steps are repeated below –

Step 1: Open your workbook in Excel 2013.

 

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

click the file tab

 

 

Step 3: Click Options at the bottom of the column on the left side of the window.

click options

 

 

Step 4: Click the Advanced tab in the left column of the Excel Options window.

click advanced tab

 

 

Step 5: Scroll down to the Display options for this workbook section, then check the box to the left of Show sheet tabs.

show sheet tabs in excel 2013

 

 

Step 6: Click the OK button at the bottom of the Excel Options window 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 the Unhide option.
  3. Click a worksheet that you want to unhide, then click the OK button.
  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 the Unhide option from this shortcut menu.

right-click tab, click unhide

 

 

Step 3: Click a worksheet that you want to unhide, then click the OK button.

unhide a single sheet in excel 2013

 

 

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.

 

solveyourtech.com newsletter
vintage t rex t-shirt

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