Droplist combo in Excel 2K 1

[thedaver]

I need to add droplists to categorize line items in an job estimating worksheet. I have the list of allowed categories in a named range in the same workbook.

How can I provide a droplist (via combo box??) from the named range for each row of a specific column??

eg:

Item Price Qty Category Subtotal
ball 3 1 [droplist] 3
bat 5 2 [droplist] 10
glove 2 1 [droplist] 2

Sorry for the basic question.

 

[carrr]

Check out data validation:

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