Learn how to create Excel workbooks that are more accessible to people with disabilities, or who are using assistive technologies. Windows macOS Android.
When I have several workbooks open, when I switch between workbooks the sheet tabs are missing (most, but not all of the time - it's somewhat random and each worksheet will sometimes show the tabs, but usually not). I also can't get the screen to scroll when selecting a range that goes off the bottom of the screen.
I can only show the tabs and fix the problem by twice clicking on the green circle at top left of the screen. I have show sheet tabs set in Preferences, and none of the sheets are set to be hidden. I had a similar problem in an excel file with three sheets. When I activated one of the sheets the tabs would disappear and I couldn't get back to the other sheets.
Here's how I fixed it. I saved the file to the cloud and then opened it on a PC using Office 2013, checked to see if the problem was still there, and yes it was.
In the tab-less sheet I clicked on VIEW and noticed that the SPLIT option was turned on. I turned it off and the tabs reappeared. I saved the document and that seems to have worked. Hope this helps someone. If anyone know the Mac-equivalent commands in Excel please let us know.
MacBook Air (Early 2015), OS X Yosemite 10.10.5 and Excel for Mac 2011, ver 14.5.9.
Hey, I think that to do this you would have to write a macro with VBA and here are some examples about how to do this with macro and VBA – as given in these examples - & as also given in here - and see that these examples might be for Excel for Windows but can also be applied to Excel for Mac. Note that these links given above are only given as examples to show how it can be done through writing a macro and may not be exactly apply to your context, for which you may have to do so code writing yourself based on these above examples.