If you’re unsure which account you’re currently using, click your name and see which profile is at the top. Filters and filter views help you analyze a set of data in a spreadsheet. To delete or duplicate a filter view, at the top right, click Options Delete view or Duplicate view. Bring your best ideas to life with Google Workspace with Gemini.
Get started with Sheets for Google Workspace
Google Sheets supports cell formulas typically found in most desktop spreadsheet packages. Functions can be used to create formulas that manipulate data and calculate strings and numbers. Quickly learn how to create and edit a spreadsheet, move to Sheets from another online spreadsheet app, and more. Version history—See all the changes you and others have made to the spreadsheet or revert to earlier versions. 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.
4 Add a Sheets desktop shortcut (Windows only)
Using Google products, like Google Docs, at work or school? Learn to work on Office files without installing Office, create vegas casino dynamic project plans and team calendars, auto-organize your inbox, and more. If you’re not using Chrome, follow your browser’s instructions to bookmark sheets.google.com.
How to use Google Sheets
Get tips & real-life use cases for using gen AI at work. To remove all filters, go to each filter view and click Options Delete view. Here’s a list of all the functions available in each category. When using them, don’t forget to add quotation marks around all function components made of alphabetic characters that aren’t referring to cells or columns.
- Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.
- Functions can be used to create formulas that manipulate data and calculate strings and numbers.
- Lookup Searches down the first column of a range for a key and returns the value of a specified cell in the row found.
- Math Returns the sum of a series of numbers and/or cells.
- Here’s a list of all the functions available in each category.
Tips to analyze your data
With Google Sheets, you can create and edit spreadsheets directly in your web browser—no special software is required. Multiple people can work simultaneously, you can see people’s changes as they make them, and every change is saved automatically. On a computer, you can filter data so the filtered data only applies to your view of the spreadsheet. To learn how to access files offline from your desktop or mobile, see Access stored Drive files without the internet. To learn how to access files offline from your desktop or mobile, see Access stored Drive files without the Internet. When you turn on offline access, your most recent files are automatically saved for offline use.
- Using Google products, like Google Docs, at work or school?
- To get an example spreadsheet and follow along with the video, click “Make a Copy” below.
- When using them, don’t forget to add quotation marks around all function components made of alphabetic characters that aren’t referring to cells or columns.
- Multiple people can work simultaneously, you can see people’s changes as they make them, and every change is saved automatically.
- Google Sheets supports cell formulas typically found in most desktop spreadsheet packages.
You can share files and folders with people and choose whether they can view, edit or comment on them. You can also create new spreadsheets from the URL sheets.google.com/create. Google Sheets is an online spreadsheet app that lets you create and format spreadsheets and work with other people. Lookup Searches down the first column of a range for a key and returns the value of a specified cell in the row found. Lookup Returns the content of a cell, specified by row and column offset. Once filtered, at the bottom right users can find the number of rows being displayed out of the total rows in the table.
Filter your data
Math Returns the sum of a series of numbers and/or cells. Statistical Returns the average of a range that depends upon multiple criteria. To get an example spreadsheet and follow along with the video, click “Make a Copy” below. You can change the language of Google Sheets functions between English and 21 other languages. If you’re using Microsoft Windows, you can add a shortcut to Sheets on your desktop.