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.

2 Answers 2


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

WA434 example


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.

  • 3
    Just a quick update: Creating drop down menus for data validation is now supported in Google Spreadsheets. Oct 16, 2010 at 4:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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