A colleague says, “Please apply the formula from D2 to D100.” If you do not understand rows, columns, cells and ranges, even this simple instruction becomes confusing. This lesson removes that confusion permanently.

The Excel grid explained

Excel is built on a grid. The grid is made of rows and columns. Where a row and column meet, you get a cell. Every number, text value, date, formula and heading lives inside a cell.

Cell address example

A
B
C
D
1
A1
B1
C1
D1
2
A2
B2
C2
D2
3
A3
B3
C3
D3

What are rows?

Rows run horizontally from left to right. They are identified by numbers: 1, 2, 3, 4 and so on. In a sales report, each row often represents one record or transaction.

What are columns?

Columns run vertically from top to bottom. They are identified by letters: A, B, C, D and so on. In a report, each column usually represents one field such as Date, Region, Product, Quantity, Sales or Profit.

What is a cell?

A cell is the box where a row and column meet. The first cell in Excel is A1. It is in column A and row 1.

AColumn letter
1Row number
A1Cell address

Why cell addresses matter

Formulas use cell addresses. If cell B2 contains price and cell C2 contains quantity, then cell D2 can calculate total using =B2*C2.

Business example: In an invoice, calculate line total using references like =Price*Quantity, not by typing totals manually.

What is a range?

A range is a group of cells. Excel writes ranges using the first cell and last cell separated by a colon.

  • A1:A10 means cells A1 through A10.
  • A1:D1 means row 1 from column A to D.
  • A1:D10 means the block from A1 to D10.
💡
Shortcut: Click inside a data table and press Ctrl+A once to select the current data region.
⚠️
Common mistake: Selecting the wrong range before applying formulas, formatting or charts.
🧪 Practice Lab

Build a simple sales table

Download one ZIP file containing the practice workbook, challenge workbook, solution workbook, cheat sheet, quiz and answer key.

📦 Download Lesson 3 ResourcesWorks as a standalone file and after website deployment

Mini practice

  1. Create a table with columns Date, Product, Quantity, Unit Price and Total.
  2. In Total, multiply Quantity by Unit Price.
  3. Select the full table range.
  4. Select only the Quantity column.
  5. Write down the range address for each selection.

Quick quiz

  1. What is a row?
  2. What is a column?
  3. What does C4 mean?
  4. What is a range?

Answers: Horizontal numbered line; vertical lettered line; column C row 4; group of cells.

FAQ

A cell is one box. A range is a group of cells.
Cell references allow formulas to update automatically when source values change.