How to add drop down in excel?
In the Data Tools section of the Data tab, click the “Data Validation” button. The Data Validation dialog box displays. On the Settings tab, select “List” from the Allow drop-down list (see, drop-down lists are everywhere !). Now, we’re going to use the name we assigned to the range of cells containing the options for …