Worksheets visibility in Excel 2007

I have Excel 2007. I am attaching 2 screenshots showing this problem:

When the page is maximized, the worksheet tabs on the bottom are visible, but when the document is any size smaller than maximum, the worksheet tabs are not visible. How do I make them visible?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Wayne Taylor (webtubbs)Commented:
The actual Workbook window is not maximized. Maximize that window as per the below image and the worksheet tabs will always be visible when changing the size of the application window.

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rob HensonFinance AnalystCommented:
The screenshots show that you have Maximised and Resized (not Minimised) the application but not the workbook within the application.

When the Workbook is Maximised you will get no blue/grey area around the Workbook window and you will see the tabs. Use the button as shown by Wayne's comment above. You will then see both sets of Maximise, Resize and Minimise buttons next to each other in the top right hand corner and the Application Title bar will show the active file name.

When the application is Minimised it will only show on the Tool Bar. When the Window within the Application is minimised, it will show like a tool bar button along the bottom of the application window.

Rob H
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.