Spreadsheets for Real Life: A Smart List That Adds Up
A spreadsheet is a list with a brain. It is a page divided into boxes — rows going down, columns going across — made for names, dates, and numbers. Type the numbers once, and the sheet does the adding, forever, without a calculator. This lesson teaches the five moves that cover real life — typing in a box, widening a column, adding with SUM, sorting a list A–Z, and printing so it fits — then walks through one whole example: a month's expenses.
Words to know first
- Spreadsheet: a page of boxes in rows and columns, built for lists and numbers. Also the file itself, and the program that makes it — context tells you which.
- Cell: one box. Every cell has a name made of its column letter and row number — B3 is column B, row 3.
- Formula: an instruction typed in a cell that starts with an equals sign and does math, like =B2+B3.
- SUM: the formula word that adds a run of numbers. =SUM(B2:B5) means "add the cells from B2 down to B5."
- Range: a run of cells written with a colon — B2:B5 is the four cells B2, B3, B4, and B5.
The two spreadsheets: Excel and Google Sheets
- Microsoft Excel is a program on your computer, part of Microsoft 365 or Office. Its files end in .xlsx.
- Google Sheets runs in your web browser and is free with a Google account. It saves itself as you type — there is no Save button to forget.
- They open each other's files. An .xlsx opens in Excel, and also in Google Sheets (put it in Google Drive and double-click). A Google Sheet can come back as an Excel file: File → Download → Microsoft Excel (.xlsx). Our lesson Google Sheets: The Grid That Adds Up for You is a full tour of the free one.
Read a sheet someone sent you
Open it the way you open a document: from the email, into Downloads, double-click. Looking changes nothing — read all you like. If you click a cell and type by accident, press Ctrl+Z (Undo) right away, or close the file and choose "Don't save" if it asks. One caution: a number on a sheet may be a formula's answer rather than a typed number. Before you retype anything, click the cell and read the formula bar — the long box above the columns — which shows what is really inside.
The five moves
- Type in a cell. Click the cell, type, and press Enter — the words or numbers land, and you step down one row, ready for the next line. To correct a cell, click it and type the right thing over it. To fix just part of what's inside, double-click the cell and edit in place.
- Widen a column. If words are cut off, or a cell shows #####, the column is too narrow — that row of # signs is the sheet asking for room. Drag the right edge of the column's letter (at the very top) to the right — or double-click that edge and the column sizes itself to fit its contents. This works the same in Excel and in Google Sheets.
- Add numbers with SUM. Click the empty cell just below your numbers. In Excel: Home tab → AutoSum, then press Enter — Excel writes the SUM formula for you. In Google Sheets: type =SUM(B2:B5) (with your own cells in place of B2 and B5) and press Enter. The worked example below shows it in action. Simple math works too: =B2+B3 adds two cells, and =B6-B4 takes one amount away from another. Every formula starts with =.
- Sort a list A–Z. Click one cell inside your list, in the column you want in alphabetical order. In Excel: Data tab → Sort A to Z (the A→Z button). In Google Sheets: Data → Sort sheet → "Sort sheet by column …, A → Z." The whole rows travel together — names stay with their numbers — as long as the list is one tidy block with no blank rows in the middle. Our lesson Sort a List, Freeze the Top Row, and Print Your Sheet goes further.
- Print so it fits the page. In Excel: File → Print, and in the last Settings list choose Fit All Columns on One Page for a long list, or Fit Sheet on One Page for a short one. In Google Sheets: File → Print, and under Scale choose Fit to width. A wide list also prints better sideways — Orientation → Landscape, in the same print window either way.
A worked example: one month's expenses
- Open Excel or Google Sheets and start a new, blank spreadsheet.
- Label the columns. Click cell A1 and type What. Click B1 and type Cost. (Select both and press Ctrl+B if you want them bold.)
- Type the rows. A2: Groceries, B2: 84.50. A3: Electric bill, B3: 96.20. A4: Pharmacy, B4: 23.75. A5: Gas, B5: 40.
- Widen column A: double-click the line between the A and B letters at the very top. "Electric bill" now fits.
- Add it up. Click cell B6. In Excel, Home tab → AutoSum → Enter. In Sheets, type =SUM(B2:B5) and press Enter. The total appears: 244.45.
- Change any amount — say the electric bill was really 90 — and watch the total change by itself. That instant recalculation is the whole magic of a spreadsheet.
- Save it. In Excel: File → Save As, and name it "November expenses." In Google Sheets it has already saved itself — click the name at the top of the page to rename it.
When you are ready for the next steps — more formulas, and totals that span months — our lesson Excel Formulas: Let the Sheet Do the Sums picks up where this one stops, and our video Microsoft Excel Basics shows a simple list being built on screen.
Good to know
- The total is never stale. Change any number in the list and every total that uses it updates in the same instant. That is why a sheet beats a calculator and a paper list for anything you will update twice.
- Keep one list per sheet. A sheet can hold many tabs along the bottom, but one tidy list per tab — no blank rows in the middle — keeps sorting and totals honest.
- Not sure which kind of file you were sent? Our chart Document Files at a Glance explains .xlsx and its neighbors, and names a free program for each.
Fix common problems
- "A cell is full of # signs." Nothing is broken — the column is too narrow for the number. Double-click the right edge of that column's letter at the top and it widens itself.
- "My total looks wrong." Click the total cell and read the formula bar: it names the cells being added, like B2:B5. If one of your amounts sits outside that run — a row added below B5, say — it is not being counted. Delete the total and do the SUM step again, making sure the run covers every amount, top to bottom.
- "Sorting scrambled my list." Press Ctrl+Z (Command+Z on a Mac) at once to put everything back. Then sort again, starting from one cell inside the list — and check first that no blank row splits the list in two, which is the usual cause.
- "It prints across six pages." Use the Fit choices in move five — Fit All Columns on One Page in Excel, Fit to width in Sheets — and turn the page sideways (Landscape) for a wide list.
Words in this lesson
- Formula bar: the long box above the columns that shows what is really inside the cell you clicked — the words, the number, or the formula behind the number.
- Undo: the command that takes back your last change: Ctrl+Z on Windows, Command+Z on a Mac. The rescuer of first resort.
- AutoSum: Excel's one-click SUM — it guesses the numbers you mean (usually the column right above) and writes the formula for you.