Typing Your First Cell Reference
Point a cell at another cell using =A1 and watch the value follow.
Typing Your First Cell Reference is a free Excel Formulas Academy lesson on CoddyKit — lesson 3 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.
Pointing One Cell at Another
You've read addresses; now let's use one. The simplest formula points one cell at another: type =A1 in B1 and B1 mirrors whatever's in A1.
=A1Always Start With Equals
The secret ingredient is the equals sign. Typing A1 shows the text "A1," but =A1 tells the sheet to go fetch A1's value.
=A1A Step-by-Step Walkthrough
Try it: put 10 in A1, then type =A1 in B1 and press Enter. B1 now shows 10, pulled straight from A1 by the reference.
=A1Watch the Value Follow
Here's the magic: change A1 from 10 to 25, and B1 instantly shows 25 too. You never touched B1. This is why people call spreadsheets "live." ✨
Referencing Text, Not Just Numbers
References work for any value, not just numbers. If A1 holds the word "Hello," then =A1 shows "Hello" too. It simply mirrors whatever's there.
=A1Pointing Anywhere on the Sheet
A reference can reach any cell on the sheet, not just neighbors. =D5 grabs from D5, and =A100 reaches far down in row 100.
=D5Clicking Instead of Typing
You don't have to type references by hand. After the = sign, just click the cell you want and the sheet fills it in. Fewer typos.
A Worked Example: A Mirror Column
Want a tidy copy of column A in column C? Type =A1 in C1, =A2 in C2, and so on. Edit a name in A and C updates automatically.
=A2Referencing a Cell That Has a Formula
A reference can even point to a cell that holds a formula. If B1 is =A1 and C1 is =B1, the sheet follows the chain and C1 matches A1.
=B1Avoiding a Circular Reference
One thing to avoid: pointing a cell at itself. Typing =A1 inside A1 makes a circular reference, and the sheet will warn you.
Why This Tiny Formula Matters
Pointing one cell at another seems small, but it's the seed of every formula. Master =A1 and =A1+A2 or =SUM(A1:A10) feel natural.
=A1+A2Quick Check
Think about what happens when a source cell changes.
Recap: Your First Reference
Recap: every formula starts with =. =A1 points a cell at another's value and stays live, so changing the source updates it.
Frequently asked questions
Is the “Typing Your First Cell Reference” lesson free?
Yes — the full text of “Typing Your First Cell Reference” 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 “Typing Your First Cell Reference”?
Point a cell at another cell using =A1 and watch the value follow. 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 3 of 4, so you can start here or from the beginning and move at your own pace.
How long does the “Typing Your First Cell Reference” 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