Excel Dropdowns
 

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

Excel Dropdowns
 

Select the cell in column A of your row.

DataValidationList

Add your list(comma separated) or from a range of cells and OK

Copy that cell across as far as you wish.


Gord Dibben MS Excel MVP

On Thu, 27 Sep 2007 10:57:04 -0700, Drayton
wrote:

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

Excel Dropdowns
 

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?