Android Enthusiasts Stack Exchange is a question and answer site for enthusiasts and power users of the Android operating system. 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 made a spreadsheet in Google Docs and used data validation to restrict a range of cells to a list of valid values. When I look at the spreadsheet using a browser, the valid list is correctly shown in the dropdown menu. However, when I look at the spreadsheet in my Android phone, I don't see the list (there is a little [1] shown in the cell, but I don't see how to click this.)

Is there any way to make this list display on a phone?

share|improve this question

migrated from Aug 13 '12 at 19:36

This question came from our site for power users of web applications.

Just to clarify, is this being viewed on the phone via the Google Drive (formerly Google Docs) app? – eldarerathis Aug 13 '12 at 19:38
yes. i haven't tried it on an iphone yet, but i'd hope the same solution works there as well. – OracleOfNJ Aug 13 '12 at 19:41

Using the Google Drive App I created a test spreadsheet to investigate your question. I found the [1] to be a footnote - at the bottom of the spreadsheet is a list of all notes about validation for each applicable cell. The same applies to comments made to cells and, I suspect, other types of advanced cell formatting that don't translate well to small screens. It's clunky, but at least the validation follows to mobile. There doesn't seem to be a way to change how validation information is displayed.

See here below the spreadsheet are two footnotes, one indicating valid data (by displaying the help text, [1]) and the other representing invalid data (by displaying "validationFailed[Help Text]," [2]):

enter image description here

share|improve this answer

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.