I would like to know how to establish the list that can be picked
from.. If I "right click" on a cell I get the option to "pick from a
list" but nowhere can I find out how to make that list.

Hi John,

Look at Excel'd Data Validation featu

Data | Validation.

Debra dalgleidh has a n excellent tutorial ob Data Validation at:

http://www.contextures.com/xlDataVal01.html


---
Regards,
Norman



wrote in message
oups.com...
I would like to know how to establish the list that can be picked
from.. If I "right click" on a cell I get the option to "pick from a
list" but nowhere can I find out how to make that list.

Debra dalgleidh has a n excellent tutorial ob Data Validation at:

==

Debra Dalgleish has a n excellent tutorial on Data Validation at:

---
Regards,
Norman

This is a worksheet issue not a programming issue. Go to Data ...
validation ... list ... source put in the range that contains the list

Cheers


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=544671

the list is generated by Excel from contiguous data immediatly preceding that
cell in the same column.


in A1 put in ABC
in A2 put in EFG
select A3, then right click and select pick from list (or pick from dropdown
list).
--
Regards,
Tom Ogilvy


" wrote:

I would like to know how to establish the list that can be picked
from.. If I "right click" on a cell I get the option to "pick from a
list" but nowhere can I find out how to make that list.

Well done Tom for reading the question properly.

:

--
tony
-----------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...fo&userid=2107
View this thread: http://www.excelforum.com/showthread.php?threadid=54467