What To Do When Worksheet Tabs Go Missing

86

It can be disconcerting when you open an Excel workbook that has several worksheets, but you only see single worksheet. If this happens, your "missing" worksheets may be hiding in plain sight due to a simple Excel setting. In addition to restoring vanished worksheet tabs, I'll also describe a couple of techniques for navigating workbooks easier, as well as other ways to find hidden worksheets.

Typically, within an Excel workbook you'll see worksheet tabs along the bottom of the screen, but it's also possible to hide the worksheet tabs, as shown in Figure 1. To manage this setting:

Please Login or Register to read the full article

To access all of the content on our site, register (it's free!) or login to your existing account.

Replies

Please login or register to join the discussion.

Thank you kindly - Great advice

Thanks (0)

Thanks, Ned! I appreciate the feedback!

Thanks (0)

This is excellent advice. As a paper coordinator of several distance papers that use excel workbooks for assignments, I often have to help students who have 'lost ' the tabs. You explain it very well.

Thanks (0)

This is one of the most thoughtful responses I've received for one of my articles. Thank you so much!

Thanks (0)

THANK YOU!!! You are a life saver!

Thanks (0)

I'm so glad you found my article helpful. Thank you!

Thanks (0)

Dave - thanks for the advice - except that in my case it doesn't seem to work. I have followed your instructions meticulously and have observed how happy other users of your advice are.

My problem is as follows:

A spread sheet that I have used for quite a while, suddenly appears without showing:
1.Bottom Tabs
2.Top Cell Alphabetical grid labels
3. File Name (so I cannot double click this line as one of your solutions)
Please help I'm pretty desparate.

Thanks (0)

Darryl,

At this point I'd need to see your spreadsheet. Upload it to my web site and I'll be glad to take a look at no charge:

http://www.acctadv.com/upload-...

David

Thanks (0)

Thanks. Good one. Really helpful.

Thanks (0)

I appreciate the feedback!

Thanks (0)

thanks

Thanks (0)

Thanks

Thanks (0)

I work on an Excel Workbook created at the office in Excel 2007 but use Excel 2010 when working on this same workbook at home. I can only see the three sheets in my workbook in fullscreen view, which hides the ribbon.
Can I fool my Excel 2010 into thinking its from 2007? File/Options/Advanced/
Display/Show Sheets box is checked but sheets are hidden except in FullScreen view
edit
Not sure what I did but after unchecking and rechecking I maximized the window and all my sheets appeared.

Thanks (0)

Kenneth,

I was going to say that the techniques in my article should have revealed the tabs for you. The Windows operating system sometimes does wacky things with regard to storing positions of program and document windows onscreen. Regardless, I'm glad you got it resolved, as you shouldn't have had a different experience in 2010 versus 2007.

David

Thanks (0)

thank u so much

Thanks (0)

My pleasure.

Thanks (0)

finally it worked by double clicking thw workbook title.....thank you

Thanks (0)

Thanks for sharing your experience. I'm my article was helpful!

Thanks (0)

You are a great mentor!

Thanks (0)

Well that's awfully nice of you to say! Thank you! I'm so glad that you find my articles helpful!

Thanks (0)

I found your advice tremendously helpful, was about ready to :((( because I couldn't find the tabs. I got it to work by double clicking the workbook title. Many thanks!!!

Thanks (0)

You're quite welcome. It's a vexing problem for many users, so I'm glad you found my article!

Thanks (0)

THANK YOU!!

Thanks (0)

Thank you so much! You save my day, omg.

Thanks (0)

I'm glad to be of assistance. Thanks for reading!

Thanks (0)

I discovered that there are two minimize tabs. When I click the bottom one my spreadsheet is minimized but a big blue screen is behind it and my tabs are gone. If I drag the minimized screen to fit in the blue screen the tabs do not come back. Hope it helps someone.

Thanks (0)

Oops. I meant if you minimize the bottom tab and then the top tab you will lose your tabs. Some how I did that and it took me 45 minutes to figure it out. Thank goodness I save to a thumb drive after each use.

Thanks (0)

THANKS

Thanks (0)

I have Excel 2010, can I find worksheets (tabs) within a workbook through a "search function"? I have an abundance of tabs in one file and often I am asked to locate one that I did months ago...

Thanks (0)

Great question. See the image below for a hidden menu that you can use. If you choose More Sheets from the menu a dialog box will appear. You can then navigate that list by typing the first letter of the desired sheet name if you remember what it is.

Thanks (0)

One of my co-workers is missing the worksheet tabs in Excel 2010. She did something that hid them, but she doesn't know what! LOL!!
I have followed all of the suggestions on this website to try to get them back for her, but the only option I can find to work is the 'Ctrl, Page Up' option. The 'Show Sheet Tabs' box IS checked. The 'Workbook Name' does not appear in her Excel window (nor on mine, now that I look), I don't think it ever has, so I can't try that option. What am I missing?? :(

Thanks (0)

With the Excel document that is not showing the tabs open, try pressing 'New Window' under the View tab. This may focus the worksheet so you can maximize it (if it is not already). At a minimum it should show you tabs... at least this has been my experience when this has happened to a coworker.

Thanks (0)

Research Guy, clever! Thanks for contributing. Gina, I just now saw your question. If you continue to have more problems, let me know and we'll do our best to get you some help!

Thanks (0)

works awesom!

Thanks (0)

I'm glad to hear that. Thanks for the feedback!

Thanks (0)

This has literally just saved my day - THANK YOU!

Thanks (0)

Super! Thanks for taking the time to share your thoughts!

Thanks (0)

Wow, I got my data now. Thank you very much

Thanks (0)

Fabulous! I'm glad to hear that. Thanks for sharing your experience.

Thanks (0)

I have tried the above but had no luck. DO you know if saving a multi tab workbook as a csv file deletes the second tab?

Thanks (0)

When you save a spreadsheet as a CSV file then it's no longer an Excel spreadsheet with tabs, but rather just a simple text file that you could open in Notepad, Microsoft Word, or other similar programs. When you save a file as CSV, the additional tabs aren't truly lost until you close the workbook, so if you save as CSV accidentally, you can resave again in another format as long as you do so before closing the spreadsheet.

Thanks (0)

anyway to retrieve the file after saving and closing the workbook ?

Thanks (0)
Thanks (0)

Thanks for sharing the information. I found my worksheet tabs!

Thanks (0)

That's great! I'm glad you found my article helpful!

Thanks (0)

Hi David..This is really help me to findout the sheets..Thanks...

Thanks (0)

I'm so glad! Clearly it's a frustrating problem for a lot of users! Thank you for the feedback.

Thanks (0)

Thank you :)

Thanks (0)

You're welcome! I'm happy I could help!

Thanks (0)

hi i lost home, insert, formulas and all tabs....how could i get back?

Thanks (0)

Pages