![]() ![]() Date: This option doesn't create a drop-down list.Instead, it validates that the entry contains or does not contain a particular string of text, is a valid email address, or is a properly constructed URL. Text: This does not present a drop-down list.Instead, it validates that their entry falls within a specific numeric range. Number: This does not present a drop-down list to the user. ![]() Each item entered should be separated by a comma. List of items: When selected, a drop-down list containing text values entered in the accompanying edit field appears.List from a range: When selected, a drop-down list containing values retrieved from a specific cell range (from the active sheet or another sheet in the current workbook) appears.Each option dictates specific data requirements that the spreadsheet's user must follow when entering or selecting an item in or from the cell range. The Criteria setting contains a drop-down menu that offers the following options. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |