Google spreadsheets auto fill & lookup

Google docs has a couple hidden features that are really cool.

Auto fill

Google spreadsheets can predict patterns and complete them for you.

For example; if I type into one column the following words:

1.Type words 2. Select cells 3. Hold alt key & drag handle down to auto complete the pattern.

Google Lookup:

Google can lookup information on the web and bring into your spreadsheet.

In the example below I used the auto fill to enter my states into the column A. Then I entered the following formulas: =GoogleLookup("entity", "attribute")

Repeat steps for autofill (ctrl + click & drag)

The end result is a spreadsheet full of data that would've taken me an hour or so to lookup and transfer into my spreadsheet.

Give it a try and pass on any other tricks that you find in Google docs.