Google Sheets
With Google Sheets, everyone can work together in the same spreadsheet at the same time. Use formulas, functions, and formatting options to save time and simplify common spreadsheet tasks.
As the creators of Google Sheets, Google creates the best help information on the subject. We’ve curated a list of commonly asked questions to help you get answers faster. If the answer you’re looking for isn’t here, take a look at Google’s full help topics on Google Sheets.
Get started with Google Sheets
- How to use Google Sheets
- Switch to Google Sheets from Microsoft Excel
- Create, view, or download a file
- Create a file from a template
- Edit and format a spreadsheet
Edit and format a spreadsheet
- Edit and format a spreadsheet
- Add or move columns and cells
- Freeze or merge rows and columns
- Protect, hide, and edit sheets
- Format numbers in a spreadsheet
Use functions and formulas
- Google Sheets function list
- Add formulas and functions
- See the sum and average
- IF function
- QUERY function
Work with data
- Create and use pivot tables
- Customize a pivot table
- Reference data from other sheets
- Using arrays in Google Sheets
- Import data sets and spreadsheets
Sort, filter, or format data
- Sort and filter your data
- Create an in-cell dropdown list
- Use conditional formatting rules in Google Sheets
- Split text, remove duplicates, or trim whitespace
- Add and use checkboxes
Create and edit charts
Benefits
- G Suite for Education core services
Service availability
24/7