How to Restore Missing Sheet Tabs (Excel 2013)

Of all the things that can go missing in an Excel sheet (like the missing scroll bars), here’s another one I discovered – missing sheet tabs! This is not the same as hidden sheet tabs.

missing_sheet_tabs_1
 

Fascinating, isn’t it? Here’s how to get it back:

1.  Click the File tab and click Options.

missing_scroll_bar2
2.  Click the Advanced category.

missing_scroll_bar3
3.  Look for Display options for this workbook, then select the Show sheet tabs check box. Click OK.

missing_sheet_tabs_2

4.  There you have it, the sheet tabs fully visible!

missing_sheet_tabs_3
 

Leave a Reply

Your email address will not be published. Required fields are marked *