Drop down list in Excel tutorial

This is a quick tutorial on how to create a drop down list in Excel. Type the following data into your spreadsheet:

Drop down list in excel data

Click the cell you want add the drop down list into and go to the Data tab. Click on Data validation:

In the opening dialogue select List in Allow and for the Source select the data area. Click Ok.

Now you have your drop down list:

No comments:

Post a Comment