Microsoft Office Tutorials and References
In Depth Information
Working with Cells and Ranges
Working with Cells and Ranges
In the previous session, you worked with entire columns or rows of cells. In this
session you’ll work with groups of worksheet cells, or ranges. The customer order data you
entered in cells A1 through G5 forms an adjacent range because it covers one
rectangular block of cells. All the last names in cells A1 through A5 and all the numbers in cells
F1 through G5 together form a nonadjacent range because they are two distinct
rectangular blocks of cells.
Just as a cell reference indicates the location of an individual worksheet cell, a range
reference indicates the location and size of a cell range. For adjacent ranges, the range
reference includes the cell reference of the upper-left and lower-right cells in the
rectangular block separated by a colon. For example, the range reference A1:G5 refers to all
the cells in the rectangular block from cells A1 through G5. The range reference for
nonadjacent ranges separates each adjacent range reference by a semicolon. For example,
the cell reference A1:A5;F1:G5 references two rectangular blocks of cells: one covering
cells A1 through A5 and the other covering cells F1 through G5.
Selecting a Range
You can select adjacent and nonadjacent ranges of cells with your mouse, just as you
selected individual cells. Selecting a range enables you to work with all of the cells in
the range as a group. This means you can move the groups of cells, delete them, or clear
all their contents at the same time.
Selecting Ranges
To select an adjacent range:
• Click the cell in the upper-left corner of the adjacent range, drag the pointer
to the cell in the lower-right corner of the adjacent range, and then release the
mouse button.
or
• Click the cell in the upper-left corner of the adjacent range, press the Shift key as
you click the cell in the lower-right corner of the adjacent range, and then release the
Shift key.
To select a nonadjacent range of cells:
• Select a cell or an adjacent range, press the Ctrl key as you select each additional cell
or adjacent range, and then release the Ctrl key.
To select all the cells in a worksheet:
• Click the Select All button located at the intersection of the row and column headings
(or press the Ctrl+A keys).
To select an entire row or entire rows:
• Click a row heading to select a single row. To select multiple rows, click and drag the
pointer over multiple row headings.
To select an entire column or entire columns:
• Click a column heading to select a single column. To select multiple columns, click and
drag the pointer over multiple column headings.
You’ll use the pointer to select the adjacent range A1:G5, which includes all the
content you entered in the orders worksheet.
Search JabSto ::




Custom Search