Excel Drop Down List

A Excel drop down list can be created using the Excel data validation options. To do this:

  1. List of Names to be Used in Drop-Down List Example

    Enter your allowed values into a column of your spreadsheet (e.g. cells A1 to A10) - you can always hide this column later if you don't want it to be visible.

  2. Select the cell (or cells) that you want your drop-down list to appear in (we have selected cell C2 in the above example on the right).

  3. From the Data tab on your Excel spreadsheet ribbon, select Data Validation→Data Validation...

    Data Validation Option in Excel

    (In Excel 2003, the Data Validation option is found in the Data menu).

  4. The Data Validation dialog box will appear. Within this dialog box:

    Validation List Option Box
    1. In the Allow field, select the option 'List'. This will cause further options to appear.
    2. Ensure the option In-cell dropdown is selected.
    3. In the Source field, enter the range of cells where you typed in your original list of options (e.g. $A$1:$A$10).

      If you prefer, you can enter this range using the mouse, by clicking on the symbol at the right of the Source field and then selecting the required range of cells with the mouse.
    4. Click OK.

Validation List Result

Your selected cell should now contain a drop-down menu containing your list of allowed values.

To tidy up the spreadsheet, you might want to hide the column that contains the orignal list.

The resulting spreadsheet (with column A hidden) is shown aboveon the left.