Blogs >> Technology >>
Validate Google Spreadsheet Data with New Data Validation Feature
Google has added one more very useful feature to Google that is Data
validation to Google Spreadsheets. Google Spreadsheet users can easily
create data validation rules for numbers, text and for dates. Once a
range of cells are selected, the feature can be accessed in Tools >
Data Validation.
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/
|
|
