Show scroll bars all the time
I will appreciate the possibility to have the horizontal and vertical scroll bars show all the time
We’ve fixed this issue as of 15.15, and scrollbar visibility should now be respected.
I'm using Excel for Mac version 16.16.16. My Scroll bars have virtually vanished becoming a blob down the side of the screen. Apart from costing me 1 hour of my life trying to work out what has happened, I would like to set it back to the permanently visible ones, as I need them to drive complicated spreadsheets.
How do I do it?
...and how can I stop any more ill thought out upgrades in the future?
Lisa Batts commented
I have version 15.41 and its STILL a problem.
Hello I have a work around that work 100% of the time and I have tested it on two Mac's. I do not know if it is Mac OS ( I suspect it is) or the interaction of Mac OS with Excel but here goes. If you go to Mac System Preferences> General and change the scroll bar option form Always to any of the other two options (Automatically based on mouse or When scrolling) When you hover over the right side of the Excel or the bottom where the school bars are supposed to be they will show up and are usable to do what you need no problem. However you will have the frustrating issue show up in all other applications like Safari, Firefox, etc. Clicking back to always in the Show Scroll bars in Preferences will break Excel again and cause your other apps to work correctly (Always show scroll bars). I updated to 15.29.1 of Excel and now with the Always show option in system preferences I can scroll the cells correctly. However it will not show a dark scroll bar. You will see a white space to the far right and bottom. If you click in either spaces, and scroll like you would normally do, even though it cooers there is no scroll bar, you will see the cells scroll up and down. All your other apps will show the dark scroll bar always as you would expect. So looks like it is fixed but you do not see a dark scroll bar, only a white space. Clicking and holding down the mouse button and moving left or right or up and down will scroll your cells.
Excel now respects the OS X system preference to always show scroll bars as of version 15.15
I believe that version 15.14 fixes the issue so that the OS X system settings are now followed. This is in my opinion how it should be.
However, there are still major bugs in the scroll bars which is reported in a separate thread.
Jon Peltier commented
You can set this in the Mac System Preferences. Apple gets mad when programmers impose things like scrollbars outside of user settings like this.
Please fix this scroll bar issue! It's an extremely inefficient way to work. Perhaps that's why it's taking Microsoft so long to fix the issue?!
Yes, I want the scroll bars back in Excel. As soon as possible. Tantalizing, vanishing scroll bars are even worse than no scroll bars.
Chris S commented
Today's update, 15.15, did not fix this issue. I'm afraid we are still stuck on 2011 from a usability standpoint. This is awful. Not only do the scroll bars not do that (which was the claim) scrolling is incredibly laggy and jerky.
I've uploaded a video here: https://twitter.com/rxcs/status/654031164001247232
OMG! I need the scroll bar back and wider like windows version! Its annoying to try finding the scrollbar! Please Fix!!!!!
UGH! Please put a native option to have the scrollbars on all the time. Ridiculous!
Arseni Timofeev commented
One more vote! Here is illustrative video: https://www.youtube.com/watch?v=MN6-ZFmB9Wk&feature=youtu.be
We've identified the root cause of this and will get a fix to you all as soon as we can verify its stability - thanks again for your help identifying this issue!
Ernest Anderson commented
Fix it! This is basic core functionality spreadsheet stuff that your QA team should be embarrassed they missed, as it makes Excel nearly unusable.
W. Curtis Preston commented
So your suggestion to make your program work correctly, I have to tell all other programs to go back to the auto-hide scroll bar thing. Wonderful.
Just fix your product to adhere to the OSX setting, or have your own setting.
Have been banging my head all day on this one - at least I can now see this is a M/S bug.
Simon Chapple commented
Just to add my voice too. I want scrollbars on all the time for all my Mac apps (set with system preference), and currently Excel is not doing this and its really hurting my productivity - I am using a magic mouse - I don't really want to have to buy a trackpad just to make this less painful. I am using latest Excel 2016 and OSX Yosemite.
Hi Elena, we're aware of an issue related to the OS preference to "Always Show" scroll bars and are investigating the cause of it. In the meantime, you should see better scroll bar behavior if you set Preferences > General > Show scroll bars to "Automatically based on mouse or trackpad" or "When scrolling"
Thanks for your feedback!
it would be nice if it simply followed the behavior specified in the Mac OS preferences. I have mine set to always show control bars. Works in EVERY OTHER application EXCEPT Excel.
Tammy Gross commented
This is just one of many annoyances, but it is probably top issue.