Create your first spreadsheet

1. On your computer, open a Google Docs, Sheets, Slides, Forms or Vids  home screen.
2. 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.

If you have existing files, you can import and convert them to Docs, Sheets, or Slides.

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

At the bottom of your spreadsheet, click Add sheet  to add another tab.

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

Add rows, columns, and cells:

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

Delete, clear, or hide rows and columns:

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

Delete cells:

1. Select the cells.
2. 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:

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

Group rows or columns:

1. Select the rows or columns. 
2. 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.

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

Note: You may see suggested formulas and ranges based on your data.

A function help box will be visible throughout the editing process to provide you with a definition of the function and its syntax, as well as an example for reference. If you need more information, click the “Learn more” link at the bottom of the help box to open a full article.

Use Gemini to generate & organize content

You can use this feature only if your organization supports it. For help, contact your administrator.

_{Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated.}