Free Online Storage

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Thursday, 26 August 2010

In-cell dropdown and validation in spreadsheets

Posted on 09:31 by Unknown
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.


Follow these steps to create an in-cell dropdown list through validation against a range.
  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.
You can also create a in-cell dropdown using a custom list.
  1. Under the Tools menu, select Data validation...
  2. Change the Criteria to ‘Items from a list.’
  3. Click the button next to the 'Enter list items' option.
  4. Enter a set of custom values, separated by commas. For example, you could enter "San Francisco, New York, Chicago and Los Angeles."
  5. Click Save and the cell you selected will have a dropdown list with the values you entered as potential input values.
Let us know what you think in the comments.

Posted by: Li-Wei Lee, Software Engineer
Email ThisBlogThis!Share to XShare to Facebook
Posted in Google Apps Blog, spreadsheets | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • More Google Experiments That Hide Results URLs
    There are at least two other versions of the Google experiment that removes search results URLs . The first alternate version places site na...
  • Add a Keyboard Shortcut for Chrome's App Launcher
    I'm not sure why Chrome's app launcher doesn't have a keyboard shortcut, but it's pretty easy to add one. For Windows XP, r...
  • Merge cells vertically in Google spreadsheets
    There are many times when you want to format your spreadsheets in a certain way to make your data easier to read and understand. Starting to...
  • Docs on the iPhone with Chris Pirillo
    Posted by: Meredith Whittaker, Program Manager Chris Pirillo , Gnomedex Conference founder, CNN.com Live technology contributor, and one of ...
  • Writing a campaign speech with Google Docs
    A few months ago, my colleague Julia and I were at a technology conference for educators. Teachers were very enthusiastic when we demonstrat...
  • Google Now for Google's Homepage in Testing
    It looks like Google Now won't be limited to Android, iOS and Chrome , it will also be added to Google's homepage. Some code from a...
  • Google spreadsheets, now with discussions
    Getting things done with others would be much easier if everyone was sitting right next to you. But since that’s rarely the case, we’re alwa...
  • Collect audience input with Google Sites & Moderator
    Google Moderator helps anyone find the best input from their audiences, whether it’s suggestions on how to stop the oil spill , debate que...
  • Get Docs in 38 languages
    Posted by: Ken Norton, Product Manager, Google Docs Earlier today we launched Google Docs in 13 more languages, bringing our total number of...
  • View .doc attachments right in your browser
    Cross posted on the Gmail blog If you receive Microsoft® Word files as attachments in Gmail, you can now view them with a single click -- no...

Categories

  • Acquisitions
  • Ads
  • Android
  • Annoyances
  • April Fools Day
  • attachments
  • back to school
  • Blogger
  • charts
  • chat
  • Chrome
  • Chrome extensions
  • chrome web apps
  • Cloud Connect
  • collaboration
  • comments
  • community
  • discussions
  • DMCA
  • docs
  • document list
  • documents
  • documents list
  • drawings
  • drivebacktoschool
  • Easter Egg
  • education
  • Faces of Docs
  • forms
  • gmail
  • gone google
  • Google Alerts
  • Google Analytics
  • Google Apps Blog
  • Google Apps Script
  • Google Calendar
  • Google Cast
  • Google Checkout
  • Google Chrome
  • Google Chrome OS
  • Google Cloud Connect
  • Google Contacts
  • Google Dictionary
  • Google Docs
  • Google Docs Viewer
  • google documents
  • google drive
  • Google Earth
  • Google Goggles
  • Google Hangouts
  • Google Instant
  • Google Keep
  • Google Latitude
  • Google Local
  • Google Maps
  • Google Music
  • Google News
  • Google Notebook
  • Google Now
  • Google Pack
  • Google Photos
  • Google Play
  • Google Plus
  • Google Reader
  • Google Sites
  • Google Suggest
  • Google Takeout
  • Google Talk
  • Google Toolbar
  • Google Translate
  • Google Trends
  • Google Voice
  • Google Wallet
  • Google+
  • googlenew
  • Greasemonkey
  • Guest Post
  • holiday
  • iGoogle
  • Image Search
  • images
  • InOut
  • iOS
  • Keep
  • Knowledge
  • mobile
  • OCR
  • offline
  • OneBox
  • paperless
  • pdfs
  • photo
  • photos
  • Picasa Web Albums
  • presentations
  • product ideas
  • profiles
  • quickoffice
  • Reddit
  • research
  • save to drive
  • scripts
  • Security
  • sharing
  • sheets
  • shortcut
  • slides
  • spell check
  • spreadsheets
  • stock photos
  • storage
  • students
  • tables
  • teachers
  • templates
  • Tips
  • User interface
  • videos
  • Viewer
  • Visualization
  • Voice Search
  • Web Search
  • Yahoo
  • YouTube

Blog Archive

  • ►  2013 (519)
    • ►  December (33)
    • ►  November (44)
    • ►  October (64)
    • ►  September (50)
    • ►  August (63)
    • ►  July (60)
    • ►  June (57)
    • ►  May (62)
    • ►  April (49)
    • ►  March (33)
    • ►  February (1)
    • ►  January (3)
  • ►  2012 (34)
    • ►  December (4)
    • ►  November (4)
    • ►  October (5)
    • ►  September (4)
    • ►  August (2)
    • ►  July (1)
    • ►  June (3)
    • ►  May (2)
    • ►  April (2)
    • ►  March (2)
    • ►  February (5)
  • ►  2011 (80)
    • ►  December (4)
    • ►  November (1)
    • ►  October (7)
    • ►  September (10)
    • ►  August (11)
    • ►  July (8)
    • ►  June (9)
    • ►  May (1)
    • ►  April (8)
    • ►  March (8)
    • ►  February (8)
    • ►  January (5)
  • ▼  2010 (118)
    • ►  December (11)
    • ►  November (16)
    • ►  October (6)
    • ►  September (13)
    • ▼  August (13)
      • Collaborative highlighting in documents
      • In-cell dropdown and validation in spreadsheets
      • Show all formulas in your spreadsheets
      • Tips & Tricks: Enhancing your Presentations with I...
      • Horizontal navigation, site footer, and more in Go...
      • Check spelling in Google spreadsheets
      • New in Gmail Labs: Find docs and sites quickly wit...
      • Auto-linking, preferences and page sizes in documents
      • Tips & Tricks: GoogleFinance in Google spreadsheets
      • Collect audience input with Google Sites & Moderator
      • Convert files in the documents list to a Google Do...
      • A new curve tool for drawings
      • Table resizing and other niceties in documents
    • ►  July (7)
    • ►  June (15)
    • ►  May (11)
    • ►  April (7)
    • ►  March (7)
    • ►  February (6)
    • ►  January (6)
  • ►  2009 (82)
    • ►  December (14)
    • ►  November (4)
    • ►  October (10)
    • ►  September (10)
    • ►  August (4)
    • ►  July (6)
    • ►  June (6)
    • ►  May (5)
    • ►  April (4)
    • ►  March (8)
    • ►  February (7)
    • ►  January (4)
  • ►  2008 (97)
    • ►  December (6)
    • ►  November (4)
    • ►  October (6)
    • ►  September (8)
    • ►  August (5)
    • ►  July (7)
    • ►  June (11)
    • ►  May (20)
    • ►  April (13)
    • ►  March (6)
    • ►  February (6)
    • ►  January (5)
  • ►  2007 (25)
    • ►  December (1)
    • ►  November (1)
    • ►  October (2)
    • ►  September (3)
    • ►  August (3)
    • ►  July (4)
    • ►  June (3)
    • ►  May (2)
    • ►  April (2)
    • ►  March (1)
    • ►  February (2)
    • ►  January (1)
  • ►  2006 (10)
    • ►  December (2)
    • ►  November (4)
    • ►  October (4)
Powered by Blogger.

About Me

Unknown
View my complete profile