deselect cells within a range of cells

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deselect (Unselect) Cells 22
Deselect a cell in a discontiguous range 3
how do I deselect cells within a range of cells 6
Deselect Cells while using ctrl 5
Deselect of Cells 4
"deselect" 12
how do you "select locked cells" w/o "select unlocked cells"? 3
Cells Won't Deselect 1

Top