The list doesn’t have to be on a worksheet the values can also be hardcoded into the source field. There is lots of flexibility in this style 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. 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 > Data Validation… Let’s create one of these.Įnter the values to be used in the drop-down list into a range of cells. The most common form of drop-down is a data validation list. ![]()
0 Comments
Leave a Reply. |