To change the display style: click Advanced options.To change the options listed, edit the items under 'Criteria'.Select the cell or cells that you want to change, then select an option:.To remove the value from the list, change the source range or any other item's colour. Important: If you delete a value with an assigned colour from the criteria source range when the drop-down is populated from a range, the value and colour 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: OPTIONAL: If you enter data in a cell that doesn't match an item on the list, it is rejected.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |