How to Add a Drop Down List in Excel

Are you tired of manually typing in data in your Excel spreadsheets? Do you want to make your data entry more efficient? Then you need to learn how to add a drop down list in Excel!

Step 1: Create a List of Options

The first step is to create a list of options that will be displayed in the dropdown menu. You can do this by making a list of items in a column or row. Be sure to include all the options you want in the dropdown list.

Step 2: Select the Cell for the Dropdown List

Next, select the cell where you want to add the dropdown list. This can be any cell in the spreadsheet, but make sure it's a cell where you will be entering data in the future.

Step 3: Go to the Data Tab

On the Excel ribbon, click on the "Data" tab to access the data tools.

Step 4: Click on Data Validation

Within the "Data" tab, click on the "Data Validation" button. This will open a dialogue box.

Step 5: Select "List" in the Allow Dropdown

Within the "Data Validation" dialogue box, select "List" in the "Allow" dropdown menu.

Step 6: Enter the Source Data

In the "Source" field, enter the range of cells that contains the options for your dropdown list. You can either type in the range or click and drag to select the cells.

Step 7: Optional Settings

You can customize the settings for your dropdown list. For example, you can choose whether to allow invalid entries or display an error message. Feel free to experiment with the different settings to find what works best for your spreadsheet.

Step 8: Test Your Dropdown List

Now it's time to test your dropdown list! Click on the cell with the dropdown list and the options should appear.


Adding a dropdown list in Excel can save you time and make your data entry more efficient. By following these simple steps, you can easily create a dropdown list in your spreadsheet. So, go ahead and give it a try!

By clicking “Accept”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.