microsoft excel training - Drop down menus

Alicia,

Drop down menus are known as Data Validation

Under TOOLS > DATA VALIDATION, there is an option called LIST. You need to specify what you will see in the list, by adding information to the SOURCE area. Separate the data with commas:

example:
Apples, Bananas, Pears

You can also select a range from the current speadsheet, by simply highlighting the data in a single column that you want to appear in the list.

Data validation LIMITS the information that you can enter into the cells by the criteria you specify, in this case the data or list that you enter.

Regards

Richard