Enter your drop down selections in a column off to the right of the
worksheet, and repeat for each selection list you might need.

Then DATA on the menu and select DATA VALIDATION. In the dialog box drop
down the selection list in the ALLOW combo box and select the LIST item.

In the SOURCE field, click the select button on the right side of the field
to return to the worksheet, and then highlight the range the list data is in.

If the drop-down list is the same for the other columns, copy the cell you
assigned data validation to and past it to the other columns. Otherwise,
repeat the process for each list that you need to use.
--
Kevin Backmann


"Drayton" wrote:

how do i setup a dropdown for every column in a certain row?