Multiple cells selection problem
We select multiple cells by holding control key. But when we accidentally select a cell without holding control key, all selected cells are gone and we have to do the selection again. This is very irritating. Please add option for the same.
Vikrant Rangdal
shared this idea
2 comments
-
AdamV
commented
If you find you do this quite often, then change your selction mode instead of using Ctrl as a modifier.
Press Shift+F8. Status bar at bottom left will show "Add to selection". Click on all the cells you want, without the need for Ctrl.
Use Shift+F8 again, or Esc, to get out of this mode.See also: F8 = Extend selection - select start cell, F8, select end cell of range (equivalent to Shift+click).
Both are essential to know for people with impaired hand control or movement who cannot reliably press a key and click the mouse at the same time. If I had my left hand in a sling, I would need to use these, for example.
-
Michael Daughety
commented
Just click on the cell you accidentally clicked, again and it will deselect. Stumbled across this recently and now use it all the time.