| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ||||||||||
| 2 | Monthly Budget | |||||||||
| 3 | Category | Budget | Actual | Difference | ||||||
| 4 | Housing | ,500 | ,450 | $50 | ||||||
| 5 | Food | $500 | $620 | - 20 | ||||||
| 6 | Transportation | $300 | $275 | $25 | ||||||
| 7 | Utilities | $200 | $210 | - 0 | ||||||
| 8 | Entertainment | 50 | 80 | -$30 | ||||||
| 9 | Savings | $350 | $350 | $0 | ||||||
| 10 | Total | $3,000 | $3,085 | -$85 | ||||||
| 11 | ||||||||||
| 12 |
Formula Help
Common Formulas
-
SUMAdds all the numbers in a range of cellsExample: =SUM(A1:A10)
-
AVERAGEReturns the average of its argumentsExample: =AVERAGE(B2:B10)
-
COUNTCounts the number of cells that contain numbersExample: =COUNT(C1:C20)
-
MAXReturns the maximum value in a set of valuesExample: =MAX(D5:D15)
-
MINReturns the minimum value in a set of valuesExample: =MIN(E1:E100)
Recently Used
Rename sheet
Spreadsheet settings
Locale settings
Display settings
Display cell formulas instead of calculated results
Display cell borders in the spreadsheet
Display row numbers and column letters
Default view
Google Sheets Help
Help topics
Getting Started with Google Sheets
Create a new spreadsheet
Start a new spreadsheet from your computer, phone, or tablet. You can create, view, edit, and share spreadsheets wherever you are.
To create a new spreadsheet:
- Go to sheets.google.com
- Click on the + button in the bottom right
- Or, from Google Drive, click on + New and select Google Sheets
Navigating the interface
The Google Sheets interface has several key components that allow you to work efficiently with your data.
Menu bar
Access all features and commands through the menu options at the top of the screen.
Formula bar
View and edit the contents of the selected cell, including formulas and calculations.
Cell grid
The main spreadsheet area where you enter and organize your data.
Sheet tabs
Create and navigate between multiple sheets within a single spreadsheet file.
Popular keyboard shortcuts
| Action | Windows/Chrome OS | Mac |
|---|---|---|
| Copy | Ctrl + c | ⌘ + c |
| Paste | Ctrl + v | ⌘ + v |
| Undo | Ctrl + z | ⌘ + z |
| Redo | Ctrl + y | ⌘ + y |
| Find | Ctrl + f | ⌘ + f |
Video tutorials
Google Sheets Introduction
Watch this tutorial to learn the basics of Google Sheets.
View video tutorial →