Abstract
Transcript
The key to formulas in Excel is cell references.
Cell references can refer to one cell, a range of cells, or even entire columns and rows.
Let’s take a look.
Every cell in an Excel worksheet has a unique address.
The address of each cell is defined by its location on the grid.
The address “B7” refers to the cell in the seventh row of column B.
To check the address of any cell, just watch the Name Box as you select different cells.
When a cell reference refers to more than one cell, it is often called a “range.”
A range uses a colon to indicate its beginning and end.
When we key in this value into the Name Box, we see that range selected in the worksheet.
Only the active cell in the selection is displayed.
A range can even be an entire column or row.
This works for multiple columns and rows as well.
