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

1 Answer 1

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

 
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.