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
Dude,
I have no idea who you are but you have just made my life better! Thank you!
Now all I have to do is remember this for next time!
Cheers and Thanks!
Mickey
If all the above fails make sure the horizontal scroll bar hasn't been accidentally dragged off to the right. Mine was!
To get the scroll bar back, look at the bottom right hand corner of the spreadsheet for 3 vertical grey dots at the same vertical level as the tabs. Hover over the 3 grey dots and then the 'Left/Right' icon will appear (2 small vertical parallel bars with arrows pointing left and right. Click and hold down on the icon, then drag left until you are happy with the amount of scroll bar showing.