![]() In Source field, select the cells which have the items that you want in the drop down.In the Data Validation dialogue box, within the settings tab, select ‘List’ as Validation Criteria.Go to Data –> Data Tools –> Data Validation.Select the cell or range of cells where you want the drop-down list to appear (C2 in this example).Here are the steps to create a drop-down list in Excel: There are two parts to creating a drop-down list that allows multiple selections: So if you have any questions after reading this, please check out the FAQ section first. Since I get a lot of similar questions, I have decided to create an FAQ section at the end of this tutorial. ![]() This has been one of the most popular Excel tutorials on this site.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |