Populate Fields

[soccerhead]

How can I create a drop down box for names and addresses within Excel?

 

[Gary''s Student]

Use data validation:

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