Blog

How to Create Dynamic Drop Down List in Excel

How to Create Dynamic Drop Down List in Excel




                         Data Validation feature improves the efficiency of data entry in excel and reduces mistakes and typing errors. It is used to restrict the user for the type of data that can be entered in the range. In the case of any invalid entry, it shows a message and allows the user to enter the data based on specified condition.

 

 

How to Create Normal Drop Down List

In Normal Drop Down List in this, we select the data from the normal range in the excel and one of the demerits of this option  is if we add any new item in the list it will not reflect in our drop down option and for this we need to change the source manually for reflecting the change.

 

 

 

Create Dynamic Drop Down List by overcoming the Demerits of the Normal Range

First, we need to convert the range to the Table Format, and select this as the source of the list in the drop-down list and click Ok.

And if we add a new item to this range it will reflect in our drop down list and which will help us to save a lot of time.



 

Video Link: Watch Video

Phone : +91 8606648045
Email : info@excelskillcorner.com
Excel Skill Corner
Kerala, India.