![]() ![]() There is lots of flexibility in this type of drop-down list. Typing an invalid entry in the cell will result in an error message. We can now only select a value from the list. To use the drop-down, click on the cell containing the data validation list. The data validation dialog box opens. On the Settings tab, select list from the allow box, and enter the range of cells containing the list in the source box.Ĭlick OK to close the data validation dialog box. Then select the cell in which the drop-down should exist.Ĭlick Data > Data Validation (drop down) > Data Validation… ![]() The most common form of drop-down list is a data validation list. Let’s create one of these.Įnter the values to be used in the drop-down list into a range of cells these are known as the ‘list items’. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |