Google Apps: Sheets

Sheets

Create a Spreadsheet in Google Sheets

1. From within the Google Sheets application click the + icon in the lower right to create a new document.

2. A new Google Sheet spreadsheet appears in your browser—now you're ready to create.

Search for previously created spreadsheets

You can search for a specific spreadsheet that you've created by typing into the search bar and hitting enter.

Google Sheets will search the titles and content of all of your spreadsheets for matching results.

Share and collaborate

Google Sheets lets you easily collaborate with others on spreadsheets in real time.

1. To get started, open the sheet you want to collaborate on and click Share. You will find the share button in the upper-right hand corner of the sheet.

2. Enter the email addresses of the people you want to share with. You can also search for contacts by entering them in the box.

3. Select Can edit.

4. Click Done. The individuals or groups will receive an email letting them know you’ve shared the file with them.

You can work at the same time, or individually, but all changes made to a Google Sheet are saved and displayed whenever you open your spreadsheet.

To track changes to a document choose File > See Revision History

For more on Sharing and Collaboration See Google Sheets Helps for Sharing and Collaboration.

Download Google Sheet spreadsheets as Microsoft Excel files or PDF documents

1. Open a document.

2. Choose File > Download as from the Google Sheets file menu.

3. Click on one of the file types available in the drop-down menu.

4. Choose the location on your computer to save the document.

5. Click Save.

Upload a Google Sheet as an Assignment Submission

1. Open an assignment page from your course home page.

2. Click Add Submission at the bottom of the assignment page.

3. Click the Add document button 

4. Click on Google Drive (The login credentials to your LAPU Google email will be required)

5. Search and Select File

6. Click Select this file

7. Click Save Changes

Upload a Google Sheet as an Assignment Submission with a Mobile Device

1. Open an assignment page from your course home page.

2. Click Add Submission at the bottom of the assignment page.

3. Click the Add document button 

4. Click on Google Drive (The login credentials to your LAPU Google email will be required)

5. Search for and select a file

6. Click Select this file

7. Click Save Changes

Other

Organize your Google Sheet files in Google Drive

• The Google Sheets list can grow exponentially if you use it to create your spreadsheets for class. You can use Google Drive to organize and file all your various Google Documents, Sheets, Presentations, and Drawings.

Insert a Google Drawing into your Google Spreadsheet.

You can use Google Drawing to create graphics for your Google spreadsheet. While inside of a spreadsheet:

1. On the main menu choose Insert > Google Drawing.

2. Use the menu bar to upload an image or add text, lines, or shapes to create your drawing.

3. Once you have completed your "drawing," click Save and Close in the upper-right hand corner.

4. Your new Google Drawing has been added to your document.

Help with creating formulas in Google Sheets

Use the following resources to help you with creating formulas in Google Drive

• Functions and Formulas - Google Sheets Helps

• Google spreadsheets function list