Customized data entry form with drop down menus

C

Christine

I have created an excel spreadsheet that contains a list similar to a library
index with document title, author, etc.

I am trying to create a customized form to enter in new data... Instead of
typing each field in by hand I want to have drop down menues to choose from a
selection. I know access is better to do this in but the users this is for
have no knowledge of or desire to learn Accesss.

How do I do this in Excel??
 
Top