2002 excel microsoft training - Drop down menu list

Hi Patricia

It was great to meet you on Thursday and Friday of last week on my Excel Intermediate and Advanced courses. Hope you had a great weekend!

How do we create a drop down menu list?

1. Select Data menu, Validation
2. Choose the validation criteria of List
3. Type in the Source box: the list for your drop down, separating each one by a comma.
4. Set up Input Message and Error Alert if required.
5. Click OK - Validation now set up.

Hope this helps
Sandy