What To Do When Worksheet Tabs Go Missing

85

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.

avatar
By Ned
Jun 26th 2015 01:11

Thank you kindly - Great advice

Thanks (0)
avatar
By David Ringstrom
Jun 26th 2015 01:11

Thanks, Ned! I appreciate the feedback!

Thanks (0)
avatar
By Ngaire
Jun 26th 2015 01:11

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)
avatar
By David Ringstrom
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By Jessica
Jun 26th 2015 01:11

THANK YOU!!! You are a life saver!

Thanks (0)
avatar
By Darryl
Jun 26th 2015 01:11

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)
avatar
By David Ringstrom
Jun 26th 2015 01:11

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)
avatar
By Mahes Waran
Jun 26th 2015 01:11

Thanks. Good one. Really helpful.

Thanks (0)
avatar
By David Ringstrom
Jun 26th 2015 01:11

I appreciate the feedback!

Thanks (0)
avatar
By Baher Abdou
Jun 26th 2015 01:11

thanks

Thanks (0)
avatar
By Sanju
Jun 26th 2015 01:11

Thanks

Thanks (0)
avatar
By Kenneth Browne
Jun 26th 2015 01:11

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)
avatar
By David Ringstrom
Jun 26th 2015 01:11

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)
avatar
By Grv Pandey
Jun 26th 2015 01:11

thank u so much

Thanks (0)
avatar
By David Ringstrom
Jun 26th 2015 01:11

My pleasure.

Thanks (0)
avatar
By Linda
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By David Ringstrom
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By Jim
Jun 26th 2015 01:11

You are a great mentor!

Thanks (0)
avatar
By David Ringstrom
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By LadyWriter
Jun 26th 2015 01:11

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)
avatar
By David Ringstrom
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By Marqurn
Jun 26th 2015 01:11

THANK YOU!!

Thanks (0)
avatar
By Nerdy Azura
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By David Ringstrom
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By Rich G
Jun 26th 2015 01:11

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)
avatar
By Rich G
Jun 26th 2015 01:11

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)
avatar
By GEJO
Jun 26th 2015 01:11

THANKS

Thanks (0)
avatar
By Marian Rose
Jun 26th 2015 01:11

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)
avatar
By David Ringstrom
Jun 26th 2015 01:11

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)
avatar
By Gina Banker
Jun 26th 2015 01:11

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)
avatar
By Research Guy
Jun 26th 2015 01:11

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)
avatar
By David Ringstrom
Jun 26th 2015 01:11

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)
avatar
By Eben Samuel
Jun 26th 2015 01:11

works awesom!

Thanks (0)
avatar
By David Ringstrom
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By samchedz
Jun 26th 2015 01:11

This has literally just saved my day - THANK YOU!

Thanks (0)
avatar
By David Ringstrom
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By Tom
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By David Ringstrom
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By Donal OReilly
Jun 26th 2015 01:11

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)
avatar
By David Ringstrom
Jun 26th 2015 01:11

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)
avatar
By atif
Jun 26th 2015 01:12

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

Thanks (0)
avatar
By David Ringstrom
Jun 26th 2015 01:12
Thanks (0)
avatar
By Sue Tucker
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By David Ringstrom
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By Arnab Dutta
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By David Ringstrom
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By Gerald
Jun 26th 2015 01:11

Thank you :)

Thanks (0)
avatar
By David Ringstrom
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By tholsss
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By David Ringstrom
Jun 26th 2015 01:11

Two different circumstances can cause this. One is clicking Full Screen on the View tab, but pressing the Escape key should restore the menu. The second is an Excel macro you ran (perhaps unknowlingly) has hidden the menu interface known as the Ribbon. To restore it, open Excel, and then press Alt-F11 to launch the Visual Basic Editor. Within the VBE choose View, and then Immediate Window. Copy and paste this line of code into the Immediate window and then press Enter:

Application.ExecuteExcel4Macro "Show.toolbar(""Ribbon"",true)"

Make sure to copy and paste the text exactly as shown above. Let me know how it goes.

Thanks (0)

Pages