![]() ![]() As soon as you select List, the source field appears.In the Data Validation dialogue box, within the Settings tab, select List as the Validation criteria.Go to Data –> Data Tools –> Data Validation.Select a cell where you want to create the drop down list. ![]() Here are the steps to create an Excel Drop Down List: Let’s say you have a list of items as shown below: In this section, you will learn the exacts steps to create an Excel drop-down list:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |