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]
Ao movimentar a barra de rolagem em células que possuem grande volume de dados, ou celular que possuem uma altura acima do normal, ao movimentar a barra de rolagem um pouco para baixo, ela se encaixa na altura da célula de baixo, dificultando muito a visualização de parte do conteúdo que estava na célula anterior, além de dificultar a visualização do conteúdo, uma vez que a mudança é brusca, dependendo da altura das células.
And just to clarify- I have checked my mouse settings. This seems to be due to having large cells, not the mouse.
Hello, I want to add that I also find this very annoying in Office 365. I am working with cells that have large amounts of text, and when I try to count the cells I scroll down my sheet as I go. However, the boxes quickly jump up and away from view, which confuses me and I lose count because I am not sure if I just missed a cell or what. If you could make the scrolling a little more gradual with larger cells it would mitigate this problem completely.
Currently when I using a mouse wheel to scroll down any excel charts, the page scrolls down in leaps instead of tiny increments. Changing the scrolling to progress down the page in tinier increments will provide users a much smoother experience. The current scrolling is problematic, because when scrolling through large cells the page appears to 'jump' down or up very quickly and it is hard to keep track of whether you have missed a cell. It is not possible to smoothly scroll from the top of an excel sheet to the bottom because it is so jumpy. This also makes it impossible to do visual cell-counts, because as the user is counting the cells are jumping past them. It is very annoying.
John Nguyen commented
Allow us to use the "Panning Hand" function in Excel. It can be found across the rest of the Microsoft Office suite, but is missing in Excel.
Currently, if we have tall rows, when scrolling it will jump very quickly. I would like to use Panning Hand to move around similar to the way the scroll bar moves (which is by pixel instead of cell)
This shouldn't be hard to implement since Excel is already touch-ready as well.
David McDivitt commented
I found this page when looking for "excel column scrolling". By reading I see there is presently no way to turn off snap functionality, but such will be added soon. The snap feature is a severe nuisance. Please provide an option to disable as soon as possible! Thanks
Rob Dowson commented
Yes please - this has always been horribly annoying! Please fix this on Excel 2016 for Windows as soon as possible!
Craig Ford commented
When scrolling, having a spreadsheet snap to a cell/row/column can make it difficult to keep track of where you are and what you're looking at on screen (usually when cells are rather large, but that's not the only case). Please add the option to disable this snapping feature.
Kenneth Barber commented
Also, the jumping of multiple lines at a time when using the scroll wheel is due to your mouse setting, not Excel. Go to Control Panel, Mouse, Wheel tab and change the settings there.
Currently, if I have a cell that has a very large height and am trying to scroll via mouse or even via scrollbar (clicking on "<-" "->" pointers) - Excel just jumps below to the next cell, hiding even the bottom content of the needed large cell. The only way around this is to press the middle button on the mouse or to use the scroll bar. With an option to enable smooth scrolling (precisely what pressing the middle button on the mouse does), it would vastly improve navigation and viewability of excel worksheets
Oz du Soleil commented
YES! This is great news.
Dan, this is Good news, thanks for the update!
Matt Evans commented
I use excel to analyze rows of diagnostic data that can be 40 or more columns wide. Each column could be something like a URI that could be quite long.
I often need to look at the ending of a long URI column's values, next to some other column. Column edge snap when scrolling makes this horribly difficult.
Dan Battagin [MS XL] commented
I totally agree with this feedback. While not a perfect workaround for all cases, we already have behavior where we don't snap to row/column boundaries in several Excel endpoints today:
* Excel Online
* Excel Mobile (for Windows)
* Excel for Android
We're also removing the snapping behavior in Mac Excel in the next month or so.
Excel for Windows is a bit further out - the plan right now is to remove the snapping in about a year, but it is in our longer term roadmap (at least currently).
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.