Teresa has attended:
Excel Intermediate course
Excel Advanced course
Lists
How do you do a drop down list?
RE: Lists
Hi Teresa,
Thank you for your question.
To create a drop down list you use Data Validation which is accessible via the Tools menu. Choose Allow list and then type the values into the Source box separated by commas.
Alternatively, you can use the control toolbox to create a combo box and then write Visual Basic code to create the value list.
I hope this answers your question.
Regards
Simon