Drop down options

[mt]

i want to have two drop down lists in my spreadsheet.
When i select an option on the first drop down list i want the second drop
down list options to change accordingly. e.g. if i choose breakfast on the
first drop down i want "cereal", "toast" etc to appear as options on the
second drop down list, but if i select "dinner" on the first i want the
second to offer "steak", "salad" etc. How do i do this?

thanks

 

[Debra Dalgleish]

There are instructions here for creating dependent data validation lists:

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