How to Create dropdown List in Excel
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”:
Step 2: Click on “Data” on the top of excel and select Data Validation:
Step 3: Select List under “Allow” and enter the Range of your data under “Source”. Click Ok:
Note: In order to fix the range, you need to use “$” sign before Column and Row reference values i.e. $A$2:$A$8
Step 4: Here is your drop down list: