Very good feature to have in MS Excel is a dynamic drop down list when it is possible to add additional options to drop down with less efforts. So how to do it.
First of all lets make a source which will feed our drop down list. I decided to have some fruits in my drop down list.