I can select non-contiguous cells by holding down the Ctrl key and clicking.
What if I select a cell that I later want to DE-SELECT? Is there a way to do
this. Clicking on the cell again while the Ctrl key is depressed does not
work. Thanks.

Can't be done!
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Kokomojo" wrote in message
...
I can select non-contiguous cells by holding down the Ctrl key and clicking.
What if I select a cell that I later want to DE-SELECT? Is there a way to
do
this. Clicking on the cell again while the Ctrl key is depressed does not
work. Thanks.

Can only be done through VBA.

See Chip Pearson's site for code.

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


Gord Dibben MS Excel MVP

On Mon, 5 Nov 2007 20:42:00 -0800, Kokomojo
wrote:

I can select non-contiguous cells by holding down the Ctrl key and clicking.
What if I select a cell that I later want to DE-SELECT? Is there a way to do
this. Clicking on the cell again while the Ctrl key is depressed does not
work. Thanks.