How to Create dropdown List in Excel

Basic Excel Tricks Logo

Excel is an awesome Microsoft utility which most of the professionals are using for their day to day office use as Excel is blood of our daily office lives. Hence it has lots of amazing feature which can ease our data gathering requirements in excel.

So here will be talking about DATA VALIDATION – Creating Smart drop down List in Excel which will restrict the user to enter unwanted values. So here we go:

Step 1: Here I have taken a range from A2:A8 which would like to show in drop down list at cell “C4”:

Excel Tricks

Step 2: Click on “Data” on the top of excel and select Data Validation:

Excel Tricks

Step 3: Select List under “Allow” and enter the Range of your data under “Source”. Click Ok:

Excel Tricks

Note: In order to fix the range, you need to use “$” sign before Column and Row reference values i.e. $A$2:$A$8

Excel Tricks

Step 4: Here is your drop down list:

Author:
Excelsirji.com was started with the thought of making people experience easy while working with Excel, data analytics, vba, automations etc.

Leave a Reply

Your email address will not be published. Required fields are marked *