Drop down list excel 2000

[mike575]

I have a spreadsheet this we use at trap shooting to track everybody scores at different weekend events. I would like to create a drop down list for entering the peoples names. Most of the people are returning shooters and some are new. On the registartion worksheet one of the column is for name (Last,First) how can I create some form of drop down list that will cover upto 75 lines in the same column.

[Jacob Hilderbrand]

Data | Validation | List

If you want to use this list on a different worksheet then you will need to create a Named Range.

Insert | Name | Define

[mike575]

Thanks, The "list" selection was hard to find/understand but I mastered it. That just what I want.


Thanks much

[Jacob Hilderbrand]

You're Welcome

Take Care