Cell References and Ranges
Cell References and Ranges
The "Map Coordinates" of your Spreadsheet
In Excel, you don't just tell the program to "add 10 and 20." Instead, you tell it to "add the value in cell A1 to the value in cell A2." This is called a Cell Reference.
Reference Syntax
| Single Cell | A1 | Refers to a specific box. |
| Cell Range | A1:A10 | A vertical group of cells. |
| Horizontal Range | A1:D1 | A horizontal row of cells. |
| Entire Column | A:A | Selects every row in Column A. |
The "Colon" Rule
In Excel, the colon (:) means "THROUGH."
If you see B2:D6, read it as: "From cell B2 through cell D6." This creates a rectangular block of cells.
Why use Ranges?
Ranges allow you to perform math on hundreds of numbers instantly. For example:
=SUM(A1:A500)
This one command adds 500 different cells in a split second!
💡 Skill Eco Pro-Tip: Visual Selection
When writing a formula, you don't have to type the range! Just click and drag your mouse over the cells, and Excel will automatically type the reference (like A1:B10) for you.
🏋️ Test Yourself With Exercises
Take our quiz on Cell References and Ranges to test your knowledge.
Exercise »