How to Unhide - Hide Worksheet tabs

[jarhtmd]

I'm using Excel 2007 . . . I know it's old, but so am I and I've seen no valid reason for going to the expense of upgrading.

I have a small workbook with a only a couple of (about 125x20) worksheets. Suddenly, while making minor updates on "sheet1", I discovered that "sheet2" wasn't available anymore. In fact, no worksheet tabs were visible at all (at the bottom), not even "sheet1". I can only see the data on "sheet1". I googled, but nothing seemed to work. Some offered options that wouldn't even allow me to change them.

After several tries, without knowing changing anything, I was finally able to create a new empty workbook which showed tabs for sheets 1,2,3. Several tries had opened empty workbooks, but without any sheet tabs. I managed to copy the accessible (sheet1) data from my (still open) "problem" workbook into sheet1 of the newly created workbook. I manually named the sheet tab and had to review & manually adjust all the column/row heights and widths. Auto isn't applicable here.

None of my original backups (some several weeks old) opened showing sheet tabs & therefore I wasn't able to copy sheet2 data into the new workbook as I had done with sheet1 data.

Before this problem, the default parameters were in effect for all my workbooks, even my 1-sheet workbooks show empty sheet2 & sheet3.
1. What could I have done that caused the hiding of the worksheet tabs?
2. How can I unhide hidden sheets? I have other workbooks that contain many worksheets. I'm actually afraid to open them, for fear of losing valuable data.

Thanks for your help.

[MarvinP]

Hi jarhtmd,

I'm old too!!
In the newest version of Excel which use, there is a setting in the File -> Options -> Advanced to show or not show sheet tabs. I wonder where that setting is in your 2007 version?

[Croweater]

Hi jarhtmd,

I'm old too!!
In the newest version of Excel which use, there is a setting in the File -> Options -> Advanced to show or not show sheet tabs. I wonder where that setting is in your 2007 version?

If this didn't work for you try...
Tools--->Options----> View tab

Then in the Window Options section check 'Sheet Tabs' and OK

[jarhtmd]

Thanks, Marvin P and Croweater.

I could not find either File -> Options -> Advanced OR Tools--->Options----> View tab.

Now in my additional searching (I thought I had already looked everywhere) I've found View >> Window >> Unhide which seems to have fixed my problem.

I would mark this thread solved, but I don't know how.

Thanks, again.

[MarvinP]

Hi Jarhtmd,

To mark this thread solved... Edit the original post, at the top, and change the Prefix to Solved.
Sorry we didn't help AND glad you found another way around your problem.

[jarhtmd]

Hi Marvin P

You and Croweater did indeed help . . . a lot! I was very frustrated, pretty much at my wits end and afraid that I may have lost some valuable (to me) data. I knew there had to be a solution. Your help spurred me on to more searching and clicking this & that (in a test workbook, of course).

I've saved all this in my "How to" documents for future reference.

Thanks again.

[Croweater]

You're welcome. Always good to get some feedback no matter how much or little time you spend trying to help someone out.

Cheers.