Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm looking for a way to create a drop-down combobox for a column, so that it easier for data entry. I know about using a form, but are there any other ways to do this in spreadsheet view?

For example, in Excel you can choose Data > Validation... > List. Then when you select a cell, you will see a drop down arrow on the right.

share|improve this question

As mentioned by @Brad Gardner, validation is possible with a drop-down showing acceptable values:

WA434 example

share|improve this answer

To my knowledge, dropdowns in Google Spreadsheets are not yet supported.

Here is a link to a somewhat old groups discussion on it:


Its from 2008, but I don't believe the status on this has changed since then.

share|improve this answer
Just a quick update: Creating drop down menus for data validation is now supported in Google Spreadsheets. – Brad Gardner Oct 16 '10 at 4:02

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.