Working with remote and in-office colleagues? Learn how to thrive in hybrid work environments.

Get started with Sheets

Add content to your spreadsheet

Want to get more out of Google apps at work or school?  Sign up for a free Google Workspace trial


Now that you have a spreadsheet open, you can start working in it. Sheets automatically saves every change you make.

In this section, you learn how to:

Enter and edit your data


1 Rename your spreadsheet: Click Untitled spreadsheet and enter a new name.
2 Enter text or data: Click a cell and enter text.
3 Insert more items: Click Insert and add charts, images, drawings, functions, notes, and more.

Rename a sheet at the top, add text to the cells, and use the menu to insert an item

Note: You can also add a function to a cell by typing =. To see which functions are available, see the Google spreadsheets function list.

Customize your spreadsheet


Select cells in your spreadsheet and then format them using the toolbar options.

"""""" Undo or redo your last changes or print your spreadsheet.
"" Copy formatting from any text and apply it to another selection of text.
Format your data Format your data as currency or a percentage, change decimal places, and more.
Arial "" | 10 "" Change font or font size.
"""""""" Make text bold or in italics, strikethrough text, or change the text color.
"" Add or change the color of cells.
"" Add or edit cell borders.
"" Merge cells.
Change text alignment Change the text alignment, how text wraps, or rotate text.
"" "" "" Insert links, comments, or charts.
"" Filter your data.
Add functions.

Work with rows, columns, and cells


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 celland thenInsertand thenchoose where to insert the new entry.

Delete, clear, or hide rows and columns: Right-click the row number or column letterand thenDelete, Clear, or Hide.

Delete cells: Select the cells and right-clickand thenDelete cellsand thenShift 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 Dataand thenGroup 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 Viewand thenFreeze and choose an option.

Options 1 through 5 mapped out on a sheet


Work with multiple sheets


Add a sheet:

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

Delete or copy a sheet:

  1. Open the sheet.
  2. At the bottom of your spreadsheet, on the sheet’s tab, click the Down arrow "".
  3. Select Delete or Duplicate.

Find delete, duplicate options in the menu of a tab at the bottom of a sheet

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.

Was this helpful?
How can we improve it?
Get help from Small Business Advisors

Want to receive one-on-one guidance and tailored recommendations on how to make the most out of your Business Profile? Try booking an appointment with Small Business Advisors.

Important: This service cannot troubleshoot issues, including Business Profile verification or suspension, or Google Ads billing.

Clear search
Close search
Google apps
Main menu
Search Help Center