Selecting and Naming Ranges of Cells
Group multiple cells into a range like A1:A10 and refer to many cells at once.
What Is a Range?
A range is a group of cells treated as one block. Instead of naming cells one by one, you point a formula at a whole batch at once.
The Colon Means Through
You write a range with a colon, which means "through." So A1:A10 is cell A1 through A10: ten cells stacked in a column.
A1:A10All lessons in this course
- Cells, Rows, and Columns Explained
- Reading a Cell Address Like A1
- Typing Your First Cell Reference
- Selecting and Naming Ranges of Cells