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]
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=
I got a headache commented
Look above the title of this topic. There's a small blue link for "Excel for Windows (Desktop Application)". Go there and you get a couple sorting options, like "Top", "New" etc. Sorting by Status gives you a good idea of what we're up against, historically.
I'm not holding my breath, although it is slightly comforting to know that somebody at MS actually looks at these threads every 2.5 years or so.
Does anyone know if there is a way to sort these threads at uservoice.com by number of votes? I would love see if there are other Excel-related suggestion threads with as many or more votes than this one.
This is a glorious day. Thank you to everyone who has kept this thread alive over the years.