Deselect one of many non-adjacent rows selected

[Guest]

If you are going through a worksheet and selecting several rows to, for
example, delete them and you accidentally select a row you didn't mean to, is
there a way to deselect just that one row? I noticed that CTRL clicking on
the row again does not do the trick.

Thanks!!

 

[Gord Dibben]

Nicolle

Very annoying feature.

You can add a couple of Chip Pearson macros to your Personal.xls that will
allow the unchecking of a mistake.

Assign to a button or to the right-click menu. See this thread for the macros
and instructions for adding an item to the right-click menu.

http://snipurl.com/bxoj


Gord Dibben Excel MVP