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

The two spreadsheets: Excel and Google Sheets

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

  1. 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.
  2. 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.
  3. 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 =.
  4. 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.
  5. 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

  1. Open Excel or Google Sheets and start a new, blank spreadsheet.
  2. 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.)
  3. Type the rows. A2: Groceries, B2: 84.50. A3: Electric bill, B3: 96.20. A4: Pharmacy, B4: 23.75. A5: Gas, B5: 40.
  4. Widen column A: double-click the line between the A and B letters at the very top. "Electric bill" now fits.
  5. 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.
  6. 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.
  7. 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

Fix common problems

Words in this lesson

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