Google Spreadsheets Introduces Data Validation, Sweet!
Google Spreadsheets team has introduced another very useful feature to their online excel competitor: Data Validation.
Although the data validation is not as robust as that of Excel’s, it provides basic validations pretty neatly.
See a sample validation condition and how the error message would be displayed.
And the message:
You can access data validation feature from Tools menu in the Google docs spreadsheets.
They have also enabled mobile access through list view, which is pretty nifty if you spreadsheet from your iPhone.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« “Too Many Worksheets” Driving You Nuts? Read This!||Market Segmentation Charts using Conditional Formatting »|