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 using a Google Spreadsheet to fill in my mileage. Since I'm using many addresses more than once, I want to make the process of filling in easier by (like Excel or Open Office) having the spreadsheet automatically complete my previously-used data.

An example:

 9-5-2013 | home (1033DJ 2)       | customer A (1084BA 6) | 20km | 0 | meeting | Somewhere  
 9-5-2013 | customer A (1084BA 6) | home (1033DJ 2)       | 20km | 0 | meeting | Somewhere                  
10-5-2013 | home (1033DJ 2)       | customer B (1000AA 1) | 70km | 0 | meeting | Somewhere  
10-5-2013 | customer B (1000AA 1) | home (1033DJ 2)       | 70km | 0 | meeting | Somewhere  

Now when I'm writing "home" I'd like to have the spreadsheet autocomplete or suggest "home (1033DJ 2)".

Is this possible? How?

share|improve this question
up vote 1 down vote accepted

You should be able to Enable autocomplete under the Tools menu.

Tools menu

share|improve this answer
haha! that was too easy, @nicholas! my solution was to make an extra row 'H', in which cell 'H1' had a formula '=B1', and have the content of row 'B' validated based by the content of row 'H'. This way it worked as well, but way more complicated as checking 'enable autocomplete'... – Sibe Jan May 14 '13 at 22:26

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.