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.
I’m happy to let you know that we are in the planning stages to make Excel for Windows scroll without jumping to the edge of the cell so you’ll be able to scroll smoothly. We don’t yet have a target date, but wanted to tell you about our plans.
We appreciate all the votes and comments supporting this suggestion.
Thanks – Steve K [Excel]
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.
Toggle, toggle, toggle! Any feature that pivots on a usability preference must have a toggle between original behavior and the new behavior. All the options in the survey are good... sometimes or to someone. Locking into smooth scrolling is the quickest way to get a new "idea" thread to bring back the original snapping behavior.
ROBERT LACKOWSKI commented
Sort of tangential to this topic, but I think one of the disadvantages of snapping is that you can only scroll up to A1, and no farther. It's common for me to apply borders to cells in the first row or column, but you can't verify that the borders have been applied because you can't see them in the default view mode. Sometimes you don't catch a missing border until after you've printed the table. With smooth scrolling, you could potentially pad the upper corner with a gray space, a space where you can see outside the top and left edges. I'd like to start all my tables at A1, but I end up avoiding this because it means working in the upper left hand corner of my monitor, and not knowing what the borders are going to look like.
I added a comment in my survey response requesting backwards compatibility with older Office/Excel versions. As much as I dream of a day with smooth scrolling, if it's only applied to new/future versions of Excel it will be years until I see it.
@Florian, I agree with Florian's staement, smooth scrolling all the time, no snapping. K.I.S.S.
Please fix this? commented
In my humble opinion - I think that the most intuitive layout would be the following:
Smooth scrolling for any inputs which typically on modern applications move smoothly - these being: Mouse scroll wheel, scroll bar, touch screen panning, or touch pad scrolling. This should hold true all the time I think, it's how we expect applications to act.
With the arrow keys specifically, they should snap to cells in standard mode, the same way that they do now. However, if scroll lock is engaged, it should scroll smoothly by a consistent increment regardless of cell size.
Why would you not want smooth scrolling (no snapping) all the time?
I hate when the sheets snap regardless of cell size
Richard Fisher commented
thank you for the response!!
in regards to question 1, I entered "Scroll one at a time if the cells are not too big, otherwise scroll smoothly". In this case, I would define "too big" not to be the whole width/length of the screen, but an arbitrary amount, say ~25.00/141.00 (282px). This way, generally things work as they do now and most of the time cells are snapped to, but in the case of cells which are stretched around 3 cells wide or larger do not result in large jumps in the document which is jarring to the user.
@Futski, Yes, you can do this, but it affects everything in Windows. I feel like there should be a Windows default that individual applications can then override. A good start would be Excel. Personally, I override the default in Excel by using AutoHotkey, but it's a less than ideal solution.
@Anonymous, You can already set how many rows to scroll per scroll tick. This is actually a Windows system setting.
1) Settings / Devices / Mouse
2) Roll Mouse Wheel = Multiple Lines at a time
3) Adjust the Choose how many lines to scroll slider
I don't ever see a good reason for snap scrolling. But that's the beautiful part of choices. If it becomes a choice, it's the best of both worlds. Before the Excel UI was rewritten, I never had a problem. Granted, that was almost 10 years ago now, but hey, I've just cursed it every time I've had to use it since.
I like that it scrolls by a number of rows at a time and dropping to one at a time would be infuriating (unless there was an option to define number of rows per scroll tick). The issue is when a cell is more than say 40% of the screen it needs to define 'snap' breaks part way through it. E.g. maybe a 'snap'break is either a cell, or 20% screen width/height.
Scott Dabroski commented
For those of you answering the survey, I'd like to put a plug in for a toggle between "smooth scrolling" and "snap scrolling". It feels like the best of both worlds, because depending on the specific spreadsheet you might need one or the other.
small startup with 3 employee is 40times faster in suggestions/feedbacks than Microsoft.
5 year. FIVE!!!
you post 1 request, in 1-2 weeks or sometimes 1-2 day, and IMPLEMENTED.
Microsoft = unuserfriendly, slow. freezed in 1990. helo it is 2020!!!!!!!!!!!!!!!
I for one wasn’t expecting it anymore ! What a surprise !
Great news! However, after 5 years of waiting, I will believe it when I see it. Perhaps, this feature can be added to the MS Office roadmap so that it's brings more visibility? https://www.microsoft.com/en-us/microsoft-365/roadmap?filters=