Excel drop-down list formula

How to Create a Simple Drop-down List in Excel

1. Create a list of items you want to include in your drop-down.

1. Go to the location where you want the list to appear, select all the cells.

1. Go to Data (tab) > Data Tools (group) > Data Validation.

1. For Allow select List.

1. For Source, click on the Source button, and select the range with the prepared list of items.

1. Click OK.

You now have the ability to select an item from a drop-down.

For short lists, you can skip the preparation and input the drop-down options directly in the Source box, separated by a comma (or semicolon, depending on your regional settings), e.g.

Yes, No.

Why Use Drop-down Lists

As you saw, it’s an easy process. We’ve created a simple data entry form to collect preferences.

Data

how to add drop down values in excel

how to change drop down values in excel