Have Excel scroll better when there are large cells.
If there's a really tall or wide cell, Excel jumps to the edge of the cell when scrolling past that area. This is a big pain when, for example:
- trying to position a shape
- Trying to grab the edge of the row or column in order to resize it.
Excel should just scroll normally without jumping.
Good news! We’ve started working on this suggestion, and we’re currently testing the improved scrolling experience in our lab. It will allow you to stop partway through the row or column. The sheet will no longer need to snap to the top and left edge of the cells. Since scrolling is such a fundamental and highly used action in Excel, it may take a while to get it right. We hope to have it ready within a few months, but can’t provide an exact target date just yet. Thanks again for all your support and patience for this long awaited improvement.
We’ll post an update here when we start rolling it out for you to try. It will be made available to Office Insiders first. Here’s how you can join – https://insider.office.com/en-us/join/windows.
Thanks – Steve [Microsoft Excel]
@Corey, so what you're saying is that MS is not the only spreadsheet with a smooth scrolling issue.
I just happened to be playing around in Google Sheets. And it's pretty Excel "feature-compliant" too in this area.
FWIW, someone has asked about Google Sheets being able to do smooth scrolling:
One of these days when you are in your 90s your great grandson will be showing you his new data entry job and you will notice the scrolling on excel is finally smooth.
I highly(!!!) doubt we'll get a release date ahead of the actual release.
Any word on when this will be complete? It's SUPER annoying!
Unfortunately, I imagine MS will only implement the fix on future versions of Excel vs including it as a feature update. I'm sure they'll use any means they can to get people to upgrade to the latest version. ($$$)
Thank you for letting us know that it will be implemented somewhere in the future. It has been driving me mad for years and I often try to find a solution, so I'm really really glad that it is finally implemented.
I do think that it should have been a thing from the start, so I don't know whether I should be angry or thankful. I think I'm both at the same time. Well, better late than never. :)
Thank you for finally working on fixing the scroll problem :D
@Tim - LOL, you must be new around here.
Seriously, though... It's not something we'll ever know. And it will likely be a long time. It took 5 years just for MS to put this on their planning map. Software dev is notoriously slow, and MS makes normal dev times look like ludicrous speed. "They've gone plaid!" ;P
When is this coming?
It is finally in planning phase! I never thought I would live to see the day. Seriously though... please make sure it is easy to toggle between the two (smooth and snap), or otherwise configure in the options. Smooth should be the default for mouse scroll wheel, middle mouse button click and drag, scroll bar, etc. Snap is default for arrow keys.
Shawn Lewis commented
Lol, my solution to the problem is to buy a 49" super-wide monitor and never make sheets where I have to scroll down.
5 _Y E A R S_ LATER.
_J U S T_ STARTED DEV. (!!!!!!!!!!!!!!!!!!!!)
@Steve K [Excel] - I know you updated the status of this suggestion (and many others) very recently. Reading thru recent comments, you can see how little faith the super user base has when it comes to the efforts and results of previous Excel team owners.
I truly hope you you can turn this around and restore our faith in MS by listening to our suggestions and delivering on updates in a timely manner. Frequent updates to "Planned" changes will go along way restoring that faith and the goodwill of MS.
I hope my grandson will have this awesome feature
Leo CM commented
5 years later....
This would be a big help, I keep skipping rows when presenting to clients
Microsoft = slowest company ever. unuserfriendly. like the stupid path limit.
Nathan Davis commented
My general vote is for smooth scrolling. If there is any snapping at all, it should be limited to cells that are a single "line" high, and perhaps only snap to the cell if the row is selected and already "near" the top.
Michael Skoczen commented
Here is my answer to question 5 on the survey.
I also agree with the Anonymous, if it was changed to only smooth scroll, I would vote to restore some snapping the lack of alignment would irritate me.
@ROBERT LACKOWSKI - I agree with you. And while it is outside the scope of this topic, it would be great to have just a sliver of gray spaces to show the borders of cells in the top most visible row and left most visible column. Maybe not even gray space, just display the cell borders. Can't count how many times I've wanted to see that.