![how to make a drop down list in excel with pictures how to make a drop down list in excel with pictures](https://www.easyclickacademy.com/wp-content/uploads/2019/05/How-to-create-drop-down-list-in-Excel.png)
- #HOW TO MAKE A DROP DOWN LIST IN EXCEL WITH PICTURES HOW TO#
- #HOW TO MAKE A DROP DOWN LIST IN EXCEL WITH PICTURES DOWNLOAD#
This has been a guide to Drop Down List in Excel.
![how to make a drop down list in excel with pictures how to make a drop down list in excel with pictures](https://www.exceltrick.com/wp-content/uploads/2012/12/Drop-Down-Option-in-Excel-3.png)
#HOW TO MAKE A DROP DOWN LIST IN EXCEL WITH PICTURES HOW TO#
In this example, we will see how to add a “YES” or “NO” drop-down with a clear example. Now in the above screenshot, we can see that the drop-down list has been applied to all the column where it shows the entire students name from the database and Roll No and Grade. We can see that a drop-down list has been created for only one column to apply to all the columns wherever we need we have to copy and paste the drop-down box to the specific cell. We can now create the Drop Down list to choose the students name and their corresponding roll no and grade, as shown in the below screenshot. Hence we have created a drop-down list for all Student Name, Roll No, Grade.
![how to make a drop down list in excel with pictures how to make a drop down list in excel with pictures](https://contexturesblog.com/wp-content/uploads/2010/10/datavallist05.png)
#HOW TO MAKE A DROP DOWN LIST IN EXCEL WITH PICTURES DOWNLOAD#
You can download this Drop Down List Excel Template here – Drop Down List Excel Template