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