Collaboration in Google Docs is by far one of our favorite features. But we’ve noticed that one issue arises when people are collaborating in Spreadsheets. Sometimes you want to limit what people can input into a field, to make data collection easier.

Data validation helps you control what data you and your collaborators enter in your spreadsheets. Here’s what you can do with data validation:

1.) Validate numbers, dates, and text.
2.) Prevent users from entering text that doesn’t match your criteria, or show them a comment on the cell when the data doesn’t match the validation rule.
3.) Add text to the cells you add validation to, to help your collaborators enter the right type of data.

Click here to watch this video on YouTube.


UP NEXT: Voice Controls for Google Docs (April Fool's 2013)

Leave a Reply

4 Comments on "How to Control the Values Entered into a Google Spreadsheet"

Notify of
Sort by:   newest | oldest | most voted
Carlos Romero

Does this work on spreadsheets that are linked to a form?

Other way… can i use this data validation in a cell shown in form, such a when there text field on the form where i want people add only dates?


Dear Sir, I am using data validation feature in 1 cell such that it shows me a list from the values of two other cells in the same row. i.e Cell C2 will give me list of values from cell A2 and B2. Sheet1!A2:B2 This is as i want it to be. Now I want to the same to whole column. i.e. I want to copy and apply the same kind of validation to Column C, so (after applying the validation) the validation in cell C9 will be from cell A9 and B9 Sheet1!A9:B9 and similarly the validation in cell… Read more »