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 […]

Share online:

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

About The Author

Deepak Gupta is a IT & Web Consultant. He is the founder and CEO of diTii.com & DIT Technologies, where he’s engaged in providing Technology Consultancy, Design and Development of Desktop, Web and Mobile applications using various tools and softwares. Sign-up for the Email for daily updates. Google+ Profile.