Sheets

Create a new spreadsheet

From the Sheets homepage: Click Create new spreadsheet .

From Google Drive: Click New > Google Sheets > Blank spreadsheet or From a template.

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.

Enter and edit your data

Rename your spreadsheet: Click Untitled spreadsheet and type a new name.
Enter text or data: Click a cell and start typing.
Insert more items: Click Insert and add notes, functions, charts, images, drawings, and more.

Note: To see which functions are available, see the Google spreadsheets function list.

Customize formats and fonts

In your spreadsheet, select the cells you want to customize, then use the menus and toolbar to change their formats.

Work with rows, columns, and cells

Add rows, columns, and cells—Select a cell or block of cells. Then, on the menu bar, click Insert and choose where to add the row, column, or cells.
Delete or hide rows and columns—Right-click the row number or column letter and select Delete or Hide.
Delete a cell or a block of cells—Select the cells you want to delete. Click Edit > Delete cells and shift up, or Edit > Delete cells and shift left.
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—Keep some data in the same place as you scroll through the rest of your spreadsheet. On the menu bar, click View > Freeze and choose an option.

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 add, and selectDelete or Duplicate.

Add comments and replies

If team members aren’t available to collaborate in real time, leave feedback and questions for them to see 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 addfollowed 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.

Sharing and Collaborating - See the Docs Page

Download versions in other formats

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)

Email a copy as an attachment

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.

Google Sites

Report abuse