The values should be entered into a single column or row without any blank cells. Initially, this method of creating an Excel data validation list takes a bit more time but may save even more time in the long run. When done, click OK.Īdvantages: You can modify your dropdown list by making changes in the referenced range without having to edit the data validation list itself.ĭrawbacks: To add or remove items, you will need to update the Source range reference. Place the cursor in the Source box and select the range of cells containing the items, or click the Collapse Dialog icon and then select the range.
0 Comments
Leave a Reply. |