Let's Talk about .. Excel 2007-Simple Drop Down List

This is the instruction to create the Simple Drop Down List.

• Go to Data -> Data Validation -> Data Validation.


• Inside the Data Validation, in Settings tab, set allow to List.


• Specify the source. For example, I have these list.

• Click OK.


• Then, I got the Drop Down List.