![]() ![]() ![]() 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 |