Get Started with Sheets

Modified on Thu, 7 Aug at 11:56 AM

Create your first spreadsheet

Create or import a spreadsheet

Create and name your spreadsheet

On your computer, open a Google Docs, Sheets, Slides, Forms or Vids home screen.
Click Create .

You can also:

Create a file from template
Use a template in Google Vids

At the top of the page, click Untitled document and enter a new title.

Import and convert an existing spreadsheet

Go to Drive.
Click NewFile Upload.
Choose the file you want to import from your computer to add it to Drive.
In the Upload complete window, click Show file location .
Right-click the file and select Open withGoogle Docs/Sheets/Slides.

Add or update content in a spreadsheet

Add or update data

Open a spreadsheet in Google Sheets.
Click a cell that’s empty, or double-click a cell that isn’t empty.
Start typing.
Optional: To add another line within a cell, press ⌘ + Enter on a Mac or Ctrl + Enter on Windows.
When you’re done, press Enter.

Organize data

Add rows, columns, and cells:

Select the row, column, or cell near where you want to add your new entry.
Right-click the highlighted row, column, or cellInsertchoose where to insert the new entry.

Delete, clear, or hide rows and columns:

Right-click the row number or column letter.
Click Delete, Clear, or Hide.

Delete cells:

Select the cells.
Right-clickDelete cellsShift left or Shift up.

Move rows or columns: Select the row number or column letter and drag it to a new location.

Move cells:

Select the cells.
Point your cursor to the top of the selected cells until a hand appears.
Drag the cells to a new location.

Group rows or columns:

Select the rows or columns.
Click ViewGroupGroup rows or Group columns.

Freeze header rows and columns: Keep a row or column in the same place as you scroll through your spreadsheet. On the menu bar, click ViewFreeze and choose an option.

Add formulas or functions

Open a spreadsheet.
Type an equal sign (=) in a cell and type in the function you want to use.

Use Gemini to generate & organize content

On your computer, open a spreadsheet in Google Sheets.
At the top, click Ask Gemini .
Select a prompt or create your own. For example:
- “Create a framework for researching a sales prospect to prepare for a customer meeting.”
- “Set up a task tracker to build a new website.”
- “Plan a kick-off event for the sales team.”
Press Enter.
Choose an option:
- To add the table to your spreadsheet, click Insert .
- To create a different version of the table, click Retry .
Click Good suggestion for a table that fulfills your request or Bad suggestion for a table that does not meet your needs.
When you’re finished, click Insert.

Share & collaborate on a spreadsheet

Share a spreadsheet with specific people

Select the file you want to share.
Click Share or Share .
Enter the email address or Google group you want to share with.
To decide what role people will have on your file, select Viewer, Commenter, or Editor.
If your account is eligible, you can add an expiration date for access.
Choose to notify people.
- If you want to notify people that you shared an item with them, check the box next to Notify people. If you notify people, each email address you enter will be included in the email.
- If you don't want to notify people, uncheck the box.
Click Send or Share.

Share a link to a spreadsheet

You can choose if your file should be available to anyone or restricted to only the people with access. If you allow access to anyone with the link, your folder won't restrict who can access it.

Select the file you want to share.
Click Share or Share .
Under “General access”, click the Down arrow .
Choose who can access the file.

Tip: If you use your Google account for work or school, you can choose to only share files and folders with a specific audience, like your department. You might find a description of each audience when you hover over the group name.

To decide what role people will have with your file, select Viewer, Commenter, or Editor.
Click Done.

Unshare a spreadsheet

Stop sharing a document you own

Find the file or folder in Google Drive, Google Docs, Google Sheets, or Google Slides.
Open or select the file or folder.
Click Share or Share .
Find the person you want to stop sharing with.
To the right of their name, click the Down arrow Remove access.
Click Save.

Restrict access to a spreadsheet you own

Find the file or folder in Google Drive, Google Docs, Google Sheets, or Google Slides.
Open or select the file or folder.
Click Share or Share Copy link .
Under “General access”, click the Down arrow .
Select Restricted.
Click Done.

Comment on a spreadsheet

On your computer, open a document, spreadsheet, presentation, or video.
Highlight the text, images, cells, slides, or scenes you want to comment on.
To add a comment, in the toolbar, click Add comment .
Type your comment.
Click Comment.

Chat with collaborators in a spreadsheet

On your computer, open a document, spreadsheet, or presentation.
At the top right, click Show chat . This feature won't be available if you're the only one in the file.
1. Tip: If there are many collaborators in the file, at the top right, to the right of the avatars, there will be a blue circle showing the number of additional collaborators. Click the blue circle Join chat .
Enter your message in the chat box.
When you’re finished, at the top right of the chat window, click Close .