![]() ![]() Now we will create a validation list based on a Table of values. This is because the cell range specified as the source for the validation list is a fixed range.Ĭreating a Drop Down Validation List From a Table List We still only have the original 6 values. If you now return to the main sales data worksheet and click in one of the Customer Type cells you will see that the new value has not been picked up by the validation list: We will now add an extra Customer Type value of Entertainment to the end of the list on the Validation List Tables worksheet: If you now click in any of the cells that validation was applied to you will see that a drop down list is now available: The following screen shot shows the dialog having been completed: Add the cell range for the 6 customer type values.select the List option in the Allow field. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |