This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Yesterday I was helping a friend make duplicates of Excel 2007 files. We simply did a "Save As" and gave the new version a different name. Each of the workbooks had several worksheets in them. Everything worked perfectly.
He called me this morning to say that he opened the same Excel (2007) files today, but he can't see the tabs for the worksheets, nor can he see the horizontal scroll bar at the bottom of the page. This is true for all of the files - both the originals and the ones created using "Save As".
I know he hasn't lost any material, but I don't know how to restore/unhide the tabs and scroll bar. When we looked in "Excel Options"/Advanced, the horizontal scroll bar and the "shw sheet tab" check boxes are both checked.
Can you help us restore the view to the way it was so he can see the worksheet tabs and horizontal scroll bar?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
For Excel 2010, provided advanced options are set to see scroll bars and worksheet tabs, try this: with the problem worksheet on the screen go to VIEW, ARRANGE ALL, and check Windows of Active workbook. Worked for me.
Hi Steve
Your friend can access each sheet using CTRL and Page up and CTRL + PAGE Down? or F5 goto as an immediate work around.
It is perplexing to find that the options settings are as you describe ON. Is the workbook maximised? I feel sure that it will be but worth asking. Is the operating system Windows 7? There have been some issues (I am not claiming this is one but ...) worth considering.
The horizontal scroll bar may be hiding the tabs because it is set to fill the whole of the scroll bar area, in which case it my not even look like a scroll bar.
Hope some of this helps.
Pat PS If you found this useful please vote. Thank you:¬)
Patrick,
Thank you so much for your thoughtful input.
In fact, he had accidentally minimized it when he clicked on the tiny "minimize" button that is directly underneath the large minimize button in the upper right corner.
It was a bit of a ponder trying to figure out what he could do in one or two clicks to make those things disappear. He's a happy camper now.
Thanks again,
Steve
This is what worked for me!
Thanks,
Thank you, thank you, thank you!!!!!