Allow us to disable "double click to move"
Double-clicking to move to the beginning or end of the cells is useful for some, but for others it drags our productivity down. Please allow us to toggle the option to navigate using double-click so the users who are adversely affected by it can turn it off.
This feature is annoying and i keep triggering it 30 times a day and having to scroll all the way up again. Please add option to disable this.
If MS are not going to do anything about it then maybe we should write a tiny program to run in background and monitor the mouse icon. It changes to a cross in this situation. So might be able to intercept and block all API dbl clicks in this icon state. I'm not sure what else it might upset but at least we could have a toggle or something.
Disappointed User commented
I wonder if this should just be renamed from Excel "UserVoice" to Excel "UserVoid" as it seriously doesn't look as if MS cares the least... Between this and other reports, this "feature" has been going on for at least a decade now, with no planned fix... Unfortunately for us, we can't "vote" with our wallets as despite this annoying thing and me using Excel almost every single day, there simply is no other program I can go to instead, and thus every year I renew my Office 365 sub... :(
Please remove this feature. It's terrible when using big spreadsheets, because it makes you lose your place.
I seriously can't believe that this feature is coupled with auto-full. For the love of all things productive, decouple these options and give your users a choice. It truly is a no-brainer when everyone can be happy by just adding an option for both.
Thanks to all the comments here I have just learnt a new useful feature.
However, I support the general principle to make things optional wherever possible.
David Ashworth commented
I AGREE WITH ALL COMMENTS! I have probably wasted a sum total of 10+ minutes, just this morning trying to find where I was when I unintentionally double-clicked the edge of the cell I was trying to edit. Please allow us to disable this feature. Thanks
I deal with large spreadsheets regularly. I can't express how sad it makes me to not be able to turn off "dbl click to move" without disabling one of my most used features (drag to fill).
It's already tough to keep your bearings straight if you're looking at a thousand full cells but trying to get back to where you were after loosing place is horrible.
[Deleted User] commented
The fact that the double click to move is combined with drag to fill easily makes it the worst feature in Excel.
Please split it into two options. :(
Guillaume Briand commented
This is the most annoying thing ever...
This feature is terrible. I want drag and drop but I do NOT want to jump to the end of the list if I double click a cell to edit it. Microsoft Are you listening?
YES! Mine actually copies the cell contents all the way down through the column, overwriting existing data. I've lost data and ruined files unwittingly with this "feature" when I was trying to edit contents of a cell. What a stupid thing to enable, generally, and especially to not be able to turn off without turning off the cell formula drag capability altogether.
John Evans commented
This is the most annoying thing about Excel. I'm seriously thinking of switching the office to Apple in order to get away form this stupidity.
Dave Greene commented
Yes, please -- this is a feature that badly needs to be turned off by default. I would have voted sooner, but it's difficult to figure out at first what Excel's infuriating Jump Randomly To The Bottom Of The Spreadsheet behavior is called, or where to vote against it. The first few dozen times I triggered it, it seemed much more like flaky irreproducible behavior than a deliberate feature.
For the love of god, please kill this "feature". In over a decade of power-use of Excel, I've never used it. I don't know anyone who uses it. Other shortcuts are available. The interruption is incredibly aggravating. And turning off auto-fill in order to stop this behavior is absolutely not an option. Please, please kill it.
Fernando Madruga commented
This is such an annoying "un-feature", can't believe it will be THAT hard to fix?! I use the drag and fill handles, so disabling that to get rid of this constant needless jumping around is, like someone said below, like cutting your legs so you don't have to buy shoes...
It's so frustrating when you try to double-click a cell to enter something in the middle of a huge spreadsheet only to realize you've double-clicked on or too close to the border and *boom* there you go out of your place into one of the edges... SO enfuriating and pointless this is!
Christian Ickes commented
This has been my least favorite bug in Excel for over 10 years. Every time a new versions comes out the first thing I check is did they fix the scroll to end of list bug and every time the answer has been no. Often I work with ling lists of data and I have to insert blank lines to limit the damage this bug can do, then I have to remove the blank lines when I am done. Please, Please, Please fix this so I can stop wasting my time trying to find my place after getting control stolen after my double click is a few mm off. Please fix this.
Jay Hash commented
This would literally take you 5 minutes to fix and push out in an update. I know you don't think it's "important", but no one asked for this feature and whatever Excel Dev who thought this would be a good idea really needs to make it optional rather than mandatory. I'm seeing forum posts about this as far back as a year ago. This should not take that long to fix or make an optional "feature". Fix your software.
Disabling drag-to-fill just to disable this worthless scroll function is like cutting off your legs at the knee. You won't need to buy shoes anymore (something you don't do very often) but now you can't WALK (something you do ALL THE TIME).
PLEASE separate these two functions - I WANT drag to fill but I DO NOT WANT double-click cell border to scroll!
Microsoft please allow users to control the action triggered by double-click.
The least useful option is to jump to the end of the column and it should not be the default.
Repeatedly losing my place because I'm out of position by a pixel or two is a gross annoyance.
Somehow I've never been hit by this before, but the last couple of days have been very irritating because of this "feature" that can't be disabled.