Any online spreadsheets with in-cell drop down value selection (smilar to Excel)

Question

I'm looking for a solution to a fairly everyday problem in MS Excel if you don't use it just for raw data. Data validation and selection using in-cell drop down list (see image)

I've checked online services a while ago and none of them actually supported this. To make this work spreadsheets probably need to support named ranges as well. Since Google spreadsheets now support all kinds of custom functions that can be used and manipulate spreadsheets I wonder whether this can be/has been done?

Why don't I just use Excel?

Because I also need simultaneous collaboration which is very good with online spreadsheet services but actually quite a pain with Excel files. It usually works on per user basis so only one user can have the file open in write mode, all others can only read it. This is not really an option.

Answer 1

The closest thing google docs has is "List View" which lists all values for a column within a table - probably not going to be what you need though.

Apparently SmartSheet can use dropdowns but I have not tried it, and it is not free (though there is a free trial).

Answer 2

I used the new slicer tool as a work around for this on my site in Excel web apps. It's a bit of a mess, I needed a couple of pivot tables in the background to act as the drop down but it works.

download the spreadsheet and unhide the sheets for a better look

Answer 3

Google Spreadsheets has it

I've just checked today and I have to confirm that Google has implemented this feature that works much the same way as in Excel. I can select a range of cells whose values are used in data validation. The best part is they're displayed in an in-cell drop down menu!

YES! Thank you Google.

Few enhancements I'd add:

1. Using a named range to supply values so we won't have to enter values manually or using a range from a different sheet.
2. Select whether cells allow input or are values only able to be selected from a drop down (as a checkbox)
3. Use formatting of source cells when selecting a value (checkbox)