In-cell dropdown and data validation now in Google Spreadsheets
August 26th, 2010 | Published in Google Docs, Google Apps
We’ve introduced in-cell dropdown and validation to spreadsheets. This makes it easy to constrain the values of an individual cell to a specific range or list.
Editions included:
Standard, Premier, Education, Team, Partner Edition and Google Apps for Government
Languages included:
All languages supported by Google Docs
How to access what's new:
1. Enter data into a range of cells. For example, create a list of destinations on your spreadsheet.
2. Select the cell(s) you would like to validate.
3. Under the Tools menu, select Data validation...
4. Change the Criteria to ‘Items from a list.’
5. Click the button next to the ‘Create list from range’ option and select the range of cells you entered data in during Step 1.
6. Click Save and the cell you chose to validate will have a dropdown arrow in it with the data in your cell range as the potential input values. If you want, you can set a cell to allow invalid data.
For more information:
http://googledocs.blogspot.com/2010/08/in-cell-dropdown-and-validation-in.html
Get these product update alerts by email
Subscribe to the RSS feed of these updates