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]
any fix yet?
Craig Ratchford commented
Wow. There is seriously no solution to this?????????? That's a bit unbelievable as this annoys about everyone I work with. Many people end up using Excel for some sort of log or project management with long/wide cells at some point, and this get incredible cumbersome.
@Excel Team ........ Wow! You need votes for such a big issue? Do Excel developers really work on Big data in excel?
Paul Hanson commented
This is just sad that such a simple thing that used to be under the view section of the tab in a previous version would be removed that adds nothing but pain to the end users. The fact that this was a setting option in a previous version and was taken out is just a sign that Microsoft does not have a quality testing process. No one that uses the program would, if asked, say please do not give me the functionality to make the sheet viewable in the standard way that every other office product can be viewed.
Oy, I'm surprised to find this. I expected this to be a simple setting in Excel to fix, but wow... there's really no setting/fix for this?
I honestly can't believe this is an issue in 2017. I always dealt with it, and finally today decided to figure out how to do it... only to realize it's not possible?! doubly surprising that Google Sheets also doesn't have this functionality, nor does Open Office Calc. Most people have real-world data that requires long text labels, not just matrices of floating point numbers (though a float64 would make a pretty darn long column!)
Why is this *still* an issue when two admins have already acknowledged this problem over a year ago now, let alone it shouldn't have been an issue in the first place with "common-sense usability" in mind. Our office goes through editing hundreds of spreadsheets with large (tall) cells containing text and images often, and it is an absolutely frustrating experience to say the least. I wonder how many hundreds, if not thousands, of other people (aka paying customers), who don't know about this forum and/or don't want to post their email to vote/comment, are lost in this confusion too.
Please add my vote
:S How come this is not fixed based on common sense? Why even request votes from unsatisfied users on something that is so basic? vote provided, although I don't really believe that's going to make a difference since this topic was started in 2015 but hey, I'll bite..
Just adding my vote to the rest, it would be nice if there was an option in located in the Review tab of excel where you can turn off/on scrolling by cell. I work with some spreadsheets where I have a lot of text stored in cells and not being able to smoothly scroll through and having excel jump straight to the next cell below all of my text is really troublesome!
I hope this is something that can be fixed in the near future!
Philip Alexander Hassialis commented
Adding my voice for this feature. Currently running Office 2016 Professional and having to plow through dozens of workbooks which contain tall cells with text. Fixing and re-fixing and re-re-re-resizing row heights is tedious and gets tiresome fast.
Please resolve this.
Yes, I'm amazed and disappointed, and an unsatisfied customer, that something so basic as this is an issue. This is the maker of MS Word for goodness sake that scrolls fine and other software that scrolls fine. You are frustrating many many people. Fix this please. And you pun is not funny at all.
Richard Moore commented
This is a really horrible problem in Excel that could easily be fixed. C'mon Microsoft why not use your 30,000+ developers to give us a simple big fix - just this once?
Issue noticed on November 07, 2015, 195 votes, still no support for basic classic scroll like any other program does natively.
Currently excelerating the transition to another software.
Please Fix this! This continues to be an issue for everyone. Can't even understand why it was the way it was in the first place (Though I assume/hope there was a technical reason for it).
Cody Martelli commented
There are use cases where Excel makes sense for organising text in tables. For example, meeting minutes with attachments. The ability to use auto-filters to hide some items (by status, or assigned team) makes Excel quite powerful for this non-maths job. However the scroll limitation is a big pain.
this is really frustrating! I have files with really tall cells, and if i use my laptop screen i cannot see the bottom of the cell! I just hate the snap scroll feature!
Much longer than a year now Dan... Can someone provide an update? It's pretty f$&king annoying!
Tom Spelling commented
This is HUGELY IRRITATING. Fixing it would be great!
Oz du Soleil commented
Ok, Dan, it's been a year. :)
I was dealing with this last week. Someone with massive amounts of text in a single cell, and Excel kept jumping.