deselect cells within a range of cells

W

wagado

I have found this to be most frustrating!!!

Windows Explorer allows you to select an entire list of items and then
deselect individual items by holding the ctrl key down and clicking the items
you wish to deselect.

Why does this not work in Excel???????

I have a list of 100 items and wish to deselect about 10 that are randomly
dispersed in the selection. This seems to such a simple thing, but I've
found no solution.
 
R

RagDyer

Try this:

=INDIRECT("E"&C1)

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have found this to be most frustrating!!!

Windows Explorer allows you to select an entire list of items and then
deselect individual items by holding the ctrl key down and clicking the
items
you wish to deselect.

Why does this not work in Excel???????

I have a list of 100 items and wish to deselect about 10 that are randomly
dispersed in the selection. This seems to such a simple thing, but I've
found no solution.
 
R

RagDyer

Sorry, wrong thread ! ! !

--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Try this:

=INDIRECT("E"&C1)

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have found this to be most frustrating!!!

Windows Explorer allows you to select an entire list of items and then
deselect individual items by holding the ctrl key down and clicking the
items
you wish to deselect.

Why does this not work in Excel???????

I have a list of 100 items and wish to deselect about 10 that are randomly
dispersed in the selection. This seems to such a simple thing, but I've
found no solution.
 
Top