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)
@Anonymous (2018-03-23 3:48 PM): Yes, you can contact the **Excel Social Team** on Facebook (@microsoftexcel) and Twitter (@msexcel) - at least they seem to care and forward things to the developers.
William Fazakerly commented
The biggest bug here is that we cannot keep Microsoft from "upgrading" our OS and applications. Every year they 1) change the user interface; 2) introduce new bugs; and 3) don't fix old bugs. If they would just keep their "upgrades" in Redmond, WA, I would still be running Excel 2007 and scrolling right along just fine.
Do you guys realize that this forum is merely designed as an outlet to your frustration rather than a well-intended portal to make use of real user feedback to improve their application?
What did Microsoft do after getting the 1st feedback about this problem on 16 Sep 2015(that's more than 2yrs ago!!)
Are you angry or are you not angry with the issue? Pls make up your mind.
If you're angry(like me. Because I'm truly affected), pls give suggestions on how to escalate this problem beyond this forum. Can we reach out to someone, some social media? Because they did NOTHING for more than 2yrs!!
To get this thing fixed, you must fight for it.
" the ribbon interface which many users still hate "
I am one of those users!
I find it more frustrating than the scrolling issue tbh.
Mike Tamlyn commented
I don't think this is the type of issue where one can really justify storming off to another solution in total frustration. Excel is a great piece of software. Seriously, look it up, Excel is one of the bright spots in Microsoft's murky history of software from a quality perspective.
IMO, this issue is instead a comically humiliating black spot on an otherwise fantastic achievement in software engineering. It's a "WTF were you thinking?" moment. They've added countless massively complex feature and haven't fixed this? They literally overhauled the UI/UX of Excel to be smooth, responsive, and animated, but they haven't addressed this?
So, our job is to continue to post here, share the issue on-line, and tell our friends and colleagues. Don't let MS frame Excel has a pinnacle in productivity software - make sure they know too many people are aware of these kinds of hilarious oversights.
The largest barrier to using Libre Office, in my opinion is the lack of support contracts and end users. Accounting for example, loves their spreadsheets as they have them working now and often use macros that would have to be re-written if an office suite changes.
That said, I hear that overseas, more governments and companies are making the switch to Libre Office. Maybe they're sick of Microsoft telling them how to run their operations with all the licensing nonsense, maybe it's the ribbon interface which many users still hate, maybe they need to start using the open document format, or maybe it's Microsoft not listening to end users (which is why we're here now).
What ever the case, Microsoft's stranglehold on the market for Office is slowly starting to get weaker which is probably why they launched this website.
Microsoft, if your listening, we do thank you for acknowledging this request. However, our patience grows thin. We know that you don't want to be known as the evil empire of software products that just do what ever Microsoft wants and to **** with what end users want. Please at least tell us that this minor change is in the works for the next release of Office. The ball is in your court to quell all the negative comments you've been getting in this thread alone.
Mr. Robot commented
@Garry Young: I can only think of Libre Office, which even has some compatibility with Excel's proprietary file formats. And it's free and open source software. But you obviously won't convince a company to switch :(
Garry Young commented
Dear Anonymous - that work around is NOT feasible when there are a number of other issues in the worksheet dictating formatting....
To clarify, I think the concern most of us have with MS' inaction on this issue is that the more highly voted concerns are indeed great ideas, but more difficult to implement. This issue does not seem to be a difficult fix...
to Gary Young, There is a reasonable work around for this bug. Make your rows smaller and merge cells when you need a lot of wrapped text or a large graphic. I want MS to fix this bug, but Lotus 123 is not available any longer.
Garry Young commented
So, I guess there are two questions that need to be asked:
1 - Does Microsoft have to care about our complaints? Basically, what can we do? Walk away from Excel? I think most of us are just stuck in the need to use Excel due to corporate licenses already purchased etc. There is no way I would be able to persuade my CEO to buy an alternative software option for over 1,000 workstations....
2 - But secondly, even if only an academic question - is there any alternative to Excel for a user in a commercial role (ie. not just home usage)? Even if costly, there may be a way to phase out the use of Microsoft products over time.
I realize this forum is not the place that Microsoft would like customers to be discussing alternatives to their products, but **** - I don't think they care about our needs at all anyway.
So please chime in here - what alternatives do you use? And how good/bad are they compared to Excel?
Peter Griffin commented
Come on, MS, do something about this!!!
(And people, please keep sharing this on social media!)
****, even it was buried in the options, at least it would be available and I wouldn't be thinking of punching my monitor every day.
Pentiki Mahougami commented
It truly cannot be that hard to add a button to the ribbon which toggles scrolling from "traditional" to "granular" or something similar. This is the same sort of behavior as snapping objects to grid in visio and that has a toggle-able behavior.
We can put this button on the view tab in the window group.
To Mark C ... I think the window is much cleaner visually if it stays exactly where I put it - seeing one half of a row at the top is cleaner visually because it tells me that I am looking at what I want to see. I don't care if the row is 0.5 pixels high - I DO NOT EVER want Excel to snap to the top or bottom of a row. If I am not moving my finger or rolling the mouse wheel, I don't want my view port to move. Set up a row that is 50 pixels high and scroll to approximately half way through on the top row - you can see Excel churning to decide whether to snap to the top or bottom. Not only is this UI behavior stupid, it is wasting CPU cycles.
Ah, I missed that Mark, haha.
Smooth scrolling is preferable I agree, hence I signed here.
You should note that word can be used in 'Web Layout' view to get around the page size issue.
However, Word as an alternative wasn't really a serious suggestion hence the winky face. ;-)
Sorry, but those are workarounds. Not a solution. The only acceptable workaround I see for your arguments is a toggle option to scroll by cell or by pixel. Smooth scrolling by pixel HAS to be an option no matter what.
And Word is not an acceptable platform whatsoever. For large data, you can't be confined to a working area the size of a sheet of paper.
I also want this... but, to be fair, excel is a victim of its own success here.
It was originally, and still is, designed as a spreadsheet for numbers and limited text. In these cases snapping to a row edge is great, it makes the window much cleaner visually.
We all use Excel for text tables / reports / forms etc... because operating in Word is so much more miserable.
If you use excel for this type of work a lot, you could change the number of lines your mouse wheel scrolls in your mouse settings . Change it from 5, or 3, or whatever, to 1. Obviously not ideal as it affects all programs...
However, as a quicker fix option for the Excel team, perhaps Excel could scroll by 1 row if the selected row height is greater than the scroll wheel setting...?
Or, make a different Enter option (e.g. Shift+Enter), which just writes to that cell without indexing to the next cell down.
Or make word better so it can be used for tables with equations and conditional formatting etc... ;-)
Well, if MS could provide a more direct escalation route, I'd be willing to listen.
Anybody got any suggestion to escalate this thing to the next level? Any suggestions is welcome. WE NEED TO ESCALATE THIS!!
And Microsoft team, I'm not talking to you. I'm talking to ALL the AFFECTED USERS!!