Reading a Cell Address Like A1
Understand column letters and row numbers and how they combine into a cell reference.
Reading a Cell Address Like A1 is a free Excel Formulas Academy lesson on CoddyKit — lesson 2 of 4. You can read the complete lesson below for free — then practise it hands-on in the browser with a built-in code editor and a 24/7 AI tutor. It is part of the Excel Formulas Academy learning path, one of 4 lessons in the course, and your progress syncs across the web and the CoddyKit app.
What Is a Cell Reference?
A cell reference is the name that points to one cell. It's just the column letter plus the row number, like A1 or B7.
The Column Letter
The first part of a reference is the column letter, counted left to right from A. In C4, the C means the third column over.
After Z Comes AA
There are only 26 letters, so after column Z the labels double up: the 27th column is AA, then AB, AC. Nothing special, just the next column along.
The Row Number
The second part is the row number, counted from the top down. In C4, the 4 means the fourth row, so C and 4 pinpoint one cell.
Putting the Two Parts Together
To read any reference, split it: letter first, number second. So E9 is column E, row 9. You'll never see a valid reference like 1A.
A Worked Example
Say a table has months down column A and totals in column B. March's total lives where row 4 meets column B, so its reference is B4.
Using a Reference in a Formula
References shine inside formulas: you point at cells instead of typing numbers. If B4 is 250 and B5 is 100, then =B4+B5 gives 350.
=B4+B5References Update Automatically
References stay live. If =B4+B5 shows 350 and you change B4 to 300, the result jumps to 400 on its own. No redoing the math by hand.
Same Idea in Excel and Sheets
Good news: references work identically in Excel and Google Sheets. Learn it once and you can switch between the two without relearning a thing.
Confirm With the Name Box
Unsure where a reference points? Click around and watch the Name Box. You can even type a reference like F12 into it to jump straight there.
Common Reading Mistakes
A few common slip-ups: reversing the order (4C for C4), or mixing up the letter O with the number 0. Letter first, number second keeps you safe.
Quick Check
Read the reference carefully and pick the correct location.
Recap: Reading Addresses
Recap: a reference is a column letter plus a row number, letter always first. References let formulas point at cells and update automatically.
Frequently asked questions
Is the “Reading a Cell Address Like A1” lesson free?
Yes — the full text of “Reading a Cell Address Like A1” is free to read here on the web, and the Excel Formulas Academy course includes 4 lessons in total. To practise it interactively (a built-in code editor and a 24/7 AI tutor) and unlock the rest of the Excel Formulas Academy course, upgrade to CoddyKit PRO.
What will I learn in “Reading a Cell Address Like A1”?
Understand column letters and row numbers and how they combine into a cell reference. You practise Excel Formulas Academy with hands-on code you run directly in the browser, and a 24/7 AI tutor answers your questions as you work through the lesson.
Do I need any experience to start Excel Formulas Academy?
No prior experience is required. Excel Formulas Academy on CoddyKit is structured for beginners through advanced learners; this is — lesson 2 of 4, so you can start here or from the beginning and move at your own pace.
How long does the “Reading a Cell Address Like A1” lesson take?
Most CoddyKit lessons take about 5–10 minutes. Each one is bite-sized and interactive, so you make steady progress and pick up exactly where you left off across the web and the app.
Can I write and run code in this Excel Formulas Academy lesson?
Yes. Every Excel Formulas Academy lesson includes a built-in code editor, so you write and run real code right in your browser and get instant AI feedback — no local setup required.
All lessons in this course
- Cells, Rows, and Columns Explained
- Reading a Cell Address Like A1
- Typing Your First Cell Reference
- Selecting and Naming Ranges of Cells