How to create drop down list in Microsoft Excel ?


This content was proof-read by Grammarly. You can Try Grammary for FREE

This article will explain how to create drop down list in Microsoft Excel.

Drop down list is one of the most commonly used ways in excel to allow users to select the items from the predefined list . The drop down list in Excel allows the users to select only the valid entries.


Are you a .NET Developer planning to integrate GraphQL for .NET in your Application? Check out this book BUY & DOWNLOAD GRAPHQL.NET COOKBOOK

How to create drop down list in Microsoft Excel ?

Follow the below steps to create drop down list in Microsoft Excel

1. Enter the following values in the Column A of the worksheet.

Abundant Code

Programming tutorials

Excel combobox

Excel Dropdownlist

Excel tips and tricks

How to create drop down list in Microsoft Excel ?

2. Use a different worksheet . Select the cell where you want the drop down list to appear. For example , I select “C1”.

3. In the Data Menu , click “Data Validation” Dropdownlist and then click “Data Validation”.

How to create drop down list in Microsoft Excel ?

4. Specify the source of the data for the dropdown list item in the Data Validation Dialog. In the Validation Criteria , select Allow “List” and specify the range of values in the source and click OK.

How to create drop down list in Microsoft Excel ?

5. You should now see the Dropdownlist in the selected cell “C1” .

How to create drop down list in Microsoft Excel ?
%d bloggers like this: