![]() ![]() Select an option: On the Data validation rules panel. If you change the content of the range you select, the changes are made in the list automatically. Select the cell or cells where you want to create a dropdown list. ![]() Then, under "Display Style," select either: To change the display style: Click Advanced options.To change the options listed, edit the items under "Criteria.".Select the cell or cells you want to change, then select an option:.To remove the value from the list, change the source range or any other item’s color. Important: If you delete a value with an assigned color from the criteria source range when the dropdown is populated from a range, the value and color will still appear under criteria, but as uneditable. Click Advanced options, and under "If the data is invalid:," select "Show a warning.".If you want people to be able to enter items not from the list: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |