How To Add Drop Down In Excel?

Select the cell or range where you want the drop-down list

Go to the ribbon: Data → Data Validation

In Allow, select List

In Source, enter one of the following:

Type comma-separated values (e.g., Yes,No,Maybe)

Select a list range (e.g., =A2:A10)

Check the box for In-cell dropdown (if shown)

(Optional) Check Ignore blank if you want blanks allowed

(Optional) Check Show input message (to display a prompt) and/or Show error alert (to restrict invalid entries)

Click OK

To edit the drop-down list: repeat Data → Data Validation and change the Source

To remove the drop-down: select the cells → Data → Data Validation → Clear All → OK

Suggested for You

Trending Today