This is a frequent problem which to now Excel has not addressed.
You cannot, without code, de-select a cell once selected using the CTRL and
point method.
Chip Pearson has code available at his site.
http://www.cpearson.com/excel/unselect.htm
Gord Dibben MS Excel MVP
On Tue, 28 Nov 2006 20:14:00 -0800, SJT wrote:
I am using the Ctrl key to select non-contiguous cells to paste to. Can I
deselect a cell that I mistakenly chose and still keep the other cells as
part of the paste region. Thanks for your assistance.