create a selection option (i.e. choose "Valid" or "Not Valid") in Excel

[andrewjgrimaldi]

I'm trying to create an "choose option" type cell in Excel. Does anyone know how to do it?

For instance,

Column A Column B
row1 Area # 121 (choose: valid or not valid)
row2 Area # 122 (choose: valid or not valid)
row3 Area # 123 (choose: valid or not valid)
row4 Area # 124 (choose: valid or not valid


row10 Area # A928 (choose: good, very good, excellent, not good, very bad)
row11 Area # B939 (choose: good, very good, excellent, not good, very bad)

Column B items is what I'm trying to create (i.e. like a drop down menu).

Any help would be greatly appreciated.

Thanks!

Andrew

 

[Scott Huish]

Select your range.
Go into Data Validation
Select List
Type in your items, separated by commas
Click OK