RSS Feed
Knowledgebase : Google > Apps > Google Spreadsheets
 

_ADD A NEW SHEET_ You might have multiple spreadsheets for a given project. For example, a travel company planning a tour might create separate spreadsheets for tour dates, customers, transportation, hotels, excursions, and so on. A convenient wa...
_ADD A ROW OR COLUMN_ * Select any cell that should be next to the new row or column. * On the menu bar, click Insert and then choose where to add your row or column. Tip: To add multiple rows or columns at one time, first select the number of r...
ADD A TRENDLINE TO A CHART You can see patterns in your data by adding trendlines to charts in Google Sheets. Trendlines are often helpful for financial or scientific data. You can add trendlines to scatter plot, line, column, and bar charts. ADD...
CONDITIONAL FORMATTING Conditional formatting is a way to change the text and/or background color if certain conditions are met. To do so select a cell (or group of cells) you wish to add formatting to by selecting FORMAT in the menu bar and clicking ...
_CREATE A SPREADSHEET_ From your Docs list, click the Create button and select Spreadsheet. Tip: Don't forget to rename your new spreadsheet. To do so, just click the name (which should be "Untitled spreadsheet" at this point).
_DELETE A ROW OR COLUMN_ * Select one or more cells in the row or column you want to delete. If you select multiple cells, you can delete multiple rows or columns at a time. * On the menu bar, click Edit and then choose which rows or columns to d...
You can set notifications to find out when other people have modified your spreadsheets, and be informed of what they have modified. You can also choose how often you'd like to be notified. To Set Notifications * Open the spreadsheet that you wan...
EMAILING COLLABORATORS IN A GOOGLE DOCUMENT When working on a document with others, one option for communicating is to leave comments. If you would rather communicate through email with all or just some of the document collaborators, Google allows you...
REVISION HISTORY Google Docs, Sheets, and Slides have a revision history pane that allows you to view at a glance all changes made to a document by each collaborator. While it may not work exactly like a track changes tool, the revision history tool l...
_FORMAT DATA IN YOUR SPREADSHEET_ To enter text or data in your spreadsheet, just click a cell and start typing. By default, data is entered in "Normal" format, which means no special formats are used - what you type is what you get. Use the menu...
_FUNCTIONS_ Functions make calculations easy and automatic. Access functions from the summation sign on the Edit toolbar (alternatively, click Insert > Functions from the menu toolbar). You'll have immediate access to some of the most common formula...
HIDE GRIDLINES If you want to hide the gridlines in your spreadsheet so that the sheet looks blank (the way it will look if printed) then follow these steps: * Open VIEW from the menu bar * uncheck GRIDLINES
For an instructional video that covers the basics of Google Drive, including file management, creation of files, and sharing files, go to https://www.youtube.com/watch?v=6NLYbzXVJaY [1] 1/9/2015 pg Links: ------ [1] https://www.youtube.com/wa...
This is the same as "freezing panes" in Microsoft word. _KEEP HEADER ROWS AND COLUMNS IN PLACE_ Your first rows or columns might be headers that you want to always keep at the top or left as you scroll through your spreadsheet. In that case, you'...
_MOVE A ROW OR COLUMN_ You can use Copy and Paste (on the Edit or right-click) menu to move cells, but here's a quicker way: * Select the cell or block of cells that you want to move. * Move your cursor to the edge of the selected cells, until...
If you need to print labels from Google Docs, there is a add-in that you can add to Google Docs called "Avery Label Merge." The add-on will allow you to create a mail merge by entering names and/or address information into a Google Sheet, and then use the...