Excel Dropdowns

  • Thread starter Thread starter Guest
  • Start date Start date
Select the cell in column A of your row.

Data>Validation>List

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
 
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.
 
Back
Top