Deselect one of many non-adjacent rows selected
 

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!!

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



On Tue, 11 Jan 2005 06:51:09 -0800, "Nicolle K."
wrote:

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!!