Shaun Mccran

My digital playground

15
J
U
N
2011

Creating in-cell drop down lists in Google Spreadsheets

Posted By : Shaun McCran
Related Categories: Google, General Interest
I use Google Docs a lot, especially the Google Docs Spreadsheet format. Recently I wanted to give users the option of selecting one value from several pre-defined values rather than an open field. I thought that the best way to do this would be through a drop down list attached to the cell, but how to do this?

This is pretty simple process once you have done it once. Open your document and follow these steps.

  • Under the Data menu, select Validation....
  • In the drop down menu next to Criteria: select Items from a list.
  • Click the button next to the 'Enter list items' option.
  • Enter a set of custom values, separated by commas. For example, you could enter "Car,Bus,Plane,Taxi,Motorbike"
  • Click Save and the cell you selected will have a drop down list with the values you entered as potential input values.

This results in something like the screenshot below.

Comments Comments (62) | Send Send | del.ico.us del.icio.us | Digg It! Digg It! | Linking Blogs Linking Blogs |
Answer Questions
TweetBacks
Comments (Comment Moderation is enabled. Your comment will not appear until approved.)
[Add Comment] [Subscribe to Comments]
Cody's Gravatar Is there any mobile android app that will let you use the drop down menus?
# Posted By Cody | 12/07/2011 00:07
Oscar's Gravatar Thanks!
This is what I was looking for!

Oscar
# Posted By Oscar | 21/02/2013 03:15
Christopher's Gravatar Well that was a pretty good description on the drop down menu creation in cell which was truly helpful. I too have the same usage of Google docs. You have listed the simple tutorial to go through and implement in my blog. I often use the docs for this blog purpose. You have made my task more easier now.
# Posted By Christopher | 10/04/2015 06:38
Emma Goldstein's Gravatar Web Design Company @ https://www.viziononline.co.uk/
Web Design Agency @ https://www.viziononline.co.uk/web-design/" target="_blank">https://www.viziononline.co.uk/web-design/
Website Development Company @ https://www.viziononline.co.uk/web-development/" target="_blank">https://www.viziononline.co.uk/web-development/
SEO Web Design @ https://www.viziononline.co.uk/seo/" target="_blank">https://www.viziononline.co.uk/seo/
PPC Agency London @ https://www.viziononline.co.uk/ppc-advertising/
Social Media Management @ https://www.viziononline.co.uk/social-media/
Graphic Design @ https://www.viziononline.co.uk/graphic-design/" target="_blank">https://www.viziononline.co.uk/graphic-design/
Mobile Website Design @ https://www.viziononline.co.uk/mobile-websites/" target="_blank">https://www.viziononline.co.uk/mobile-websites/
Web Application Development @ https://www.viziononline.co.uk/app-development/" target="_blank">https://www.viziononline.co.uk/app-development/
e-Commerce Website Design & Development @ https://www.viziononline.co.uk/e-commerce/
# Posted By Emma Goldstein | 12/05/2015 23:32
Sunny's Gravatar Visa Consultants @ http://www.goforvisa.com/

Canada Express Entry @ http://www.goforvisa.com/canada-express-entry-2015-immigration/

Immigration Consultants @ http://www.sevenseasedutech.in/immigration/

Express Entry to Canada @ http://www.sevenseasedutech.in/canada-express-entr...

IELTS Training Institutes in Delhi @ http://www.sevenseasedutech.in/ielts/
# Posted By Sunny | 14/05/2015 02:09
Kelly J. Critchfield's Gravatar I tried a lot many times to use the drop down menu list but couldn't. After surfing into your blog I found the exact way of using it and now I became hassle free. I posted the update at http://www.bestsdissertation.com/ to let others knew about it.
# Posted By Kelly J. Critchfield | 04/06/2015 01:37
packers and movers in pune's Gravatar You Welcome Here For visiting our shifting services.

http://www.export5th.in/packers-and-movers-in-pune...
# Posted By packers and movers in pune | 13/06/2015 00:33
packers and movers's Gravatar Thanks For clicking Our Info about Shifting and moving services.

http://www.export5th.in/packers-and-movers-in-gurg...
# Posted By packers and movers | 13/06/2015 03:26
packers and movers bangalore's Gravatar movers and packers bangalore @ http://www.the5th.in/packers-and-movers-bangalore....
movers and packers gurgaon @ http://www.the5th.in/packers-and-movers-gurgaon.ht...
# Posted By packers and movers bangalore | 01/08/2015 05:05
packers and movers pune's Gravatar movers and packers mumbai @ http://www.the5th.in/packers-and-movers-mumbai.htm...
movers and packers pune @ http://www.the5th.in/packers-and-movers-pune.html
# Posted By packers and movers pune | 01/08/2015 05:06
Packers and Movers in Bangalore's Gravatar http://top3th.co.in/packers-and-movers-bangalore/
http://top3th.co.in/packers-and-movers-hyderabad/
http://top3th.co.in/packers-and-movers-chennai/" target="_blank">http://top3th.co.in/packers-and-movers-chennai/
http://top3th.co.in/
# Posted By Packers and Movers in Bangalore | 13/08/2015 00:33
Packers and Movers in Delhi's Gravatar http://3th.co.in/packers-and-movers-delhi/" target="_blank">http://3th.co.in/packers-and-movers-delhi/
http://3th.co.in/packers-and-movers-noida/
http://3th.co.in/packers-and-movers-faridabad/
http://3th.co.in/packers-and-movers-ghaziabad/" target="_blank">http://3th.co.in/packers-and-movers-ghaziabad/
http://3th.co.in/
# Posted By Packers and Movers in Delhi | 13/08/2015 00:34
Packers's Gravatar Thanks for Nice and Informative Post. This article is really contains lot more information about This Topic. -
http://www.expert5th.in/packers-and-movers-hyderab...
http://www.expert5th.in/packers-and-movers-chennai...
http://www.expert5th.in/packers-and-movers-mumbai/...
http://www.expert5th.in/packers-and-movers-noida/
# Posted By Packers | 08/09/2015 04:12
Packers's Gravatar Thanks for Nice and Informative Post. This article is really contains lot more information about This Topic. -
http://www.expert5th.in/packers-and-movers-ghaziab...
http://www.expert5th.in/packers-and-movers-thane/
http://www.expert5th.in/packers-and-movers-navimum...
http://www.expert5th.in/packers-and-movers-faridab...
# Posted By Packers | 08/09/2015 04:16
Packers's Gravatar Thanks for post this helpful post - Please visit for More information about -
http://www.expert5th.in/packers-and-movers-bangalo...
http://www.expert5th.in/packers-and-movers-pune/
http://www.expert5th.in/packers-and-movers-hyderab...
# Posted By Packers | 08/09/2015 04:18
buy traffic's Gravatar I too have the same usage of Google docs. You have listed the simple tutorial to go through and implement in my blog. I often use the docs for this blog purpose.
# Posted By buy traffic | 05/10/2015 03:11
cardsharing's Gravatar Well that was a pretty good description on the drop down menu creation in cell which was truly helpful. I too have the same usage of Google docs. You have listed the simple tutorial to go through and implement in my blog.
# Posted By cardsharing | 08/10/2015 00:05
insta followers's Gravatar I too have the same usage of Google docs. You have listed the simple tutorial to go through and implement in my blog. I often use the docs for this blog purpose.
how to get more instagram likes
http://socialgrand.com/buy-instagram-likes/
# Posted By insta followers | 08/10/2015 00:16
furniture stores Chicago's Gravatar You have listed the simple tutorial to go through and implement in my blog. I often use the docs for this blog purpose.
# Posted By furniture stores Chicago | 10/10/2015 02:56
cab service jaipur to delhi's Gravatar I love to post a comment that "The content of your post is awesome" Great work.
# Posted By cab service jaipur to delhi | 10/10/2015 04:20
cccam server's Gravatar Thanks For clicking Our Info about Shifting and moving services.
# Posted By cccam server | 19/10/2015 04:08
yunusberdebes's Gravatar wew
# Posted By yunusberdebes | 26/10/2015 20:30
Sharon Stan's Gravatar That's a very useful tutorial; Creating drop down i menus is very important when opting for user selection, and on the other side not easy to implement
http://www.therowingmachinedoctor.com/
# Posted By Sharon Stan | 30/10/2015 09:37
Unlock His Heart's Gravatar Under the Data menu, select Validation....
# Posted By Unlock His Heart | 04/11/2015 02:36
cccam server's Gravatar I use Google Docs a lot, especially the Google...
# Posted By cccam server | 05/11/2015 01:51
cccam server's Gravatar Under the Data menu, select Validation....
# Posted By cccam server | 07/11/2015 01:56
packers and movers pune to hyderabad's Gravatar i menus is very important when opting for user selection, and on the other side not easy to implement
# Posted By packers and movers pune to hyderabad | 08/11/2015 21:49
cccam server's Gravatar Im my previous article on how to use the JQuery datatables plug I concentrated mainly on the JQuery script, and how to build the AJAX request to receive a JSON response.
# Posted By cccam server | 11/11/2015 04:20
cccam server's Gravatar Next to actually build our data table object. We simply list any of the parameters that we want to pass to the dataTable method as name value pairs..
# Posted By cccam server | 11/11/2015 21:35
jackrobin's Gravatar Next to actually build our data table object. We simply list any of the parameters that we want to pass to the dataTable method as name value pairs..
# Posted By jackrobin | 18/11/2015 03:56
Bathroom Plumbing's Gravatar Next to actually build our data table object. We simply list any of the parameters that we want to pass to the dataTable method as name value pairs..
# Posted By Bathroom Plumbing | 23/11/2015 00:06
Kelowna Gutters's Gravatar You’ve blown my mind away with these interesting facts you’ve written here. I have to say I have learned a lot of new things today while reading this.
# Posted By Kelowna Gutters | 26/11/2015 02:10
atls certification's Gravatar Well that was a pretty good description on the drop down menu creation in cell which was truly helpful. I too have the same usage of Google docs. You have listed the simple tutorial to go through and implement in my blog
# Posted By atls certification | 28/11/2015 05:07
jaipur to ajmer taxi's Gravatar simple tutorial to go through and implement in my blog. I often use the docs for this blog purpose.
# Posted By jaipur to ajmer taxi | 29/11/2015 23:05
This Site's Gravatar It is a great website and nice share. I want to thank you. Good job! You guys do a great blog, and have some great contents. Keep up the good work!
# Posted By This Site | 14/12/2015 22:34
cccam server's Gravatar Providence Saint Joseph is one of the largest providers of cancer care in the San Fernando Valley and has an excellent record of positive treatment outcomes...
# Posted By cccam server | 17/12/2015 00:11
packers and movers Indore's Gravatar Get a wide range of packing and moving companies at helloenquiry.in. We endeavour to furnish the best packers and movers companies in Indore at ease of Internet.
http://helloenquiry.in/packers-movers/packers-and-...
# Posted By packers and movers Indore | 22/12/2015 02:43
Online Dental's Gravatar I basically need to tell you that I am new to weblog and absolutely delighted in this site page...
# Posted By Online Dental | 22/12/2015 22:24
Unlock Her Legs's Gravatar Most of the time I don’t make comments on websites, but I'd like to say that this article really forced me to do so. Really nice post!
# Posted By Unlock Her Legs | 04/01/2016 00:57
Dong Drury's Gravatar It is so easy to create drop-in box with your steps in Google Spreadsheets. More at http://buybestmaleenhancementpills.com/
# Posted By Dong Drury | 04/01/2016 19:46
Show Boards's Gravatar I’m now working with WordPress for a couple of with this blogs and forums nonetheless wanting to switch one of them over to your stand akin to you for a trial offer perform.
# Posted By Show Boards | 04/01/2016 22:15
Kyle Fewings's Gravatar Thanks for providing great instructions on providing detailed tutorials on how to create drop down lists in Google Spreadsheets. I use it at http://vigrxoilexposed.com/
# Posted By Kyle Fewings | 05/01/2016 19:16
Hilda Bissonnette's Gravatar I just want to see you have provided great tutorials. I will surely use it at http://thevigrxplusreview.com/
# Posted By Hilda Bissonnette | 06/01/2016 19:53
The Bonding Code's Gravatar It was a wonderful chance to visit this kind of site and I am happy to know. thank you so much for giving us a chance to have this opportunity...
# Posted By The Bonding Code | 06/01/2016 23:36
Tree Care's Gravatar Good website! I truly love how it is easy on my eyes it is. I am wondering how I might be notified whenever a new post has been made. I have subscribed to your RSS which may do the trick? Have a great day!
# Posted By Tree Care | 07/01/2016 00:33
sanjay's Gravatar Nice article.
Cheers.
http://www.proxycle.com/12345proxy/
# Posted By sanjay | 08/01/2016 21:25
Victorino Noval Foundation's Gravatar I thought it was going to be some boring old post, but it really compensated for my time. I will post a link to this page on my blog. I am sure my visitors will locate that extremely useful...
# Posted By Victorino Noval Foundation | 11/01/2016 00:51
taxi from jaipur to ajmer's Gravatar but it really compensated for my time. I will post a link to this page on my blog. I am sure my visitors will locate that extremely useful...
# Posted By taxi from jaipur to ajmer | 11/01/2016 01:44
Cubase Free Download Full Version's Gravatar Very good points you wrote here..Great stuff...I think you've made some truly interesting points.Keep up the good work.
# Posted By Cubase Free Download Full Version | 12/01/2016 03:28
subscription box reviews's Gravatar I’ve been thinking about writing a very comparable post over the last couple of weeks. I’ll probably keep it
# Posted By subscription box reviews | 12/01/2016 22:50
buy instagram followers's Gravatar This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value. Im glad to have found this post as its such an interesting one! I am always on the lookout for quality posts and articles so i suppose im lucky to have found this! I hope you will be adding more in the future...
# Posted By buy instagram followers | 20/01/2016 01:13
[Add Comment]
Back to top
Subscribe
Enter your email address to subscribe to this blog.


Associated links