Worksheet tabs don't show at bottom of Excel Workbook

Question

Level 1

7 points

Worksheet tabs don't show at bottom of Excel Workbook

I’m new to Apple as well as this group. I'm not sure if this is the right Community for what I think is real an issue with software. If I'm in the wrong community I apologize and would appreciate being directed to the correct one. .

I'm using an older MacBook Pro with OS-X 6.8. I’m using Office 2011 for Mac. I have an .xls workbook with a number of worksheets in it. I’ve to have the workbook open each time I open Excel and it does.

In Excel’s Settings I have checked “Show sheet tabs”. Before closing the workbook I have also checked to make sure that the “Windows of Open Workbook is checked and it is. However whenever I reopen Excel after previously shutting down the computer, and occasionally when I close Excel and reopen it in the same computer session, “Windows of Open Workbook” has mysteriously come unchecked and my tabs do not appear at the bottom of the workbook. Can this be stopped and if so how?

MacBook Pro, iOS 6.1.4, 10.6.8

Posted on Aug 5, 2013 6:00 AM

Reply

Answer 1

Dec 9, 2015 8:52 AM in response to Csound1

This is in Yosemite with Excel 2011.

• Open your troublesome worksheet.

• In the Window menu, choose New Window. You should see the status bar at the bottom and your new (duplicated) document will have the same title your old one did, appended with a "2".

• Make a change to and save the new "2" worksheet.

• Close both worksheets.

• In the File Menu, choose Open Recent. Only your original should appear there, and it should now have the status bar.

Reply