A blank spreadsheet can feel a bit like an empty kitchen: you have the tools, but where do you start? This Google Sheets Complete Beginner’s Guide walks you through one small spending tracker. You’ll create it, enter data, write formulas, keep entries tidy, find useful rows, and share the finished sheet.
The main walkthrough uses a desktop browser on Windows or macOS. You don’t need to install desktop software. If you use an iPhone, iPad, or Android device, you’ll find app setup instructions below, too.
What Is Google Sheets?
Google Sheets is an online spreadsheet for organizing information in rows and columns. It helps with budgets, class lists, project plans, and any other job where a list needs a little math. You can open it at sheets.google.com or create a sheet from Google Drive.
- Cells hold individual pieces of information, such as a date or price.
- Formulas calculate answers from those cells.
- Formatting and dropdowns make a sheet easier to read and fill in.
- Filters and pivot tables help you find and summarize rows.
- Sharing and comments let other people work with you.
If you’ve used a paper expense log, think of Sheets as one that can do the arithmetic and keep everyone looking at the same page.
Prerequisites
Make sure you have:
- A Windows PC or Mac with a web browser and internet access for the main walkthrough.
- A Google account you can sign in to. You’ll need it to create and share the example sheet.
- About 20 minutes to build the example.
- An iPhone, iPad, or Android device only if you also want the mobile app.
Google Sheets changes continuously, so a button may move slightly. The desktop instructions here follow the browser interface rather than a numbered app version. Google’s getting-started guide is a useful reference if your screen looks different.
Step-by-Step Guide
We’ll build a spending tracker with five purchases. Keep the same sheet open as you go: each new feature will use the data from the previous step.
Step 1: Open Google Sheets
On Windows
Open your browser, click the address bar, type https://sheets.google.com, and press Enter. Sign in to your Google account if asked. You should arrive at the Sheets home page, where you can create or open spreadsheets.
On macOS
Open your browser, click the address bar, type https://sheets.google.com, and press Return. Sign in if asked. You should see the same Sheets home page.
On the web
Already in a browser? Go straight to sheets.google.com. You can also open Google Drive and click New > Google Sheets.
Expected result: You can see an option to start a blank spreadsheet.
Step 2: Create and name your spreadsheet
Click Blank spreadsheet. When the grid opens, click the name at the top left (usually Untitled spreadsheet), type Household Spending Practice, and press Enter or Return.
Expected result: The new name appears at the top of the page. Your spreadsheet is ready for data.
Step 3: Find the parts you’ll use
Click cell A1 in the grid. The box near the upper left shows its cell address: column A, row 1. The long entry area above the grid is where you can inspect or edit a cell’s contents. The toolbar above it holds common formatting buttons. At the bottom, the Sheet1 tab represents one page within this spreadsheet.
Imagine a filing cabinet: the spreadsheet is the cabinet, a sheet tab is a drawer, and each cell is a labeled spot inside it.
Expected result: Clicking another cell changes the address shown near the entry area.
Step 4: Enter the column headings
Click A1, type Date, and press Tab to move right. Continue across row 1 with these headings:
| Cell | Enter |
|---|---|
| A1 | Date |
| B1 | Category |
| C1 | Item |
| D1 | Quantity |
| E1 | Unit Price |
| F1 | Total |
| G1 | Status |
| H1 | Over $10? |
Expected result: Row 1 describes what belongs in each column. The Total and Over $10? columns will get formulas shortly.
Step 5: Enter the example purchases
Click A2 and fill rows 2 through 6 using this table. Press Tab to move across a row and Enter or Return to finish an entry. Leave columns F and H empty for now.
| Row | Date | Category | Item | Quantity | Unit Price | Status |
|---|---|---|---|---|---|---|
| 2 | 2026-10-01 | Grocery | Apples | 3 | 2 | Planned |
| 3 | 2026-10-02 | Transport | Bus pass | 1 | 30 | Paid |
| 4 | 2026-10-03 | Grocery | Bread | 2 | 4 | Paid |
| 5 | 2026-10-04 | Home | Light bulbs | 2 | 6 | Planned |
| 6 | 2026-10-05 | Transport | Train ticket | 2 | 5 | Paid |
Enter dates in the 2026-10-01 pattern. If Sheets displays them in another date style, that’s fine; date display depends on the sheet’s locale.
Expected result: You have five purchase rows. Words appear in the category, item, and status columns; quantities and prices appear as numbers.
Step 6: Make the headings and numbers easier to read
Select A1:H1, then click Bold on the toolbar. Next, select E2:F6 and click the Format as currency button on the toolbar. If your dates appear as plain text, select A2:A6, then click Format > Number > Date.
The currency symbol may differ with your locale. That’s a display choice; it doesn’t change the arithmetic.
Expected result: The header stands out, prices look like money, and dates are easy to scan.
Step 7: Calculate the first row’s total
Click F2, enter this formula, and press Enter or Return:
=D2*E2The = tells Sheets to calculate. D2 points to the quantity of apples, E2 points to their unit price, and * means multiply. Cell references are like street addresses: if you change the value at an address, the formula uses the new value.
Expected result: F2 shows 6 (or the currency-formatted equivalent).
Step 8: Fill the total formula down the column
Click F2 again. Point to the small square at the bottom-right corner of its selection border, then drag it down to F6. Sheets adjusts the row references as it fills.
Expected result: F2:F6 shows 6, 30, 8, 12, and 10. For example, F3 calculates =D3*E3 for the bus pass.
Step 9: Add a small budget reference table
Click I1 and enter Category. Click J1 and enter Budget. Then fill in the three rows below:
| Cell | Enter | Cell | Enter |
|---|---|---|---|
| I2 | Grocery | J2 | 20 |
| I3 | Transport | J3 | 50 |
| I4 | Home | J4 | 25 |
Select J2:J4 and use Format as currency. This little table gives the lookup formula in Step 13 something useful to find.
Expected result: A category-and-budget table appears to the right of your purchases.
Step 10: Add a grand total with SUM
Click I6, type Grand total, then click J6 and enter:
=SUM(F2:F6)F2:F6 means every cell from F2 through F6. SUM adds those values together.
Expected result: J6 shows 66. Google’s formula guide explains how formulas begin with = and use cell references.
Step 11: Find the average purchase total
Click I7, type Average purchase, then click J7 and enter:
=AVERAGE(F2:F6)AVERAGE adds the five totals and divides by five. It’s handy when you want a typical purchase amount rather than the whole bill.
Expected result: J7 shows 13.2. Format J6:J7 as currency if you want the summary to match the purchase totals.
Step 12: Flag purchases above $10 with IF
Click H2, enter this formula, and press Enter or Return:
=IF(F2>10,"Yes","No")This reads like a question: “Is the total in F2 greater than 10?” If yes, show Yes; otherwise show No. Drag the fill handle from H2 down to H6.
Expected result: The bus pass and light bulbs show Yes. The other rows show No. If you want to check a function’s spelling or arguments, use Google’s Sheets function list.
Step 13: Look up each category’s budget
Click K1 and type Category Budget. Click K2, enter the formula below, and fill it down to K6:
=VLOOKUP(B2,$I$2:$J$4,2,FALSE)VLOOKUP searches the first column of the budget table for the category in B2. It returns the matching value from column 2. FALSE asks for an exact match. The dollar signs keep the budget table fixed when you fill the formula down (otherwise the lookup area would slide down, too).
Expected result: Grocery rows show 20, Transport rows show 50, and the Home row shows 25. Format K2:K6 as currency if you like.
Prefer XLOOKUP? Its equivalent is shown below. Check the current function list for syntax and availability in your Sheets account before using it:
=XLOOKUP(B2,$I$2:$I$4,$J$2:$J$4,"Not found")Step 14: Highlight larger purchases
Select F2:F6, then click Format > Conditional formatting. In the panel, choose Greater than, enter 10, pick a fill color, and click Done.
Conditional formatting is a highlighter that updates itself. If a total later changes from 8 to 18, its color follows the rule.
Expected result: The 30 and 12 totals are highlighted.
Step 15: Add a dropdown for purchase status
Select G2:G6, then click Insert > Dropdown. In the dropdown panel, set two options: Planned and Paid. Click Done. If Sheets asks how to handle values already in the cells, make sure those existing words match the options exactly.
A dropdown is useful when “Paid,” “paid,” and “Done” would otherwise become three names for the same thing.
Expected result: Clicking a cell in G2:G6 shows a choice between Planned and Paid.
Step 16: Keep the headings visible while scrolling
Click View > Freeze > 1 row. This pins the header row at the top while you scroll through a longer list.
Expected result: Row 1 remains visible as you scroll down. With our tiny example, you may need to add more rows before the benefit is obvious, but the setting is ready.
Step 17: Turn on filters
Select A1:H6, then click Data > Create a filter. Small filter buttons should appear in the header row. Click the filter button in B1, clear the categories you don’t want, leave Grocery selected, and click OK.
Filtering is like asking the sheet to show only one shelf of the pantry. It hides other rows from view without deleting them.
Expected result: You see the apples and bread rows. To see all purchases again, open the same filter and select all categories.
Step 18: Sort the purchases by date
First, restore all categories in the filter so every purchase is visible. Then click the filter button in A1 and choose Sort A to Z. For dates, that puts earlier purchases first.
Sorting through the filter button keeps each purchase row together. That’s the important bit: sorting just one column on its own can mix up items and prices.
Expected result: The rows run from 2026-10-01 through 2026-10-05.
Step 19: Summarize spending with a pivot table
Select A1:H6 and click Insert > Pivot table. Choose New sheet, then click Create. In the pivot table editor, add Category under Rows and Total under Values. If the value is summarized another way, change its summary setting to SUM.
A pivot table groups the source rows for you. It answers “How much did each category cost?” without making you write a separate formula for each one.
Expected result: The pivot table shows Grocery: 14, Transport: 40, and Home: 12, plus a grand total of 66. Click the original sheet tab at the bottom to return to your purchase list.
Step 20: Share the spreadsheet
Click Share at the top right. Enter the email address of someone you want to work with. Choose Viewer if they only need to read, Commenter if they should leave notes, or Editor if they should change cells. Click Send.
For a household budget, I would start with the narrowest access the person needs. You can change their access later.
Keep in mind that sharing the spreadsheet shares the entire file, not just the budget rows you happen to be viewing — anyone you add can open every sheet and row in the workbook. Editor access also lets that person change or delete any content, including formulas and other people’s entries, so reserve Editor for people you’d trust with the whole file.
Expected result: The person appears in the sharing settings with the access you chose. They can open the same spreadsheet from their invitation.
Step 21: Leave a comment on a purchase
Click F3, the bus pass total, then click Insert > Comment. Type a note such as “Check whether this pass covers the whole month,” and click Comment.
A comment attaches a conversation to a particular cell. That’s less confusing than sending a message that says “What is this 30?” when there are several 30s on the sheet.
Expected result: A comment indicator appears on F3, and people with access can read the note.
Step 22: Inspect an earlier version
Click File > Version history > See version history. Select an earlier entry in the panel to inspect what the spreadsheet looked like at that point. Return to the current view when you’re done.
Version history is the spreadsheet’s rewind button. It’s especially useful after several people have edited the same file.
Expected result: You can see saved versions and inspect earlier changes. The list may be short if you just created the file.
Set Up Google Sheets on Each Platform
The spreadsheet you made in the browser is tied to your Google account. Sign in with that same account elsewhere to open it.
On Windows
Open a browser and visit sheets.google.com. No separate desktop installation is needed for this walkthrough. To return quickly, bookmark the page with Ctrl + D.
Expected result: Household Spending Practice appears in your Sheets list when you’re signed in to the same account.
On macOS
Open a browser and visit sheets.google.com. Bookmark it with ⌘ + D if you’ll use it often.
Expected result: Your practice spreadsheet appears in your Sheets list.
On iOS
On an iPhone or iPad, open the App Store, search for Google Sheets, and install the app published by Google. Open it, sign in with the Google account you used above, and tap Household Spending Practice.
The mobile layout differs from the desktop browser walkthrough. Use the desktop view for the menu paths in the numbered steps.
Expected result: The practice spreadsheet opens in the iPhone or iPad app.
On Android
Open the Play Store, search for Google Sheets, and install the app published by Google if it isn’t already on your device. Open it, choose the same Google account, and tap Household Spending Practice.
Expected result: The practice spreadsheet opens in the Android app.
On the web
On another computer, open sheets.google.com and sign in to the same account. Click Household Spending Practice from the file list.
Expected result: You can continue with the same data and formulas in your browser.
Configuration: Settings Worth Knowing
You can use Sheets happily without changing every setting. These are the few controls that solve common frustrations.
- Formula suggestions: In an open desktop spreadsheet, click Tools > Suggestion controls and inspect Enable formula suggestions. Select it if you want Sheets to offer formula ideas while you type. The control may already be on or off.
- Formula corrections: Click Tools > Autocomplete and inspect Enable formula corrections if Sheets isn’t pointing out likely formula mistakes.
- Date and currency display: Select the relevant cells, then use Format > Number to choose Date or a money format. If dates still look wrong, check the spreadsheet’s locale under File > Settings.
- Offline access in Chrome: Install the Google Docs Offline extension. In Google Drive, click Settings > Settings, find the Offline section, enable the option to create, open, and edit recent Docs, Sheets, and Slides files offline, then click Done. While you’re still online, right-click the spreadsheet in Drive and turn on Available offline. Google’s offline help explains the setup.
Advanced features to verify before using
You may see references to a manual calculation setting or a pivot-table calculated-field editor. The supplied official research for this guide does not establish their current controls, availability, or behavior. Check current Google Sheets documentation and the menus in your own account before following instructions for either feature. The regular pivot table in Step 19 needs neither one.
Tips and Troubleshooting
Problem: A formula shows an error instead of a number
- Click the cell and check that the formula starts with
=. - Check the referenced cells. For example,
=D2*E2needs numbers in both D2 and E2. - If a lookup fails, make sure the category text matches the budget table exactly and that the lookup range includes both columns.
- Open the function list to check the function’s arguments.
Problem: Formula suggestions or corrections are missing
- Open Tools > Suggestion controls and inspect Enable formula suggestions.
- Open Tools > Autocomplete and inspect Enable formula corrections.
- Select the control you want. These are aids, so you can still type formulas directly when they don’t appear.
Problem: The spreadsheet won’t open offline
- Confirm you’re using Chrome on the computer and have installed Google Docs Offline.
- In Drive’s Settings, check the Offline option.
- Right-click the file in Drive and check Available offline while you still have internet access. Offline setup is much less useful if you wait until the connection is already gone (ask anyone who’s tried to download a boarding pass in a dead zone).
Problem: You can’t find a menu command
- Open Tool finder with
Alt + /on Windows orOption + /on Mac. - Type the command you want, such as “conditional formatting.”
- Choose the matching result. Google’s keyboard shortcut reference is useful when a shortcut differs for your keyboard or language.
Problem: A shortcut doesn’t work
- Open the shortcut list with
Ctrl + /on Windows or⌘ + /on Mac. - Look up the action there. Some shortcuts vary by keyboard and language.
Quick shortcuts worth keeping:
| Action | Windows | macOS |
|---|---|---|
| Copy selected cells | Ctrl + C | ⌘ + C |
| Paste copied cells | Ctrl + V | ⌘ + V |
| Undo a change | Ctrl + Z | ⌘ + Z |
| Find text in the sheet | Ctrl + F | ⌘ + F |
| Open Tool finder | Alt + / | Option + / |
| Show the shortcut list | Ctrl + / | ⌘ + / |
Tip: Practice by changing one value. Change the apple quantity in D2 from 3 to 4. Watch F2, the grand total in J6, and the average in J7 update. That’s the moment formulas start to feel useful instead of mysterious.
Wrapping Up
Your spending tracker can now calculate totals, flag bigger purchases, keep statuses consistent, summarize categories, and give other people a clear way to help. In my opinion, the best way to get comfortable with Sheets is to keep using one real list and add features only when that list needs them.
| Step | Action | Applies To |
|---|---|---|
| Start | Open Sheets and create a file | Windows, macOS, web |
| Build | Enter, format, and calculate data | Desktop browser |
| Organize | Add dropdowns, filters, and a pivot table | Desktop browser |
| Collaborate | Share, comment, and inspect versions | Desktop browser |
| Continue | Open the same file in the mobile app | iOS, Android |