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.
Thanks everyone for all of the passion about this suggestion! The number of votes has increased greatly in the last couple months and we’re taking notice! We’ve got a bunch of other Excel endpoints behaving this way already and we’re evaluating getting it done in the Windows versions sooner based on the number of votes it gets – so keep the votes coming!
Eric Patterson (Program Manager – MSFT)
Paula Spirawk commented
I feel like I want to send MS all the huge excel docs that I have to deal with that this feature affects and see how efficient they are - seriously flood them. SO annoying. zooming out to 20% - MS you owe me money for migraine medication and glasses.
Just upgraded to Office 2019. I truly can't believe how bad the scrolling is now in Excel -- on the very same files I used for years with Excel 2010! Saved the file to the 2019 version of Excel -- no improvement. :( :( :( Somebody is truly got to be kidding!! This is a Major Degradation of Excel!! So Sad. Microsoft, truly you can do better. Time to go Apple. So Sad.
MSCRM exports lots of things into Excel formats (what with it being a Microsoft product) and this can include fields that contain a bunch of text. Seems that it shouldn't be that difficult to at least give an option to turn off (or on) cell-based snapping when every other program that runs in Windows tends to scroll smoothly.
Lack of smooth scrolling also makes improvements/innovations like cells that can be larger then their row/column's settings possible.
Consider being able to have a cell taller, or reaching farther down than its rowmates. This could be winked at by letting cell contents "spill" in the new terminology ('cause "run over the cell edge" doesn't sound pretty enough) downwards until hitting a cell border for a cell with contents, much like text contents can run past the right border presently. Fully in place, not just "buzzing the tower" implemented, one could maintain the religious basis of Excel with identically sized cells in each row/column, yet allow for improved display.
Personally, I'd like the option to let those cells overlay anything I tell them too, hiding those contents with their own contents. Several things I could do with that.
Anyway, nothing of the kind can ever be possible if those cells cannot be read because nearby cell-sizing causes portions of them to always be off-screen, up/down/right/left, some portion always off-screen.
And cell's displayed in the current herky-jerky manner would do precisely that. So things of this kind, wished for elsewhere and not even thought of as related are in fact very related.
Of course, either way, Distributed Indent still has a bug that lets you lay its contents overtop neighboring cells. Can't take that away apparently, no smooth-scrolling or not no smooth-scrolling. Wise choice MS, wise choice...
Joe Fry commented
@Marj - This isn't a solution at all.
1. it doesn't do anything about column width (though I suppose you could do the same thing there)
2. it only works if you merge rows in the other columns, or column A just grows to match.
Smooth scrolling should not be that difficult to implement.
John Lipinski commented
Give no quarter to Microsoft; workarounds only give them more reasons to create excuses not to address this. The demands of the users must be heard.
That, and I imagine that would create some issues with formulas.
If this is a repeat suggestion, sorry. Leave Column A alone, with "normal" sized cells. You can hide this column if you don't want to see it. Put all your contents in the remaining columns as you normally would and merge the content over several rows. Since column A is normal sized, you will get "smooth scrolling".
My wife gave birth at home last week, unintentionally. The baby just came so quickly we didn't have time to go anywhere. But everything's okay, the baby came smoothly. That's more than can be said of other things around here.
What are you guys waiting for???
Everyone post a link to this UserVoice in a new conversation topic on the Microsoft Tech Community Excel forum! I think this is our last hope of getting some visibility from an admin.
632 including mine.... ok how about the ppls votes and comments made a decade ago who have probably now switched to MAC.... just update it already. Smooth scrolling for everyone.
Mark Gibb commented
Smooth scrolling yes please
Jumping around makes eye strain
I know it's hopeless
Found this in some VBA...
Smooth scrolling could save lives MS
Doesn't MS think this is a problem?
Sam Hilton commented
This feature would be 1 of my 3 wishes
Mark Gibb commented
My life degraded
Work requires using Excel
No escape for me
Stefan Nueesch commented
Do it. Do it NAO!
Do it. Do it NAO!
I liked the Dune reference.
and how can this be?
My blood runs cold. No!
The madman can't be correct.
Libre....oh................ Oh, no.