Google Sheets
Getting Started
Use the links below to find out more what you need to know in Google Sheets during your first few days in Google Workspace.
All Google docs, sheets and slides are listed on the Drive Home page - with an indicator showing the document type e.g. document, presentation, spreadsheet, form, etc. The document name will show, along with the owner of the document and the date on which it was last modified.
If you know you are going to collaborate on a spreadsheet before you start work on the sheet, you can create it from scratch in Google Drive. Once you have created a new sheet, you can add content and name the sheet as required...
Google provides a number of templates that you can use to form the basis of your sheets. You can create a new sheet based on a template, then edit the sheet as required.
When you create a Google Sheet, or import a spreadsheet into My Drive, only you will be able to access the sheet. You can share a sheet with everyone in your organisation, or with specific people only. Alternatively, you can remove all restrictions to the sheet, allowing anyone on the...
If you have shared a Google Sheet with colleagues, then open the sheet, you will be able to see at a glance if anyone else is working on the sheet at the same time. You can chat with collaborators using the pane on the right-hand side of the screen...
When you are working in a Google Sheet, all changes will be recorded, regardless of who they were made by. This allows you to view old versions and revert to an earlier version if changes have since been made in error...
As well as viewing the revision history of the sheet as a whole, you can right-click over a cell to see the edit history of that cell only, and to toggle through all of the edits made to that cell over time...
If you wish to collaborate on a sheet and save any messages sent to other users, comments should be used. You can add a comment to any part of a sheet, and other colleagues working on the sheet can add replies. Once the comment has been actioned, it can be marked as resolved...
You can set notifications to find out when other people have modified your spreadsheets, and learn what they've modified. You can also choose how often you'd like to be notified i.e. as soon as a change is made, or to receive a summary of changes each day...
Shortcuts for adding data in sheets
Google Sheets offers many shortcuts for entering data into a Sheet...