Rows, columns, cells, and how they get named
Okay sooo. Now that we've got a question written down for our sheet, we need to talk about the grid itself, because I keep watching people click around a spreadsheet like it's a haunted house. It's not. It's just rows and columns, and once you know how they're named, you'll stop feeling lost in there.
Rows and columns
Rows run sideways, left to right. They're numbered down the left edge: 1, 2, 3, and so on.
Columns run up and down. They're lettered across the top: A, B, C. Once you hit Z it goes AA, AB, AC. Nobody expects you to memorize that part, I just want you to not panic when you see it.
Where a row and a column cross, you get a cell. That's the actual box you type into. Every single cell has an address, and the address is just the column letter followed by the row number. A1 is the very first cell, top left corner. B12 is column B, row 12. That's it. That's the whole naming system.
Why this matters
Here's the thing. You don't need to know cell addresses to type a number into a box. But you need them the second you want a formula, because formulas talk in addresses, not in "that number I typed a minute ago." If you want cell D5 to be the sum of B5 and C5, the fromula has to say =B5+C5. It doesn't care what's visually near it, it cares about the address.
This is also how you avoid my favorite personal disaster, which is typing the same number into three different places by hand. If your total needs to reflect a number that lives in B5, point at B5. Don't retype it. If you retype a number in two spots, you've already made a future mistake, you just haven't met it yet, because one day you'll update one and forget the other.
Try this at home
- Open a blank sheet.
- Click on cell A1. Look at the little box up in the corner, sometimes called the Name Box, it should say A1.
- Click around to a few different cells and watch that box change. B4, F9, wherever. Just get used to the address showing up.
- Type your name into A1.
- Click into B1 and type =A1. Hit enter. Watch it pull your name over.
That's the whole trick. B1 didn't get your name typed into it, it got told to go look at A1 and show whatever's there. That's the difference between a spreadsheet and a Word doc with lines in it.
A quick story, because this is exactly how it goes wrong
My daughter Lilly, she's four, climbed into my lap once while I was working on the budget. She got ahold of the keyboard for about four seconds and typed a solid line of "kkkkkkkk" straight into cell B12. I didn't even notice until later because visually it just sat there in its own little box, minding its business, not affecting anything around it.
I actually left it for a whole day because it made me laugh every time I opened the file. But here's the real lesson in that: B12 was just sitting there being its own separate thing. If I'd had a formula somewhere pointing at B12 expecting a number, that "kkkkkkkk" would've broken it instantly. Cells don't know or care what you meant to put in them. They just hold what's there, and anything pointing at them inherits whatever that is, gibberish included.
A caution worth saying plainly
If you're new to this, it's easy to click one cell over from where you meant to and not notice, especially if your rows are close together or your screen is small. Zoom in if you need to. Widen your columns if the text is getting cut off and you're guessing at what's actually in a cell. Guessing is how wrong formulas happen, and wrong formulas are quiet, they don't yell at you, they just sit there being wrong until you go looking.
The opinion part
Not gonna lie, I think most beginners overcomplicate this stage. You don't need to know every trick with column letters going into double letters or absolute references yet. You need exactly two things: rows go one way, columns go the other, and every cell has an address made of both. Everything else builds on that slowly.
Before next time
Open whatever sheet you started last lesson with your question written down, and just click through a handful of cells noticing their addresses. No formulas yet, just get your eyes used to reading A1, B3, D12 without translating it in your head first.
- C