Use Google Forms, to can email questions and data to others and it will automatically fill in your spreadsheet, making it very easy to collect information.
Revert to an earlier version. If you’re sharing access to a document in Google spreadsheets, you might want to go back to an earlier version before someone made changes. The program makes that simple. Click on File and then revision history to make changes.
- Chat while editing. Because Google has many integrated features, you can chat with your classmates, research subjects or professors while you chart data.
- Insert a formula. Formulas can make you life a whole lot easier, allowing you to perform functions on a cell or a group of cells to better organize and analyze your data.
- Spice it up with gadgets. Why stick with a boring old spreadsheet when you can spice things up with some gadgets? Try out a few to make your data much more visually appealing.
- Track your finances. If your spreadsheet is related to the stock market, then Google makes things pretty simple by integrating Google Finance with Google Spreadsheets.
- Google search inside a spreadsheet. Think of a question while you’re working on your spreadsheet? Get answers without ever leaving it with a feature that lets you use Google search right within your document.
- Color code it. If you want to better organize your data, colors can be a big help. With Google Spreadsheets, it’s simple to color code and highlight just about anything you want. If you want to get fancy, you can have these colors automatically change within a given set of guidelines.
- Track changes. Whether you’re working with a group or on your own, it can be useful to track your changes as you go. You can see them in a list or receive emails each time a change is made.
- Essential for working with Google Spreadsheets.
- Ctrl+A: Hit these keys and you’ll select all the data in your spreadsheet.
- Ctrl+S: While Google Spreadsheets has an autosave function, you’ll still want to save using this shortcut as well.
-
- Ctrl+W:
- Ctrl+Shift+S: If you need more than one copy of your spreadsheet, this combination of keys will let you easily make a duplicate.
- Ctrl+O: To get started with work, use this shortcut to open an existing document.
- Ctrl+P: Sometimes you just need a hard copy to look at. Hit these keys to print one.
- Ctrl+N: Start a new project by using this shortcut which brings up a new document.
- Ctrl+Z: Made a mistake? No problem, simply undo the changes using these keys.
- Ctrl+Y: Want to undo that undo? Hit control and Y to redo any action again.
- http://www.onlinecollege.org/2011/05/03/50-fantastic-google-spreadsheet-shortcuts-for-students/
When you’re done with your work, hit control and the W key to close the document.
Related:
- These tools will help you do everything from learning how to finance your education to getting the best deals on the books for your classes.
- http://www.onlinecollege.org/2009/08/25/100-free-and-essential-web-tools-for-the-college-bound/
- Mobile Editing.
- Google has enabled many of the same mobile editing capabilities in Google Docs, for Google Spreadsheets.
You can now edit Google Spreadsheets in 45 languages on Android, IPhone and IPad devices.

Leave a Reply