Drop down lists

A

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
 
J

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.
 
Top