A spreadsheet is a page ruled into a grid of little boxes — with a calculator hidden inside it. You type your numbers in the boxes, and the sheet does the adding, forever, even when you change a number later. Google Sheets is Google’s free spreadsheet, and it is the friendliest place to keep a household budget.
Let us build a real one together. Click cell A1 and type the word Bill — that is the heading for the first column, where the name of each bill goes. Click B1 and type the word Cost — the heading for the second column, where each amount goes. Then work down: one bill per row, its name in column A, its cost in column B.
| Cell | Type this | Cell | Type this |
|---|---|---|---|
| A2 | Rent | B2 | 950 |
| A3 | Electric bill | B3 | 86 |
| A4 | Water bill | B4 | 42 |
| A5 | Groceries | B5 | 310 |
| A6 | Gas for the car | B6 | 120 |
| A7 | Phone bill | B7 | 55 |
| A8 | Medicines | B8 | 38 |
| A9 | Eating out | B9 | 64 |
Type just the number in the B cells — no dollar signs, no commas. The sheet wants plain numbers to do sums with. Eight bills, and already this is more adding than anyone enjoys by hand. So let the sheet do it.
One thing worth knowing before we start: these formulas are not just Google’s. SUM and AVERAGE are typed exactly the same way in Microsoft Excel — everything you learn in this lesson works there too, word for word.
Now the magic: change any number — make Groceries 350 — and the total corrects itself before you have finished typing. That is why the sheet beats the calculator on the fridge.
Want to know the typical bill — the total shared out evenly across all eight? Click cell B11, type =AVERAGE(B2:B9), and press Enter. Sheets shows 208.125 — about $208 a bill. AVERAGE does the same journey as SUM (add them all), then divides by how many there are.
Typed 68 where the electric bill was 86? Click the cell, type the right number straight over the old one, and press Enter. The wrong number is gone, and every total that used it — SUM, AVERAGE, all of them — fixes itself. To change just part of what a cell says (a spelling in column A, say), double-click the cell and edit inside it like a line of writing.
If a word is cut off — “Electric b…” — the column is too narrow for it. Move your mouse to the line between two column letters at the very top, until the pointer turns into a double-headed arrow. Drag the line to widen the column, or simply double-click it: the column snaps to exactly the width of its widest word. The same trick works in Excel, with the same double-click.
Click the words Untitled spreadsheet at the top left and type a name you will recognise — House money 2026. Like everything Google, it saves itself as you work; there is no Save button. Find it again at sheets.google.com, where your sheets are listed newest first, or by searching its name in Google Drive.
Click the blue Share button at the top right, type a family member’s email, and pick what they may do: Viewer if they should only look at the budget, Editor if they keep it with you and add their own bills. The Google Docs lesson walks through sharing in full, and it works exactly the same here.
Straight 2 Work Tech, LLC — patient, plain-words tech help.
(813) 770-6082