Add a drop-down list in Excel!

Adding a drop-down list will not only save you a number of rows but also prevent users to fill up a wrong value. Here is a quick explanation of how you can insert a drop-down list in your excel sheet.

Step #1: select the cell where you want to appear your drop-down arrow.

Step #2: Now from “Data” tab click on “Validation”.

Step #3:  Here in the “Allow” field, select “List” and type the cell source from where you are taking data to list, in my case it is from A10 to A16.