How to Open Google Sheets
To get started with Google Sheets, you’ll need to sign up for a free Google account, and access Google Drive, where you can create and organize your spreadsheets. Google Drive is where you create, store, and organize all of the Google Sheets spreadsheets that you work with.
How to Create a Spreadsheet in Google Sheets
You can create a new spreadsheet in Google Sheets in two ways: Either create a blank spreadsheet, or start with a template to save time. Whichever method you use to create a new spreadsheet, it’ll open a new window where you can start working inside the document.
Creating a Black Spreadsheet
The first method to create a blank spreadsheet in Google Sheets is to select New in the upper left corner of the Google Drive window, and then select Blank spreadsheet.
Using a Spreadsheet Template
To save some time, you can start with a spreadsheet template. To do this select New > Google Sheets > From a template to open a Template Gallery where you can select pre-formatted spreadsheets to get started. Pre-formatted templates include:
CalendarsTo-do listsBudgetsTravel and wedding plannersTime sheetsFinancial statementsMuch more
How to Edit Google Sheets Data
Editing data in a Google Sheets spreadsheet is very easy. However, there are a few important tips to keep in mind. These tips include how to edit cell data and how to add or delete rows and columns, adding new sheets, and adding charts.
Using Formulas in Google Sheets
In Google Sheets, you have access to a library of spreadsheet functions that’s just as extensive as anything you’ll find in Microsoft Excel.
Delete row or Delete column: Remove the row or column and shift the remaining cells up or left to fill in the gap.Insert 1 above or Insert 1 below: Insert a new row above or below your selected row.Insert 2 left or Insert 1 right: Insert a new column to the left or right of your selected column.
Using Google Sheets functions, you can average entire rows or columns of cells, find max or min values, or even import data from web pages.
How to Share a Spreadsheet
Once you’ve created your first spreadsheet, you may want to share it with others. Here are a few ways to share a Google Sheets spreadsheet.
Can edit: The recipient can view, make changes, and leave comments on the spreadsheet.Can view: The person can read the spreadsheet but not make any changes or comments.Can comment: The collaborator can read and leave comments.
