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)
Seriously... SERIOUSLY... How many more years will you ignore making this fix? Why do you enjoy torturing your users? As if working with spreadsheets day in and day out isn't bad enough, you have to make it so user unfriendly there's piles of torn out hair in my cubicle.
Seriously, implementing smooth scrolling is not that hard considering everything else Excel has in it.
If you're really obsessed with cell scrolling and don't want to give in to smooth scroll, then at least add the feature and hide it deep within the settings so only those who really seek it out can find it.
But note: smooth scroll should be the default scroll method in Excel as it is more user friendly than cell scrolling. Think about your users Microsoft, it's not what we want, it's what we *need*. User friendliness comes first, and that's that.
The way I got it to work is:
Zoom way out (Hold ctrl button and mouse scroll). With very small cells, I could then double click the cell lines (bottom for rows, or left for columns), which resized it correctly, for me.
Before doing this, I couldn't get to the row bottom lines on some of the rows to shrink them up.
Without being facetious or malicious all i can say is that this has cost me hours to weeks of productivity as well ss eyestrain , mistakes. And embarassment during presentations. It's not a joke and indicates microsoft does not really care about customer satisfaction as long as you have a captive an paying customer base. You took great pains to change the search function in outlook to something that is nearly useless while ignoring pleas for years for a simple fix that everyone is begging for. How can your UAT team stand behind your testing regimen and approval process for general release. We dont need upvotes we need action with firm and committed dates. I would gladly accept the risk of beta software to get my hands on the endpoint software you say you already have running in your dogfood codebsse.
Daniel Lindsey commented
It was once just a small bug, but we ignored it, and now it’s coronavirus.
I got a headache commented
HACK THE EXCEL TEAM!!!
Just fix it!
Kishonthy Márton commented
It's disgraceful that it hasn't been done already.
First comment from 2015 after 4 generations of this issue:
Anonymous commented · July 20, 2015 01:06 · Flag as inappropriate
For pure ease of usability, Excel needs to return smooth scrolling. The mouse wheel and page down/up buttons both skip 5 line at a time with no easy way to disable. The granularity between starting to scroll and zooming past pages with the middle mouse is so small to be wholly unusable.
Its been like 4 generations without it, it needs to come back.
Accepting Votes started February 16, 2018.
Over 3050 votes and 816 comments later... nothing!!!
Seriously? You have been "taking notice" since Feb 16th, 2018 and you still haven't added an option to allow smooth scrolling. Mac users have it. I've seen comments that this is a function of how the OS works, not Excel. It still sucks whatever program you blame. That reason just reinforces why I should move from Microsoft products as a general rule. Since you have been "taking notice" since early 2018 and it's still not fixed, I take it that Microsoft thinks that this isn't a problem for it's users and has no plans to fix it. I find that Microsoft's general crappy validation of their products and upgrades is starting to hit an all time low. Shame.
Some day we will tell our grandkids of how we tirelessly battled the ferocious cell snapping dragon, awaiting King Patterson to hear the cries of his people and send the knights of code to deliver the fatal strike.
looks like developer was underpaid so developer skipped this functionality. then developer left and now no one knows how to do it.
this has been going on way too long. please fix asap. it's maddening!
Johnmichael Monteith commented
Please get this bug fixed. This is maddening and impossible to explain to new users when they get a cell that is too wide in Excel.
From 2015 to 2018 to 2020, still doesn't change???
@anonymous, sarcasm is definitely your strong suit.
My bet is now that Eric is the Principal Program Manager, ALL useful and needed suggestions, be it Excel or otherwise, will wither away in the depth's of despair, never to see the light of day.
I'd say this is a big loss for all of us, but you can't lose something you never really had. Our loss just got deeper and darker.
Don't be quick to slam Eric Patterson as he is playing the long game in getting the snap-to-cell toggle put into Excel. Now that he is Principal Program Manager, he has complete power to finally let the development teams hear our cries and act positively on them. This is a big win for us!
Because of great work that Eric Patterson has done (Accepting Votes!), he is now promoted to Principal Program Manager since Mar 2020!
Here is his LinkedIn page:
Well done Eric for the great work you have done for the community including this one! (slow clap)
Els Deman commented
I was very hopeful when I got notified of a bunch of new messages in this thread.
Seems it is not resolved yet.
I want to reiterate how much I would like a solution for this! Everyday it affects my work.