how to add drop box in a spreadsheet

[Guest]

I want to add a drop box in a spreadsheet for people to select yes or no and
for production and shipment. It will not link to any database nor it will be
used as a data entry, How to add such a drop list to a cell in the
spreadsheet????.

 

[Guest]

I believe it's under the "data" tab...

 

[Debra Dalgleish]

You can use Data Validation. There are instructions in Excel's Help, and
here:

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