[vc_row][vc_column][vc_empty_space height=”20px”][vc_column_text css=”.vc_custom_1637742309590{margin-bottom: 10px !important;}”]

Watch Excel Tutorial Video – How To Create Dropdown List In Excel

[/vc_column_text][vc_video link=”https://www.youtube.com/watch?v=Nrn3n9GF6sY&t=7s”][vc_empty_space height=”30px”][/vc_column][/vc_row][vc_row][vc_column][vc_column_text]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:[/vc_column_text][/vc_column][/vc_row]

Similar Posts

Leave a Reply

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