Blogs >> Technology >>
Validate Google Spreadsheet Data with New Data Validation Feature
![Google Docs Data Validation Google Docs Data Validation](http://readerszone.com/wp-content/uploads/Logo/google_docs_logo_readerszone.gif)
How to Use Data Validation?
- Go to Tools and select Data validation.
- Highlight cells to select a range you want to apply data validation to. A new window appears.
- Select your validation criteria: Users can set the help text, but if you update your validation criteria after editing the help text, the tip won’t get automatically updated. Use the Reset link that appears when you edit the help text to make sure the text gets automatically generated.
- Select the level of strictness: strict or lenient. If you select the first level, people can enter data that matches the validation criteria only. If you select the second level, people can enter invalid data, but they’ll see a warning whenever the data doesn’t match the criteria.
- Click save and you are done with creating a new validation rule for your Google spreadsheet.
How to Remove Data Validation From Spreadsheet cells or entire Spreadsheet.?
To remove data validation, simply select the range of cells and click Remove validation. If you’d like to remove validation from the entire worksheet, select the whole sheet by clicking the upper left corner of the sheet. Then, select Tools > Data validation, and click the Remove validation button.
http://readerszone.com/
|