Print
This List
Email to
a Friend
Google Docs and Spreadsheets Tricks
IDKT 
Tags: google, docs and spreadsheets, tricks, tips, internet
All Google programs seem to have secret functions. Here are some for Google Docs and Spreadsheets. Know any others? Add them here!
| 1. | LIVE LOOKUP VIA GOOGLE & GOOGLE FINANCE (Spreadsheets). Using two special formulas, users can create cells that will update constantly with data or information gleaned from Web searches or Google's finance service (i.e. stock symbols, sports statistics, or any other piece of info you want to source & keep up to date automatically).
To do a Web search for any item in a spreadsheet cell, just right click it. |
| 2. | GOOGLE SEARCH INSIDE A SPREADSHEET. If you find a word or phrase that's unfamiliar, or you want to find out more about it, you can search for it without leaving the page. Just highlight it, right click and choose "Search the Web." The results will open in a new browser window |
| 3. | COLOR-CODED LIVE COMMENTS. If the author or another contributor finds a comment useful, they can add it into the document by right clicking on it and then choosing that option from the contextual menu. Collaborators can also change their comment coloring on the fly, or create their own custom coloring scheme to denote things such as priority. |
| 4. | REVISIONING. Google Docs and Spreadsheets offer the option to keep track of changes that have been made over the course of a document's or spreadsheet's lifespan. You can jump back and forth between edits made on a drop-down timeline menu, or by clicking the "older" and "newer" buttons. The slightly more advanced version of this that's only available in Google Docs is the ability to look at two versions of the same document side by side. The application will highlight the differences, and each revision gets its own color code. |
| 5. | THERE ARE MANY COPIES & THEY HAVE A PLAN. Where is this file being stored, and what if something bad happens? Any document or spreadsheet created on the service is constantly being backed up in several places at once. Google uses the same file system for all of their Web apps, called GFS (Google File System), that's been designed so even if the server in which your file is hosted bursts into flames, the system will automatically switch over to the backup copy. |
Lister:
ListAfterList Wiki Contributors
Source:
Webware
Other lists of interest:
This list not rated yet – be the first to rate it