How to create drop down in Microsoft Excel?

Hello Excel Lovers,

In this animated GIF below, I have shown how to create drop down list in cells in Microsoft Excel with Data Validation Function.

Drop Down List in Excel

Drop Down List in Excel

Share your views on this trick and how it helped you at your work in comments!

To Subscribe to the courses go to Courses page and be effective user of Excel and save a lot of time at work.

Best,
DJP

Share

Comments

Subscribe for Newsletter