Excel TutorialLesson 6Free preview

Excel Ranges

This lesson is part of Excel · All levels

Summary

Range is a set of cells written with a colon, for example A1:B10, and is the raw material for almost all Excel functions. You can select the range with the mouse, type it directly into the Name Box, or name the entire column with the A:A notation. The ability to write and choose a fast range makes writing formulas much more efficient.

Key points

Notation of the range using colon, for example A1:C10
The Name Box receives a range address to go directly there.
The entire column can be written A:A and the entire line 1:1
The range A1:C5 includes 3 columns × 5 rows = 15 cells

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.