What can you do with Sheets?
Handle task lists, create project plans, analyze data with charts and filters, and much more.
With Google Sheets, you can create and edit spreadsheets right in your web browser—no special software is required. Even better, multiple people can work at the same time, you can see people’s changes as they make them, and every change is saved automatically.
What you’ll need:
Google Apps account
10 minutes
Create a new spreadsheet
From the Sheets homepage: Click Create new spreadsheet
From Google Drive: Click New > Google Sheets.
Import and convert old spreadsheets to Sheets
If you have an existing spreadsheet you created in another program, you can easily import and convert it to Sheets.
Go to Drive.
Click New > File Upload.
Choose the existing spreadsheet from your computer to add it to Drive. Supported files include .xls, .xlsx, .xlt, .ods, .csv, .tsv, .txt, and .tab.
In Drive, right-click the spreadsheet you want to convert.
Select Open with and choose Google Sheets.
Converting your spreadsheet from another program creates a copy of your original file in the Sheets format. You can then edit it in your browser like any other Sheet.
Have an Excel spreadsheet?
If you've already stored Microsoft® Excel® spreadsheets in Drive, you can also update them without converting to Sheets:
Enter and edit your data
Rename your spreadsheet: Click Untitled spreadsheet and type a new name.
Enter text or data: Just click a cell and start typing.
Insert more items: Click the Insert menu to add notes, functions, charts, images, drawings, and more.
Customize formats and fonts
Work with rows and columns
Add rows and columns: Select a cell. Then, on the menu bar, click Insertand choose where to add the row or column next to that cell.
Delete or hide rows and columns: Right-click the row number or column letter and select Delete or Hide.
Move rows and columns: Click the row number or column letter to select it. Then, drag it to a new location.
Freeze header rows and columns: Freeze rows and columns to keep some of your data in the same place as you scroll through the rest of your spreadsheet. On the menu bar, click View. Then, choose an option underFreeze.
Work with multiple sheets
Add a sheet: At the bottom of your spreadsheet, click Add sheet
to add another sheet.
Delete or copy a sheet: Open the sheet. Then, at the bottom of your spreadsheet, on the sheet’s tab, click the Down arrow
, and select Delete orDuplicate.
Share with your team
To share a file you own or can edit:
Open the file you want to share.
Click Share.
Enter the email addresses or Google Groups you want to share with.
Choose what kind of access you want to grant people:
Can edit—Collaborators can add and edit content, or add comments.
Can comment—Collaborators can add comments, but not edit content.
Can view—Collaborators can view the file, but not edit content or add comments.
Click Send.
Everyone you shared with will receive an email with a link to the spreadsheet.
Add comments and replies
If team members aren’t available to collaborate in real time, leave feedback and questions for them to look at later.
Select a cell.
In the toolbar, click Insert comment
.
Add your notes and click Comment.
If a comment is important for a specific collaborator to see, enter + followed by their address. They’ll get an email with your comment, along with a link to the spreadsheet. They can then reply to your comment to answer questions or start a discussion.
When you’re done with a comment, click Resolve.
Print your spreadsheet
To print your spreadsheet, click File > Print or click Print
.
You can choose which sheets to print, what features to include, and which layout you want.
Download versions in other formats
TEXT BOX
To download your spreadsheet so you can open it in other programs, click File >Download as and choose one of the following formats:
Microsoft Excel (.xlsx)
OpenDocument format (.odt)
Adobe® PDF document (.pdf)
Comma-separated values (.csv)
Tab-separated values (.tsv)
Web page (.zip)
Make a copy in Sheets
Copying a spreadsheet is useful for creating templates. For example, if you write a lot of project plans, make copies of one plan. Then, update each copy for a new project without having to format it again.
To make a copy of your spreadsheet, click File > Make a copy. You can rename the copy and optionally share it with the same collaborators.
Email a copy as an attachment
TEXT BOX
If you need to collaborate with someone on your spreadsheet in your old program or format, such as PDF or Excel, you can email it as an attachment.
Click File > Email as attachment.
Select a format.
Enter the email addresses or Groups you want to send copies to.
(Optional) Enter a message.
Click Send.
Note: This sends a copy of the spreadsheet instead of sharing the original, so you won’t be able to use Sheets’ collaboration tools.