Google Sheets from Zero to One
If you have never opened Google Sheets before, this guide is for you. No formulas assumed, no jargon — just the handful of ideas you need to go from a blank grid to a spreadsheet that actually does something useful.
What Google Sheets actually is
Google Sheets is a grid of boxes called cells, organized into columns (labeled A, B, C…) and rows (labeled 1, 2, 3…). Every cell has an address made of its column and row, like B3 or A1. You can type text, numbers, or a formula into any cell.
| A | B | C | |
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 |
A formula is just an instruction that starts with =. Instead of typing a number, you tell Sheets how to calculate one:
=2 + 2
Type that into a cell and press Enter — it shows 4. That's the whole idea: formulas calculate things for you, and they update automatically when the data they depend on changes.
| A | B | C | |
|---|---|---|---|
| 1 | 4 | ||
| 2 |
Your first real formula
Formulas get useful once they reference other cells instead of typed-in numbers. Say A1 has 10 and A2 has 20. In A3, type:
=A1 + A2
| A | B | |
|---|---|---|
| 1 | 10 | |
| 2 | 20 | |
| 3 | 30 |
A3 now shows 30. Change the value in A1 to 100, and A3 instantly updates to 120. This is the core habit to build: reference cells, don't retype numbers.
Selecting more than one cell: ranges
Most formulas work on a range — a rectangle of cells — rather than one cell at a time. A range is written as first cell:last cell. A1:A10 means "everything from A1 down to A10." A1:C10 means "the whole rectangle from A1 to C10."
| A | B | |
|---|---|---|
| 1 | 5 | |
| 2 | 10 | |
| 3 | 3 | |
| 4 | 8 |
This matters because almost every function below takes a range as input.
The five functions to learn first
You don't need to memorize hundreds of functions to be productive. Start with these:
- SUM — adds up a range.
=SUM(A1:A10)adds everything from A1 to A10. - AVERAGE — finds the mean of a range.
=AVERAGE(A1:A10). - COUNT and COUNTA — count numbers, or count anything non-empty, in a range.
=COUNTA(A1:A10)tells you how many rows have data. - IF — makes a decision.
=IF(A1>10, "High", "Low")shows "High" if A1 is greater than 10, otherwise "Low". - VLOOKUP or XLOOKUP — looks up a value in one place and pulls back matching data from another.
=XLOOKUP(A1, B:B, C:C)finds A1 in column B and returns the matching value from column C.
Once these five feel natural, everything else in the function reference is a variation on the same idea: take a range or value, apply a rule, return a result.
Copying formulas down a column
Write one formula, then drag its bottom-right corner (the little blue square, called the fill handle) down the column — Sheets adjusts the cell references automatically for each row. Row 2's formula referencing A2 becomes row 3's formula referencing A3, and so on. This is how you apply the same logic to an entire dataset without retyping it.
If you want a reference to stay fixed instead of shifting — say, a tax rate stored in one cell that every row should use — add $ before the column and row: $B$1. This is called an absolute reference, and it's the fix for the most common beginner mistake ("why did my formula break when I dragged it?").
Formatting: making data readable
Formulas calculate; formatting makes the result legible.
- Number formats: select a range and use the toolbar to show values as currency, percentages, or dates, without changing the underlying number.
- Conditional formatting (
Format > Conditional formatting): automatically color cells based on their value — red for below target, green for above, for example. - Freeze rows/columns (
View > Freeze): keeps a header row visible while you scroll through long data.
A realistic first project
A good way to practice all of this at once: track a simple budget.
- Column A: expense name. Column B: amount. Column C: category.
- In a separate cell, use
=SUM(B:B)to get the total. - Use
=SUMIF(C:C, "Food", B:B)to total just the "Food" category — this combines a condition with a sum, the same logic as IF but built in. - Add conditional formatting to highlight any expense over a threshold.
- Freeze the header row so column labels stay visible as the list grows.
| A | B | C | |
|---|---|---|---|
| 1 | Expense | Amount | Category |
| 2 | Groceries | 64 | Food |
| 3 | Bus pass | 45 | Transport |
| 4 | Takeout | 22 | Food |
| 5 | Total | 131 | |
| 6 | Food total | 86 |
That's a working spreadsheet built entirely from the concepts above.
Where to go next
- Browse the full function reference — filter by category to find what you need.
- Read the 10 essential formulas guide for the next tier of everyday functions.
- Once lookups and conditionals feel comfortable, move on to FILTER and QUERY for working with larger datasets.