0PricingLogin
Excel Formulas Academy · Lesson

Typing Your First Cell Reference

Point a cell at another cell using =A1 and watch the value follow.

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.

=A1

Always 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.

=A1

All lessons in this course

  1. Cells, Rows, and Columns Explained
  2. Reading a Cell Address Like A1
  3. Typing Your First Cell Reference
  4. Selecting and Naming Ranges of Cells
← Back to Excel Formulas Academy