Google Sheets (Web/PC Version)

Google Sheets is a spreadsheet program, like Microsoft Excel, only web-based, so everything saves automatically on the web, and you can access it on any device with internet access.
You use Google Sheets in a web browser; Google Chrome browser works best. Click the Apps bookmark in the top left corner, then choose Sheets. Or go to https://sheets.google.com.
If you go the Google Sheets website, it will give you a list of Sheets files you have stored in your Google Drive, organized by when you last opened them, so if you're returning to the same Sheets file frequently, that can be an easy way to find it.
You can also search for a Sheets file by name, using the magnifying glass in the search bar across the top.
You can also open a Sheets file by finding it in your Google Drive.

Google Sheets on Computers

Add a Spreadsheet

Use the plus sign in the top left corner to start a new spreadsheet file.
Another option is to choose a template for your document.
Type the title for your spreadsheet where it says "Untitled spreadsheet."
Start typing in your spreadsheet.

Enter Text

Click on a cell to start entering text in that cell. When you finish, you can hit Enter to go to the next row down, or you can hit Tab to go to the next column over, or you can click on another cell.
If you need a spreadsheet with multiple tabs, click the plus sign in the bottom left corner to add tabs.

Formatting Options

Formatting options are across the top of your screen.

Hover over each icon to see what it does.
Text options include font, text size, bold, italic, underline, color, alignment, rotation, and text wrapping.
You can change the format of specific cells and numbers in the spreadsheet.
You can insert links, comments, and charts.
Other options include an undo and redo button, printing, zoom in or out, and adding formulas to the spreadsheet.

Work Offline

If you want to be able to work on your spreadsheet someplace where you don't have internet access, just make it available offline:

Click on the File menu in the top left corner.
Choose Make available offline.

In-depth Tutorial

If you want more information, you can view this in-depth tutorial at https://www.youtube.com/watch?v=cVLXkMC8-x8 . However, keep in mind that it is not specific to CPS Google accounts, so some things may be different from our CPS Google setup.

Page updated

Report abuse