Why Can’t I See My Worksheet Tabs in Excel 2013?


Microsoft Excel files are workbooks that can contain individual worksheets within them. You can learn more about the difference between workbooks and worksheets here. You can navigate between individual worksheets in your workbook by clicking the tabs at the bottom of the window. But it is possible for these tabs to be hidden by adjusting a setting in Excel Options.

Our guide below will show you what you need to do when you can’t see your tabs in Excel 2013, but need to switch to another worksheet.

 

Where are my Worksheet Tabs in Excel 2013?

The steps in this article will assume that you have a workbook open in Microsoft Excel 2013 that contains multiple worksheets, but that you do not see the tabs at the bottom of the window.

 

  1. Open Microsoft Excel 2013.
  2.  

  3. Click the File tab at the top-left corner of the window.
  4. click the file tab

     

     

  5. Click Options at the bottom of the column at the left side of the window.
  6. click options in the left column

     

     

  7. Click the Advanced tab at the left side of the Excel Options window.
  8. click the advanced tab in excel options

     

     

  9. Scroll down to the Display options for this workbook section, then check the box to the left of Show sheet tabs to add a check mark. You can then click the OK button at the bottom of the window to save and apply  your changes.

how to show sheet tabs in excel 2013

 

 

If you followed the steps above, only to find that Excel 2013 was already configured to show sheet tabs, then it is possible that your Excel window is minimized or has been manually sized. You can double-click the workbook name at the top of the window to maximize the window, which should bring your worksheet tabs into view.

maximize excel 2013 window

 

 

If only some of your worksheet tabs are visible in your Excel 2013 workbook, then it is possible that individual sheets have been hidden. Learn how to unhide a worksheet in Excel.

 

solveyourtech.com newsletter
vintage t rex t-shirt

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