Click here for Introduction Click here for Table of Contents Click here for Examples and Special Topics
BarEnd.jpg (765 bytes)

  About ranges
A "Range" refers to a group of worksheet cells. Excel refers to ranges by their first and last cells. Using this technique,
Range-cell.jpg (4076 bytes)
  • A2:A2 represents a single cell.
Range-row.jpg (4308 bytes)
  • A2:C2 represents a row.
Range-col.jpg (4190 bytes)
  • A2:A4 represents a column.
Range-block.jpg (4380 bytes)
  • A2:C4 represents a block.
Learn more
Learn about naming ranges.