Explanation

Excel worksheets are made up of rows and columns.

Rows are identified by numbers: 1, 2, 3…

Columns are identified by letters: A, B, C…

The intersection of a row and column is called a Cell.

For example:

A1 = Column A + Row 1

A group of cells is called a Range.

Examples:

  • A1:A10 — vertical range
  • A1:E1 — horizontal range
  • A1:C10 — rectangular range

Practice

Select the following in Excel:

A1, B5, A1:A10, A1:C10, Column B and Row 5.

Important

Cell addresses and ranges are fundamental to formulas and data analysis, which you will learn in later topics.

PreviousNext