Adding a drop-down form field into individual cell

[jcstoddard]

Hi,

I’m tabulating data for a report and one field (column) is limited t
two options (non numerical data). I would like to insert a drop-dow
menu into individual cells in this column. When an option is selecte
in the drop-down, I will only be using the data in that column to sort
not calculate. Is this possible, and if so how do I do it? Any help i
appreciated

 

[Debra Dalgleish]

You can use Data Validation to create a dropdown list on a worksheet.
There are instructions in Excel's Help, and here:

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