Cancelling Cell Selection using ctrl + click

[Robin R]

"You cannot cancel the selection of a cell or range of cells in a nonadjacent
selection without canceling the entire selection."

Whose brilliant idea was this? I used to be able to check sums by selecting
or deselecting cells. This new wrinkle makes life much harder. Is there a
way around it?

 

[Chip Pearson]

This new wrinkle makes life much harder.

The inability to "unselect" a cell is not a new wrinkle. It has always been
that way. See www.cpearson.com/Excel/Unselect.htm for code to allow you to
unselect a cell or area while leaving the other cells selected. I assign
the code to my right-click menu which makes it very convenient.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[Gord Dibben]

To the best of my knowledge you have never been able to de-select as you state
in any version of Excel and is not a "new wrinkle".

Perhaps you had a macro to de-select cells when using CTRL + click?

Chip Pearson has code to allow the de-selection of a cell or range of cells.

http://www.cpearson.com/excel/unselect.htm


Gord Dibben MS Excel MVP

 

[Robin R]

I guess I was thinking about Windows Explorer where you CAN pull that off
without the assistance of a macro. I jumped up from Excel XP right up to
Excel 2007 and perhaps I was remembering incorrectly.

Thank you for the macro. I'll see how that works.