Please leave a comment in the comment section below or even better: like and share this blog post in the social networks to help spread the word about this. Select the Advanced tab on the left and at the right, under the Display options for this workbook, check the Show sheet tabs box and click OK. If the Excel sheets are not visible after applying the above, check the 'Show sheet tabs' setting in Excel options. If the hidden tabs are visible again, click Save to save this view, other otherwise continue below. Click on the double-headed arrow and drag your mouse to the right until you see all the tabs of your Excel workbook.ģ. To reveal the hidden Excel Worksheets, place your mouse on the 3 dots at the bottom bar until you see the double-headed arrow. If you see the missing tabs, click Save to save the current view, otherwise continue below. Select Tiled and Windows of active workbook and click OK.ģ. Go to the View tab and click Arrange All.Ģ. Arrange all windows of the active workbook.ġ. 2.In the View Options dialog box, check or uncheck the Sheet Tabs. 1.Click Kutools > Show / Hide > View Options.

Full feature free trial 30-day, no credit card required Get It Now. Kutools for Excel - Includes more than 300 handy tools for Excel. Lately it seems like 1/3 of the time I can do that, 1/3 of the time all the tabs automatically re-open, and 1/3 the time theres nothing there. If you can't see the tabs in an Excel Workbook, try the following: Method 1. Also with Kutools for Excel installed, you can apply its View Options utility to quickly display or hide the entire Sheet Tab Bar easily in Excel. Usually if I have say 20 tabs open, I can close Edge or reboot or whatever, then when I come back I can go to 'recently closed tabs' and it will let me open all 20 of them. How to Fix: Excel Worksheet Tabs not Visible. This article provides detailed instructions to resolve the 'missing sheets' issue on a Excel Workbook. After solving the 'Excel tabs missing' problem on his computer, I decided to write a tutorial with the detailed steps I followed to restore the missing sheet tabs from the Excel file. A few days ago, one of my clients mentioned to me that sheet tabs are missing in one of the Excel workbooks.

My tabs are gone