How to Add a Drop-Down List in Excel

September 11, 2026

Create a drop-down list in an Excel cell with Data Validation so people pick from fixed options instead of typing free text into the cell.

You want a Status column where people choose Open, In Progress, or Closed instead of typing whatever they like. Data Validation turns a cell into a drop-down list with those fixed options.

Select the cells

Click the cell that should get the list, or drag to select a whole range such as C2:C100. Every selected cell receives the same drop-down.

Open Data Validation

Click the Data tab, then Data Validation in the Data Tools group. On Mac the button is in the same place on the Data tab. The dialog opens on the Settings tab.

Set Allow to List

In the Allow box, choose List. Leave In-cell dropdown checked, otherwise the arrow does not appear and the cell only rejects wrong entries.

Enter the options

In the Source box, either type the options separated by commas:

Open, In Progress, Closed

or click in the box and select a range on the sheet that already contains the options, one per cell, such as =$F$2:$F$4. Typed options are limited to 255 characters in total, so use a range for long lists.

Click OK

Click OK. Select one of the cells and a small arrow appears at its right edge. Click it and the three options are listed. Picking one writes that text into the cell. Pressing Alt + Down Arrow (Mac: Option + Down Arrow) opens the list from the keyboard.

To remove the list later, select the cells, open Data Validation again, and click Clear All.

To let the list grow. Put the options on a separate sheet, one per cell. Select that range, type a name such as Statuses into the Name Box to the left of the formula bar, press Enter, and use =Statuses as the Source. Adding an option inside the named range makes it appear in the drop-down without editing the validation. Blank cells at the end of the range show up as empty entries, so keep the range tight.

To control what happens when someone types something else. The Error Alert tab in the same dialog decides. Style Stop rejects the entry, Warning asks for confirmation, and Information allows it with a note. Unchecking Show error alert after invalid data is entered allows anything while still offering the list.