You can use data validation to create drop down lists in cells. There
are instructions in Excel's Help, and here:

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

N E Body wrote:
> Hello everyone
>
> When I right click and select "Pick from list" I get a selection to choose
> from.
>
> Is it possible to modify or emulate this to select a named range?
>
> Kenny
>
> Win Me 2000 and XP
> Office 97 and 2000
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html