Everyone’s first spreadsheet is secretly a piece of paper. We type a title where a title would look nice, leave a blank row where a gap would look tidy, and merge a few cells because the heading wants centring. It all looks right — and it quietly fights every useful thing Excel will ever try to do for you.
Because a sheet is not paper. It’s a grid of addressable values — closer to a city map than a page — and the whole machine works by one idea: anything can point at anything else by its address. Get that idea early and the rest of the path is downhill.
Addresses, not places on a page
Every cell has a name: column letter, row number. C3 isn’t
“roughly there” — it’s an exact address that formulas, charts and
other sheets can refer to:
=C3*1.2
That formula doesn’t contain your number. It contains a pointer
to wherever the number lives — change C3 and everything pointing
at it updates itself. This is the entire trick of spreadsheets:
values live in one place, and everything else refers to them.
The moment you type the same number twice, you’ve created two
places for the truth to live, and one of them will eventually be
wrong.
A range is just a rectangle of addresses — A2:C10 — and
functions eat ranges whole: =SUM(B2:B500). Later, ranges grow
names (and names beat addresses),
but the coordinate idea underneath never changes.
One value per cell, one idea per column
The grid rewards a particular shape of data, and it’s worth learning as a creed:
- One value per cell.
"Cork, 1480"in one cell is a sentence, not data — nothing can sum it, sort it or look it up. Two facts, two cells. (When an export jams them together, text surgery separates them.) - One kind of thing per column, with a header: all dates, all amounts, all regions. Columns are the unit Excel thinks in.
- One record per row. A row is a complete little fact — this customer, this date, this amount.
- No decorative gaps. Blank rows “for air” split your data into islands, and every tool — sorting, Ctrl-jumps, PivotTables — stops at the shoreline.
This shape has a name in stage two — a proper Table — but the instinct starts here, on day one.
And one habit to renounce
Merged cells. They’re the purest paper-thinking in Excel —
they centre a heading by destroying addresses underneath it, and
they break selection, sorting, copying and filtering forever after.
If you want a heading centred across columns, the civilised option
is Format Cells → Alignment → Centre Across Selection: same look,
no casualties. Merged cells in a data area are the first thing I
remove in any workbook I’m asked to rescue — and the most common
single cause of “Excel is being weird”.
Presentation isn’t banned — it’s just a separate concern. Data in its grid shape first; fonts, borders and number formats painted on top, never instead of structure. The sheets that survive years of use are all built this way, and the ones that collapse are all, underneath, pieces of paper.
Think in addresses. Keep one truth per cell. Let the map be a map — and every stage after this one gets easier.