About & Contact | Advertise | Privacy
Google Tutorials and News

Google Tutor

Your how-to guide for Google with Google tutorials, tips for using Google and handy tricks.

How to make drop-down menus in Google Docs

Written by: Christine Buske on Monday, August 30th, 2010
Posted to: Google Docs

3 comments, add yours!

Tweet

Spreadsheets are incredibly useful tools. From plain data collection and processing to organizing trips with friends or family. Sometimes, you may be using a set of variables over and over in a spreadsheet, or you want to give others an option of a set of options. For example, if you are organizing a potluck party and want people to input what type of food they are bringing (main dish, side dish, salad, desert, soup, bread, etc), you can limit what someone can input with a dropdown menu.

It’s now easy to make dropdown menus in Google spreadsheets in Google docs. Google just announced this option, and rightfully mentions one big advantage of dropdown menus in spreadsheets: it can cut down on typing errors that can in turn cause processing errors. For a potluck this may not be such a huge deal, but in more serious data set or larger data sets this can seriously cut back on headaches.

Here are the steps to create an in-cell dropdown list through validation against a range of data:

  1. Select a range of cell your want to set up with a dropdown menu function.
  2. Under the Tools menu, select Data validation.
  3. Change the Criteria to ‘Items from a list.’
  4. Click the button next to the ‘Enter list items’ option.
  5. Enter a set of custom values, separated by commas. For example, you could enter “Main course, side dish, salad, desert” in the pot-luck example.
  6. Click Save and the cell(s) you selected will have a dropdown list with the values you entered. If you selected more than one cell, all of them will have the dropdown option.

If you selected only one cell, only that cell has the dropdown menu, however when you copy and paste that same cell the cell in the pasted location also has the dropdown menu.

Don’t miss another post! Subscribe by RSS feed or by email today!

ShareShare this post!   3 comments, add yours!

Related posts

    • Understanding the New Google Spreadsheets
    • Google Docs and Spreadsheets Upgrade (part 2)
    • 6 Google Docs Features to Make Collaboration More Productive
    • Google Docs and Spreadsheets Upgrade


3 Responses to “How to make drop-down menus in Google Docs”

  1. # Danieon 30 Aug 2010 at 12:48 pm

    This is awesome, works super well for some of my research spreadsheets!

  2. # LeeMMon 30 Aug 2010 at 12:58 pm

    This is a WOW feature. Thanks for the tip.

  3. # malynon 02 Sep 2010 at 10:02 pm

    nice.

    Wouldn’t it be better to select the range option? This way, if you make changes to your list items, the changes are cascaded through all referencing cells.

  • Advertise Here
  • Authors

    • Abhijeet Mukherjee
    • Christine Buske
    • David Van
    • Peter Jalbert
    • Brian Wallace
    • Phil Glockner
    • Mark O’Neill
    • Yoast DeValk
  • Friends

    • Craig Fifield
    • Joost DeValk
    • Guiding Tech
    • PC Extreme
  • Deals

    • Save $5 - Spanning Sync Discount Code
    • $120 off - With this BOTW promo for ads
    • Coupons! - Save with our Google Checkout Coupons
  • Popular categories

    • News, Gmail, Google Chrome, Google Docs, Google Calendar
  • Just posted

    • 24 Hours In The Google Economy (Infographic)
    • Can Facebook Beat Google? (Infographic)
    • Google Launches Knowledge Graph, a Significant Change in SERPs
    • Google Docs Gets a New Research Tool
    • Gmail Gets Better Google+ Notifications
  • Just said...

    • Google Tutor’s Google Search Manual
      • Kennedy Mensah: I am overwhelmed about the details I used to overlook
      • Buadi Barachel: The Google tutor is quite faster and helps in retrieving...
      • search engine friendly: Good information. Lucky me I discovered your blog by...
    • Using the Google Deskbar
      • Penney: Everything is very open with a clear clarification of the issues. It...
    • Building A Basic Search Query
      • best sodasteam: That is a really good tip especially to those new to thhe...
  • Community


      Join me at: Twitter, MyBlogLog
  • Tools

      Beginner's Guide to Google
      Google Help Forums
      Shared Items Plugin
      Track Google via Twitter
      Research Google
      Simply Advanced Google Search
  •  

Google Tutor: Google tutorials and tips © 2003-2015. All Rights Reserved. Advertise, About & Contact Us, Sitemap, Privacy. CDN Service by MaxCDN. GoogleTutor.com is not sponsored by or affiliated with Google, Inc. in any way (although we'd love to be!) we are just fans :)