Hi everyone,
On an Excel worksheet, one can select multiple non contiguous cells with the
Shift an Ctrl keys. But is it possible to remove a selected cell from the
selection without having to redo the whole selection process?
Thanks.
--
Jac Tremblay

Hi Jac,

See Chip Pearson's suggesstions at:

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


---
Regards,
Norman



"Jac Tremblay" wrote in message
...
Hi everyone,
On an Excel worksheet, one can select multiple non contiguous cells with
the
Shift an Ctrl keys. But is it possible to remove a selected cell from the
selection without having to redo the whole selection process?
Thanks.
--
Jac Tremblay

Hi Norman,
That is a great and interesting answer and I thank you very much for it. But
does that mean that it is not possible to do that without VBA code?
In the Windows Explorer, when one clicks on a selected item, file or folder,
that item is deselected? Why is it not the same in Excel?
Thanks again
--
Jac Tremblay


"Norman Jones" wrote:

Hi Jac,

See Chip Pearson's suggesstions at:

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


---
Regards,
Norman



"Jac Tremblay" wrote in message
...
Hi everyone,
On an Excel worksheet, one can select multiple non contiguous cells with
the
Shift an Ctrl keys. But is it possible to remove a selected cell from the
selection without having to redo the whole selection process?
Thanks.
--
Jac Tremblay

Hi Jac,

I am not aware of any manual method for deselecting cells from a
non-contiguous selection.


---
Regards,
Norman



"Jac Tremblay" wrote in message
...
Hi Norman,
That is a great and interesting answer and I thank you very much for it.
But
does that mean that it is not possible to do that without VBA code?
In the Windows Explorer, when one clicks on a selected item, file or
folder,
that item is deselected? Why is it not the same in Excel?
Thanks again
--
Jac Tremblay


"Norman Jones" wrote:

Hi Jac,

See Chip Pearson's suggesstions at:

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


---
Regards,
Norman



"Jac Tremblay" wrote in message
...
Hi everyone,
On an Excel worksheet, one can select multiple non contiguous cells
with
the
Shift an Ctrl keys. But is it possible to remove a selected cell from
the
selection without having to redo the whole selection process?
Thanks.
--
Jac Tremblay

OK, thank you Norman. I appreciate your quick reply.
Have a good first day of summer.
--
Jac Tremblay


"Norman Jones" wrote:

Hi Jac,

I am not aware of any manual method for deselecting cells from a
non-contiguous selection.


---
Regards,
Norman



"Jac Tremblay" wrote in message
...
Hi Norman,
That is a great and interesting answer and I thank you very much for it.
But
does that mean that it is not possible to do that without VBA code?
In the Windows Explorer, when one clicks on a selected item, file or
folder,
that item is deselected? Why is it not the same in Excel?
Thanks again
--
Jac Tremblay


"Norman Jones" wrote:

Hi Jac,

See Chip Pearson's suggesstions at:

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


---
Regards,
Norman



"Jac Tremblay" wrote in message
...
Hi everyone,
On an Excel worksheet, one can select multiple non contiguous cells
with
the
Shift an Ctrl keys. But is it possible to remove a selected cell from
the
selection without having to redo the whole selection process?
Thanks.
--
Jac Tremblay