On Aug 21, 8:47�am, kat21 wrote:
<snip
I'm using Excel Vista

Don't know about Excel Vista, but Excel 97 I do . . .

1 Somewhere on the worksheet put the list values in one column as
consecutive rows.

2 Select the cell to display the drop-down list.

3 Select Data Validation Settings.

4 Select "List" from the allow drop-down

5 Ensure "In Cell Dropdown is checked

6 With the cursor in the "Source" entry box, select all the list you
have previously filled in 1

7 Click OK..

Alan Lloyd