ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Remove a cell from a multiple selection (https://www.excelbanter.com/excel-programming/364920-remove-cell-multiple-selection.html)

Jac Tremblay[_4_]

Remove a cell from a multiple selection
 
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

Norman Jones

Remove a cell from a multiple selection
 
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




Jac Tremblay[_4_]

Remove a cell from a multiple selection
 
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





Norman Jones

Remove a cell from a multiple selection
 
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







Jac Tremblay[_4_]

Remove a cell from a multiple selection
 
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








All times are GMT +1. The time now is 01:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com