LinkBack URL
About LinkBacks
I created an Excel spreadsheet on a Mac book and transferred the document to a PC. I am unable to move from one sheet to another within the workbook because the tabs do not appear at the bottom of the window in the PC.
I created an Excel spreadsheet on a Mac book and transferred the document to a PC. I am unable to move from one sheet to another within the workbook because the tabs do not appear at the bottom of the window in the PC.
Can you select the View Ribbon and choose to show tabs?
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you so much. The View box in my drop down menu does not provide the option to "show tabs" What is the View Ribbon?
Not got a PC handy at the moment but, you normally start with the "home" ribbon that has things like formatting. But you should see other options like Insert and View, amongst others. Can you see those options?
I am using a 2003 version of MS Word on my PC. It does show Insert, Format, View etc. on the menu at the top but none of the drop down menu buttons allow me to view the tabs.
Ah, I did not notice that in your profile. Unfortunately, I cannot remember what the menus look like on 2003. I'll ask around.
Hi Robyn
In Excel 2003...
Click on Tools ---> Options ---> View ---> Check Sheet Tabs...
Sheet Tabs Excel 2003.jpg
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Thanks. I went to the options/view window but the sheet/tabs was already checked. I tried unchecking it and checking it again, but it didn't work. I think it must be an incompatibility issue between Mac and PC.
Hi Robyn
Didn't realize we were dealing with the Mac.
I have 2011 for the Mac. If you'll upload your File I'll be happy to look at it.
I am having problems with my tabs as well. I have the Sheet tabs checked off but they still do not show. I am using excel 2000.
Can you upload the file here?
Or, you can try this code:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks