unselect cells

[tgi]

by holding CTRL key you can select multiple individual, i want to know if
there is a way to unselect cells in similar fashion?
assume that i wanted to select 20 different cells in the sheet, i would do
that using CTRL, but by accident if i select a wrong cell in between i would
have to start it all over again

Thanks in advance!

 

[FSt1]

hi
unfortunately, no. but the problem has a vb fix. see this site.
http://www.cpearson.com/excel/UnSelect.aspx

regards
FSt1

 

[Dave Peterson]

Nothing built into excel.

But you can use a macro--like the one Chip Pearson shares:
http://www.cpearson.com/Excel/UnSelect.aspx

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)