Utah Community Learning

Rows, columns, cells, and how they get named

Now that we have a question written down for our sheet, we need to talk about the grid itself, because I keep watching folks click around a spreadsheet as if it were a haunted house. It is not. It is only rows and columns, and once you know how they are named, you will stop feeling lost in there.

Rows and columns

Rows run sideways, left to right. They are numbered down the left edge: 1, 2, 3, and on it goes.

Columns run up and down. They are lettered across the top: A, B, C. Once you reach Z it goes on to AA, AB, AC. Nobody expects you to memorize that part. I just want you not to panic when you see it.

Where a row and a column cross, you get a cell. That is the actual box you type into. Every single cell has an address, and the address is simply the column letter followed by the row number. A1 is the very first cell, top left corner. B12 is column B, row 12. That is it. That is the whole naming system.

Why this matters

You do not 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 formula has to say =B5+C5. It does not care what is 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. Do not retype it. If you retype a number in two spots, you have already made a future mistake, you just have not met it yet, because one day you will 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 you land. 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 is the whole trick. B1 did not get your name typed into it. It got told to go look at A1 and show whatever is there. That is the difference between a spreadsheet and a Word document with lines in it.

A quick story, because this is exactly how it goes wrong

My daughter Lilly, she is four, climbed into my lap once while I was working on the budget. She got hold of the keyboard for about four seconds and typed a solid line of "kkkkkkkk" straight into cell B12. I did not even notice until later, because visually it just sat there in its own little box, minding its business, not troubling anything around it.

I actually left it for a whole day because it made me laugh every time I opened the file. But here is the real lesson in it: B12 was just sitting there being its own separate thing. If I had had a formula somewhere pointing at B12 expecting a number, that "kkkkkkkk" would have broken it instantly. Cells do not know or care what you meant to put in them. They only hold what is there, and anything pointing at them inherits whatever that is, gibberish and all.

A caution worth saying plainly

If you are new to this, it is easy to click one cell over from where you meant 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 are guessing at what is actually in a cell. Guessing is how wrong formulas happen, and wrong formulas are quiet. They do not yell at you. They just sit there being wrong until you go looking.

The opinion part

I think most beginners overcomplicate this stage. You do not 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.