Google Sheets: The Grid That Adds Up for You

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.

The grid, in plain words

Start a new sheet

  1. On a computer: type sheets.google.com in your browser and click Blank spreadsheet, the big + page.
  2. On a phone: open the free Google Sheets app, tap the + button, and tap New spreadsheet.
  3. An empty grid opens. That is all a spreadsheet is, until you feed it.

A worked example: one month of house money

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.

CellType thisCellType this
A2RentB2950
A3Electric billB386
A4Water billB442
A5GroceriesB5310
A6Gas for the carB6120
A7Phone billB755
A8MedicinesB838
A9Eating outB964

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.

Add the numbers up with SUM

  1. Click cell B10 — the empty cell just under your last number. This is where the total will live.
  2. Type =SUM( — the equals sign first, always. It tells the sheet: a sum is coming, this is not a word.
  3. Click cell B2. The sheet writes B2 into your sum for you.
  4. Hold the Shift key and click cell B9. The sheet writes B2:B9 — which means every cell from B2 down to B9. (On a phone, type B2:B9 with the keyboard instead.)
  5. Type ) to close the sum, then press Enter (on a phone, tap the tick).
  6. Cell B10 now shows 1665 — the whole month, added exactly. Click B10 again and look at the long line above the columns: it shows your sum, =SUM(B2:B9). The cell shows the answer; that line shows the working.

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.

The average bill: AVERAGE

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.

Fix a mistake

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.

Make the columns wider

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.

Name it, find it again

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.

Share it

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.

Words in this lesson

📖 Goes further: Microsoft Excel speaks exactly this language — SUM, AVERAGE, and more, including the clever IF — in Excel Formulas: Let the Sheet Do the Sums.

Straight 2 Work Tech, LLC — patient, plain-words tech help.
(813) 770-6082