Drop down lists

[Alex McKenzie]

Hi all

Was wondering if somebody could give me some
clues on how to insert a drop down
list into a cell (if this can be done)

This list will contain the names of a numer of' stocks
of which I need to select and display one

Many thanks

Alex

[Peo Sjoblom]

Description here

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

--
Regards,

Peo Sjoblom

(No private emails please)


"Alex McKenzie" <[email protected]> wrote in message
news:[email protected]...
> Hi all
>
> Was wondering if somebody could give me some
> clues on how to insert a drop down
> list into a cell (if this can be done)
>
> This list will contain the names of a numer of' stocks
> of which I need to select and display one
>
> Many thanks
>
> Alex
>

[Jezebel]

1. Enter the list of items somewhere in the workbook.

2. Select the cell where you want the list.

3. Go to Data > Validation. Select 'List' from the Allow drop-down. Select
the list item range in the Source field.





"Alex McKenzie" <[email protected]> wrote in message
news:[email protected]...
> Hi all
>
> Was wondering if somebody could give me some
> clues on how to insert a drop down
> list into a cell (if this can be done)
>
> This list will contain the names of a numer of' stocks
> of which I need to select and display one
>
> Many thanks
>
> Alex
>