Source Link


In-cell dropdown and validation in spreadsheets

Today, we added 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. For example, if you are building a trip planning spreadsheet, you can now limit the options in the travel destination column to a select set of cities via dropdown lists.

In-cell dropdowns also make input easier by reducing unnecessary typing and errors in processing. You can create dropdown lists in individual cells through the data validation tool by validating against a range of cells in your sheet or by creating a custom list.

via Google Blogs...

0 comments ↓

There are no comments yet...Kick things off by filling out the form below.

Leave a Comment