Page 37 - Ms Excel Note and Workbook
P. 37
MICROSOFT EXCEL NOTE AND WORKBOOK
4 WORKING WITH CELLS AND SHEETS
Understanding cells
Every worksheet is made up of thousands of rectangles, which are called cells. A cell is
the intersection of a row and a column—in other words, where a row and column meet.
Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3). Each cell
has its own name—or cell address—based on its column and row. In the example below, the selected
cell intersects column C and row 5, so the cell address is C5.
TIP
Note that the cell address
also appears in the Name
box in the top-left corner,
and that a cell's column
and row headings are
highlighted when the cell is
selected.
You can also select multiple cells at the same time. A group of cells is known as a cell range. Rather
than a single cell address, you will refer to a cell range using the cell addresses of
the first and last cells in the cell range, separated by a colon. For example, a cell range that included
cells A1, A2, A3, A4, and A5 would be written as A1:A5. Take a look at the different cell ranges
below:
• Cell range A1:A8
28 | P a g e