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]
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.
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.
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
is this sorted yet?
Come on Microsoft, Excel shouldn't have any competing sheets with better functionality. Please make these simple adjustments an option at least.
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.
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
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.
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.
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,
I can confirm that it is NOT fixed for the current desktop version of Microsoft Excel Version 2012 Build 13530.20376, published on January 12, 2021 (part of Office 365).
Maybe Kevin can tell us the specific version he is using?
I am really angry that Microsoft has not fixed this for so long. It is really an annoyance!
This does not appear to be fixed in the Windows desktop version of Excel as of v2011:13426.20404 released on December 21, 2020. There is smooth scrolling on Mac and the web versions (which is also used in Teams on Windows which is really just a web page anyway).
I note from Kevin's comment below that this is fixed. If so, can you advise me if there is a need to change any settings within the Excel Desktop application because I still have this problem.
This feature has been available on the 365 web version for sometime but I've yet to get the same feature on my desktop version, which is up to date.
I think this is fixed. Thank you!!!
Cara Gilmore commented
Please soon! this is so annoying!
You don't yet have a target date????? The code can't be that complicated!!!!!
I'm gonna play devils advocate here and say that Snap to Cell was likely a design decision many, many, many, many years ago. Probably going all the way back to the initial design of Excel. I don't remember, but 10 to 1 odds that DOS era Lotus 1-2-3 was also Snap to Cell. That goes back to a time when large text cells was not supported. You could put text in the cells, but as I remember there was a size limit, 256 characters comes to mind. So large cell scrolling was never a consideration back then, and neither was word wrapping. This meant a row was a only one line high. So no need for smooth scrolling. And to top it off, the computers back then weren't powerful enought to provide a good experience with smooth scrolling.
Fast forward several decades, and MS never bothered to update their design to include smooth scrolling with Large cells. But it's time for this to happen because spreadsheets have become so much more than they used to be in the old days. The started as number crunchers, plain and simple. But today, some people even use them as word processors, who knows why, by they do.
MS, we understand the long history of Snap to Cell. But it's time for a change to happen. Sooner than later please.
Side note, Does anyone else remember Lucid 3-D spreadsheet? It's was very revolutionary for it's time. I created some really nice stuff using it, stuff Lotus couldn't do. I guess I'm dating myself, huh...
Considering that this has been an issue since at least 2007, and that it does work with middle mouse button, I can't say I'm impressed.The "planning" stage should have been a decision to enable this behavior in the settings more than ten years ago. This really just shows how long and slow the corporate decision making process is.
@Futski - Yeah... at least this issue is probably simpler in Excel desktop apps (just use/toggle the appropriate OS UI stuff), since this isn't an issue (scroll wheel vs ctrl+scroll wheel) in most other Windows apps... I have no idea how this is done on Macs.
With Web apps like Sheets, there's all the UI interactions with different web browsers on the presentation side (IE5???) vs the HTML presentation stuff.