Create Dependent Drop-down lists in excel

In today’s article, we will see how to create dependent drop-down lists in excel. When we select one of the Countries, we get the list of cities of the respective country in other drop-down. To create these dependent drop-down lists, execute the following steps. 1. On second sheet, create the following named ranges. For creating…

Add or Remove items from Drop-down list in Excel

Today we will discuss one of the common and very useful feature in excel, how to add or edit existing drop-down list in excel. One of the major advantages of having drop-down list is to improve the efficiency of data entry, while limiting data entry to specific set of items resulting into less error prone…