Ranges — Excel Course

A range is a group of cells such as B2:B10 or A1:C5. Learn it step by step with guided practice on Excelquro.

Understand

A range is a group of cells. B2:B6 is a vertical range containing five cells. A1:C5 is a rectangular range.

Worked example

The colon means “from B2 through B6.” Excel adds all five Collection values.

=SUM(B2:B6)

Follow along

1. Click B2 and drag to B5.
2. Read the Name Box to see the range.
3. Use =SUM(B2:B5) to total the selected values.
4. Expand the range to include B6 and compare the result.

Interactive practice runs in your browser.