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.
Oz du Soleil
shared this idea
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]
984 comments
-
Richard Moore commented
Wasted another hour trying to work out whether Microsoft had implemented this yet.
Do people at Microsoft ever do any work? All your products are rotting!
Visual Studio is a buggy mess, and you guys can't even do a simple mod to Excel in under about 10 years.
Seriously, for the most valuable company in the World, you really ought to spend a bit of your profit on maintaining your products.
-
Anonymous
commented
Richard Chien: impossible? it is not impossible you code-idiot!
-
Anonymous
commented
Smooth as butter on a hot griddle.
I've got my mouse button setup so I can switch between smooth and cell scrolling...
-
Mark Gibb
commented
Smartsheet sounds cool, but can it do smooth scrolling? 🙂
-
Anonymous
commented
Microsoft has been satisfied with their level of product for too long. I'm switching over to Smartsheet, and I didn't realize how limited MS was in their discrete approach to things. Smartsheet has everything functionally integrated, and is organized more like a database than excel, functionally. Which means your data gets stored how it's best organized, not how it best looks, then you make it look good by changing the view from grid to tiles, to whatever, or you can create a form instantly to populate the data. Smartsheet becomes a part of your process with all the automated workflows, rather than a parallel organizational and tracking tool like MS that dies if you don't feed it. MS, you're done. Too little too late.
Oh, and a bonus for you timing study engineers, you can break your tasks down to the nanosecond units, so you can actually use the Gantt tool to do a proper timing study with functional relationships. I don't know any other tool out there that can do that, and I've looked. Project, no. Clarizen, no....
-
uk d
commented
I do not understand how it is possible that this option is still missing today. Browsing excel tables is a nightmare, therefore, even if the row are not larger than the screen size, each jump means that I do not know "where I was" and I have to look for the place I was tracking every time. aaagrrrr.
-
G A
commented
Futski " I'm keeping my fingers crossed."
Cause you are cheap. sorry. sheep. be e e ee e
-
G A
commented
Futski "MS actually is working"
Working? 5.5 year.....
WOW!!!!
What a speed.
What a tempo.N O T H I N G ___ A F T E R 5.5 Y E A R. YEAR!!! Not day. or hours.... Y E A R!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Like AMATEURS.
F_CK MS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! -
G A
commented
Futski:
You are wrong in THIS context, in fact.
YOU >>>YOUR LEFT OR RIGHT HAND >>> Mouse >>> PC >>> WINDOWS 10 >>> EXCEL.
You CAN do this setting. But it IS DETERMINED by EXCEL.
CONCLUSION:
>>>>>>>>
"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."
-
Futski
commented
@G A - Scrolling is, in fact, partially controlled by Windows itself.
1) Settings / Devices / Mouse
2) Roll Mouse Wheel = Multiple Lines at a time
3) Adjust the Choose how many lines to scroll sliderPlease don't misunderstand me, I'm not saying that this is the way it should be done. I'm simply stating that this is the way it IS being done.
That being said, most other applications (browsers for example) ignore the windows settings. And Excel certainly should too. As a side note, a little birdie told me that MS actually is working on smooth scrolling. I would expect that de-coupling the scrolling from core windows is probably a major undertaking, so it might take a while to complete. I'm keeping my fingers crossed.
You can always keep an eye the Beta channel release info here:
https://insider.office.com/en-us/releasenotes/windows/fast -
Tony
commented
I'll add my voice to get this done.
My case is where I embed images in cells and my requirement is that it scrolls smoothly over them as well. -
Ravn
commented
It took MS 5 years to make a plan - 21. september 2020
A god plan is half the job - so estimated it is solved in 2025 -
Dan
commented
is this sorted yet?
-
Malcolm
commented
Come on Microsoft, Excel shouldn't have any competing sheets with better functionality. Please make these simple adjustments an option at least.
-
Anonymous
commented
I guess that's why everyone's moving to SmartSheet for enterprise. We get ours this week. Didn't realize how much easier and more powerful it could be. Simple things like this. You snooze you lose.
-
Kuba
commented
6 years and you are happy to share that you are 'in the planning stages'. Planning stages would take another six years, then initial analysis, technical analysis, development and testing, technical preview, release candidates... Looks like 40 years of work. And there supposed to be cyberpunk in 2077. People would get smooth scrolling in excel instead. It's always something, thanks xD
-
Anonymous
commented
Please fix this - or allow an option to disable it... It makes it incredibly difficult to review large spreadsheets when the focus keeps jumping to the top of a cell. What the ****, we have no choice. It makes me crazy.
-
Winnipeg Gal
commented
Please fix this - or allow an option to disable it... It makes it incredibly difficult to review large spreadsheets when the focus keeps jumping to the top of a cell.
-
Futski
commented
Ryan,
I see that MS changed this to "Planned" status relatively recently. Hopefully it's in the works now, but I would expect that a change of this magnitude might take a while to get fixed because it probably goes directly to the core of Excels screen drawing engine.You can always monitor what's coming by watching the changes in the Beta Channel. Link here: https://insider.office.com/en-us/releasenotes/windows/fast/windows-beta-channel-release-notes
Side Note: Check out the new LAMDA function released to Beta Channel on Dec 4. I think there are a lot of people that will like that one. It's mentioned in the link above.
-
Ryan
commented
It just sucks when you're using large (or just long, in my case) cells, and you try to view a certain cell but it snaps to the edge of the next one over. Scrolling by pixel instead of by cell would be a great addition.
Thanks for your time,
Ryan