reseize logo;

Who is what? What is where? Where am I? Are you there?

You have hit the other collection, a newslog designed for the curious.

Tuesday, August 05, 2008

Get Auto-complete in Your Google Spreadsheet

Are you using Google Spreadsheets as your web-based spreadsheet editor alternative to desktop programs like Excel? If you do, give the "magic" auto-completions a try. To understand what this does, enter "Superman" in the top left cell, and enter "Batman" and "Wonder Woman" in the cells below. Now select all three cells you created. Hold down the Ctrl key, and drag the bottom right corner of the selection downwards over the other cells. Notice something? Your list is now continued with entries like "spider man", "x men", "green lantern". (Admittedly, not all continuations make sense—"star wars"?—but where would be the fun in magic without surprises.)What's happening here? Well, the Google Labs have a member called Google Sets. (Being from 2002, it's the oldest member still listed in the Labs, too.) This tool automatically expands a given set of items. Like "Batman" and "Superman", but also anything else that could be thought of as a group. For instance, entering "google" and "yahoo" also shows "altavista", "lycos" and "msn". Entering "tom cruise" and "nicolas cage" yields "brad pitt", "angelina jolie", "johnny depp" and others.
This was seized 4 u at Lifehacker
tags: ,,,