Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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
add comment

2 Answers 2

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

WA434 example

share|improve this answer
add comment

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

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

http://groups.google.com/group/How-to-Documents/browse_thread/thread/115eac535bcc1435

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

share|improve this answer
3  
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
add comment

Your Answer

 
discard

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.