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

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?

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

"JarrodP" wrote:

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?

How to deselect individual cells after selecting them with CTL
 

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

"Rowan" wrote:

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

"JarrodP" wrote:

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?