Can't see worksheet tabs - Excel 2011 for Mac, excel version 14.7.7

%3CLINGO-SUB%20id%3D%22lingo-sub-1475415%22%20slang%3D%22en-US%22%3ECan't%20see%20worksheet%20tabs%20-%20Excel%202011%20for%20Mac%2C%20excel%20version%2014.7.7%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1475415%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20working%20in%20excel%202011%20for%20Mac%2C%20excel%20version%2014.7.7.%26nbsp%3B%20On%20several%20of%20my%20files%20I%20cannot%20see%20the%20sheet%20tabs%20at%20the%20bottom%20of%20the%20screen.%20I%20found%20instructions%20on%20line%20to%20turn%20sheet%20tabs%20on%2C%20via%20the%20commands%20Excel%20%2F%20preferences%20%2F%20view.%26nbsp%3B%20That%20gets%20me%20to%20a%20menu%20that%20includes%20the%20option%20to%20turn%20on%20sheet%20tabs.%26nbsp%3B%20It%20is%20checked%2C%20i.e.%20in%20principle%20sheet%20tabs%20are%20turned%20on.%26nbsp%3B%20Tabs%20are%20not%20visible.%26nbsp%3B%20Screenshot%20of%20that%20menu%20is%20here%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202020-06-18%20at%2018.06.03.png%22%20style%3D%22width%3A%20515px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F199576i10F1738D0EDCBA44%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Screen%20Shot%202020-06-18%20at%2018.06.03.png%22%20alt%3D%22Screen%20Shot%202020-06-18%20at%2018.06.03.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20unclicking%20it%20and%20then%20clicking%20it%20again.%26nbsp%3B%20Nothing%20changed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20unclicking%20it%2C%20saving%20the%20file%2C%20closing%20the%20file%2C%20reopening%20the%20file%2C%20clicking%20it%20again%2C%20saving%20the%20file%2C%20closing%20the%20file%2C%20and%20then%20reopening%20the%20file%20again.%26nbsp%3B%20Nothing%20changed.%26nbsp%3B%20Still%20can't%20see%20worksheet%20tabs.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20creating%20a%20second%20worksheet%20in%20the%20file.%26nbsp%3B%20That%20put%20me%20in%20the%20new%20blank%20worksheet%2C%20unable%20to%20get%20back%20to%20the%20original%20worksheet%20with%20content.%26nbsp%3B%20(Fortunately%2C%20I%20could%20delete%20that%20new%20blank%20worksheet%2C%20so%20I%20wasn't%20lost%20and%20unable%20to%20get%20back%20to%20my%20work.)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20any%20suggestions%20for%20how%20I%20can%20create%20a%20second%20worksheet%20in%20this%20file%20and%20actually%20see%20the%20tabs%20so%20I%20can%20go%20between%20the%20worksheets%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20in%20the%20past%20I%20have%20dealt%20with%20this%20problem%20by%20cutting%20and%20pasting%20the%20contents%20of%20the%20first%20worksheet%20into%20a%20new%20file%20altogether%2C%20and%20using%20that.%26nbsp%3B%20However%20this%20file%20has%20links%20to%20other%20files%2C%20and%20when%20I%20tried%20cutting%20and%20pasting%2C%20the%20copied%20version%20had%20lost%20those%20links.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can't%20try%20%22copy%20worksheet%22%20into%20a%20new%20file%2C%20since%20I%20can't%20access%20sheet%20tabs%20to%20do%20that.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%20for%20how%20to%20deal%20with%20this%3F%26nbsp%3B%20Thank%20you%20in%20advance!%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1475415%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1476537%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20see%20worksheet%20tabs%20-%20Excel%202011%20for%20Mac%2C%20excel%20version%2014.7.7%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1476537%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F704018%22%20target%3D%22_blank%22%3E%40catteau%3C%2FA%3E%26nbsp%3BHappen%20to%20have%20this%20old%20version%20still%20working%20on%20an%20old%20iMac.%20Can't%20explain%20why%20the%20tabs%20don't%20re-appear%20when%20you%20do%20the%20setting%20you%20describe.%20However%2C%20you%20should%20still%20be%20able%20to%20move%20between%20sheets%20by%20pressing%20%3CSTRONG%3Ealt%3C%2FSTRONG%3E%20and%20the%20%3CSTRONG%3Eleft%3C%2FSTRONG%3E%20or%20%3CSTRONG%3Eright%3C%2FSTRONG%3E%20%3CSTRONG%3Earrow%3C%2FSTRONG%3E%20simultaneously.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1478114%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20see%20worksheet%20tabs%20-%20Excel%202011%20for%20Mac%2C%20excel%20version%2014.7.7%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1478114%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%20%26nbsp%3BThank%20you!%26nbsp%3B%20There%20isn't%20actually%20an%20alt%20key%20on%20a%20mac%20keyboard%2C%20but%20option-left%20arrow%20or%20option-right%20arrow%20does%20move%20me%20from%20sheet%20to%20sheet.%26nbsp%3B%20That's%20at%20least%20part%20of%20the%20problem%20solved.%26nbsp%3B%20Hopefully%20none%20of%20my%20complex%20spreadsheets%20that%20have%20a%20lot%20of%20sheets%20where%20I%20need%20to%20see%20the%20labels%20will%20convert%20themselves%20into%20the%20sheet-tab-invisible%20variant!%26nbsp%3B%20Well%2C%20one%20of%20these%20days%20I'll%20get%20a%20new%20computer%2C%20too%2C%20and%20a%20new%20version%20of%20MS%20Office%2C%20and%20maybe%20that%20will%20behave%20better.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Deleted
Not applicable

I am working in excel 2011 for Mac, excel version 14.7.7.  On several of my files I cannot see the sheet tabs at the bottom of the screen. I found instructions on line to turn sheet tabs on, via the commands Excel / preferences / view.  That gets me to a menu that includes the option to turn on sheet tabs.  It is checked, i.e. in principle sheet tabs are turned on.  Tabs are not visible.  Screenshot of that menu is here:

 

Screen Shot 2020-06-18 at 18.06.03.png

 

I tried unclicking it and then clicking it again.  Nothing changed.

 

I tried unclicking it, saving the file, closing the file, reopening the file, clicking it again, saving the file, closing the file, and then reopening the file again.  Nothing changed.  Still can't see worksheet tabs.  

 

I tried creating a second worksheet in the file.  That put me in the new blank worksheet, unable to get back to the original worksheet with content.  (Fortunately, I could delete that new blank worksheet, so I wasn't lost and unable to get back to my work.)

 

Does anyone have any suggestions for how I can create a second worksheet in this file and actually see the tabs so I can go between the worksheets?

 

I think in the past I have dealt with this problem by cutting and pasting the contents of the first worksheet into a new file altogether, and using that.  However this file has links to other files, and when I tried cutting and pasting, the copied version had lost those links.

 

I can't try "copy worksheet" into a new file, since I can't access sheet tabs to do that.  

 

Any suggestions for how to deal with this?  Thank you in advance!  

2 Replies
Highlighted

@Deleted Happen to have this old version still working on an old iMac. Can't explain why the tabs don't re-appear when you do the setting you describe. However, you should still be able to move between sheets by pressing alt and the left or right arrow simultaneously. 

Highlighted

@Riny_van_Eekelen   Thank you!  There isn't actually an alt key on a mac keyboard, but option-left arrow or option-right arrow does move me from sheet to sheet.  That's at least part of the problem solved.  Hopefully none of my complex spreadsheets that have a lot of sheets where I need to see the labels will convert themselves into the sheet-tab-invisible variant!  Well, one of these days I'll get a new computer, too, and a new version of MS Office, and maybe that will behave better.