How to deselect individual cells after selecting them with CTL-Cli

[JarrodP]

I would like to know if it is possible to deselect 1 cell after selecting
many cells using the CTL-Click method. For example, you are indivdually
selecting cells in a worksheet and you accdidently select a cell you dont
need, how can you deselect that one cell without deselecting all of them and
starting over again?

 

[Rowan]

This is not a standard Excel option but Chip Pearson has some macros to do
this:

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

Your best bet would be to add these to your Personal Macro workbook so that
they are available to all open workbooks in Excel.

Hope this helps
Rowan

 

[gtabmx]

Hahaha, it kills me that Excel doesn't allow the deselection of cells.
Incredible. Its like a town car that cannot drive in reverse.