How do I color code cells so they automatically adjust as I enter data?Select/highlight the cells that you want to color code. Select Conditional formating under Format. Format can be found across the top tool bar. Click the Text Contains box within the window that popped open. Choose the verbage that best describes the action you want to take. Click the small box to the left of Background (still within the box that popped open). Select the color you would like to use. Click Add another rule (still within the box that popped open). Select the verbage that best describes the next action you want to take. Select the background color for this action. Continue until all additional rules are entered.
How do I freeze columns or rows?
Freezing rows and columns allows you to keep some of your data in the same place as you scroll through the rest of your spreadsheet. This is particularly useful if you have headings or labels that you'd like to keep in one place as you scroll through a large data set.
You can freeze up to ten rows or five columns in any particular sheet. Here's how:
To unfreeze rows or columns, follow these steps:
How do I add columns?
To add a column to a spreadsheet, click on the gray area containing the column letter. Select the action that you'd like to complete from the drop-down menu (upside-down triangle). For example, to insert a blank column to the left of the column you selected, you'd select Insert 1 left from the drop-down menu. To delete a row or column, select Delete column from the drop-down menu.
How do I add rows?To add a row to a spreadsheet, click on the gray area containing the number of the row. Select the action that you’d like to complete under INSERT. INSERT can be found across the toolbar at the top of the page. Select Insert above or Insert below to meet your needs.
Are you interested in learning something specific not listed here in Google Docs/Calendar/Sites? Contact Matt Townsley or Kathy Kaldenberg to setup one-on-one training. Customized, self-paced tutorial videos can also be created to fit your needs.