![]() The source can be entered manually, using commas to separate the options:.If you’re modifying an existing list, the validation criteria type will be preselected with the existing type. In the Data Validation dialog box click in the validation criteria selection button and select ‘List’: Go to the Data tab and click on the data validation button.Select the cell(s) where you want to create/modify the drop down list. ![]() The lists (or drop down lists) are a type of data validation used to make sure the users enter a value from a set of options. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |