Create & collaborate with online spreadsheets to analyze data, create project plans, & more—all in your browser.
Get Sheets:Web (sheets.google.com),Android, oriOS
Want advanced Google Workspace features for your business?
Try Google Workspace today!
Work with your data
 | ||
 | Copy formatting from any text and apply it to another selection of text | |
 | Format data as currency, a percentage, change decimal places, and more | |
 | Add or edit cell borders | |
 | Merge cells | |
 | Change text alignment | |
 | Change how text wraps or rotate text | |
 | Add links, comments, charts, filters, or functions | |
Note: To improve compatibility with Microsoft Excel keyboard shortcuts, you can override browser shortcuts.
Add rows, columns, or cells
Add rows, columns, and cells:
- Select the row, column, or cell near where you want to add your new entry.
- Right-click the highlightedrow, column, or cell
Insertchoose where to insert the new entry.
Delete, clear, or hide rows and columns:
- Right-click the row number or column letter.
- ClickDelete, Clear, orHide.
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 DataGroup 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 View
Freeze and choose an option.
Share your spreadsheet
Click Share and choose what collaborators can do. They'll get anemail notification, too.
| Share or unshare | Edit content directly | Add comments | |
|---|---|---|---|
| Editor | ✔ | ✔ | ✔ |
| Commenter | ✔ | ||
| Viewer |
Collaborate with your team
 | | Chat with other people viewing the spreadsheet | |
| Open comments thread | ||
| Share with your team | ||
| Insert comments | ||
Copy, email, or publish your spreadsheet
Make a copy—Create a duplicate of your spreadsheet. This is a great way to create templates.
Download as—Download your spreadsheet in other formats, such as Excel or PDF.
Email as attachment—Email a copy of your spreadsheet.
Version history—See all the changes you and others have made to the spreadsheet or revert to earlier versions.
Publish to the web—Publish a copy of your spreadsheet as a webpage or embed your spreadsheet in a website.
Work with functions
Your most important Excel functions exist in Sheets, too. Here’s a few of the things you can do.
| AVERAGE | Statistical Returns the numerical average value in a dataset, ignoring text. |
| AVERAGEIFS | StatisticalReturns the average of a range that depends upon multiple criteria. |
| CHOOSE | LookupReturns an element from a list of choices based on index. |
| COUNT | Statistical Returns the count of the number of numeric values in a dataset. |
| COUNTIF | StatisticalReturns a conditional count across a range. |
| DATE | DateConverts a provided year, month, and day into a date. |
| FIND | TextReturns the position at which a string is first found within text. |
| GETPIVOTDATA | Text Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings. |
| IF | Logical Returns one value if a logical expression is true and another if it is false. |
| INDEX | Lookup Returns the content of a cell, specified by row and column offset. |
| INT | Math Rounds a number down to the nearest integer that’s less than or equal to it. |
| LOOKUP | Lookup Looks through a row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column. |
| MATCH | Lookup Returns the relative position of an item in a range that matches a specified value. |
| MAX | Statistical Returns the maximum value in a numeric dataset. |
| MIN | Statistical Returns the minimum value in a numeric dataset. |
| NOW | Date Returns the current date and time as a date value. |
| ROUND | Math Rounds a number to a certain number of decimal places according to standard rules. |
| SUM | Math Returns the sum of a series of numbers and/or cells. |
| SUMIF | Math Returns a conditional sum across a range. |
| TODAY | Date Returns the current date as a date value. |
| VLOOKUP | Lookup Searches down the first column of a range for a key and returns the value of a specified cell in the row found. |
Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companieswith which they are associated.
Was this helpful?
How can we improve it?
Print, save, or customize Learning Center guides
Learn how to print Learning Center guides, save them as PDFs, or customize them for your organization.
