Google Docs "Data Validation" gives more control over spreadsheets

Google added a new feature “data validation” in spreadsheets that lets you control what people enter in your spreadsheet? Once a range of cells are selected, the feature can be accessed in Tools > Data Validation and lets you create rules for numbers, text, and dates. A few notes on this new feature: If data validation is applied […]

Google added a new feature “data validation” in spreadsheets that lets you control what people enter in your spreadsheet? Once a range of cells are selected, the feature can be accessed in Tools > Data Validation and lets you create rules for numbers, text, and dates. A few notes on this new feature:

  • If data validation is applied to cells containing data, rules won't be applied until the data is modified.
  • Only one validation rule can be applied to each cell.

More infoExample