Loading…
Loading…
Data validation limits what can go in a cell. A list rule adds a dropdown so people pick from approved values, and anything else is rejected. Select the cells, open Validation, and type the items (comma-separated) or point at a range such as =$F$2:$F$4.
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.