Unselecting cells when using Ctrl to select multiple cells
When using Ctrl to select multiple cells, we can't unselect a cell when it was misclicked. Instead, we have to click these cells all over again. Please allow us to unselect cells!
Anonymous
shared this idea
We have completed the work and it is now available in our Insiders builds and will roll into production soon for our Office 365 users on PC and mac.
Also, see:
https://support.office.com/en-us/article/Deselect-a-selection-d1b56f30-7d63-4a64-8f0b-da4958204b52
16 comments
-
Andrew
commented
Should this also be supported in the name box? At least if the range is completely within selection? Currently it seems like its still additive. i.e. type a range in the name box and press ctrl+enter (or be in 'Add or Remove Selection' mode and just press enter)
-
Fernando Fernandes commented
YEEEEEESSSSSSSSSSSSSSSS !!!!!!!!! Just saw this behavior implemented, its out there !
-
Shannon Patrick
commented
I'm laughably excited about this change.
-
Ed Hansberry
commented
After using this for a few weeks in Insider, it works great. Have seen no issues or ill side effects.
-
David Spake
commented
Hooray -
-
Caleb
commented
great! thank you!
-
J@
commented
I am happy to learn this has been addressed; I miss-click frequently and this has long been one of the thousand paper cuts that killed my will to work productively with Excel.
-
Ed Hansberry
commented
According to https://support.office.com/en-us/article/Update-history-for-Office-Insider-for-Windows-desktop-64bbb317-972a-4933-8b82-cc866f0b067c?ui=en-US&rs=en-US&ad=US this has been added to the Insider build. Just waiting for it to download.
-
Ron Pineo
commented
I run into this a lot and have had to reduce my ctrl click so as to avoid having to redo the list if I misclick one. Thanks.
-
Corey Becker
commented
This is a no brainer. I think just about everyone has run into this issue at some point.
-
ozjos commented
Definitely, this is so painful! And with objects too please.
-
Alex
commented
some things shouldn't be prioritized by votes but by common sense.... come on! get it fixed!
-
Doug Glancy
commented
I wrote a post about this with something of a solution: http://yoursumbuddy.com/undo-selections-selectracker/
-
Stephen Eddleston-McGrath
commented
Yes. This is fine normally, but when you have worked your way down a massive list and just get one little slip the other side of a cell border, it can render the whole operation (usually a paste) useless or destructive. This would be a very welcome addition. I also feel your pain.
-
Kenneth Barber commented
I feel your pain, bro.
-
Gareth Hayter
commented
Does the 'Easy Select' button in FormulaDesk work as you'd like? If os, maybe this feature should be used by the Excel team as inspiration! When you turn the 'Easy Select' button 'on', then you don't need to hold down CTRL while you select multiple cells, and you can also deselect cells by clicking them. http://www.formuladesk.com