Page 21 - Excel Data Analysis

02 537547 Ch01.qxd 3/4/03 11:45 AM Page 7

GETTING STARTED WITH EXCEL 1

SELECT A RANGE OF CELLS

ou can make modifications to several cells in a To select an entire row or column, you simply
worksheet simultaneously, a process referred to as
Y selecting a range of cells, by choosing all the related click the corresponding identifier. For example,
cells together before implementing the changes. Typically, to select all cells in column C, you click the C
you select a range of cells to apply different formatting identifier for the column. To select multiple
options, to copy cells, or to change the Excel value type. columns, you click the first column and then
The range of cells does not need to be contiguous; you can continue holding down the mouse button as
select cells from different locations in a worksheet. See the you drag to the other columns you want to
section "Copy and Paste a Range of Cells" for information select. To select entire rows, you click the row
on copying a range of cells. See the section "Create a identifiers on the left side of each row.
Custom Number Format" for more information on
formatting cells. You can select a smaller group of cells by clicking
a cell in one corner of the desired selection
You can select anywhere from a single cell to the entire range, holding down the mouse button, and
worksheet. Excel highlights the group of cells to remind you dragging until you select the desired range.
of your selection. If you select multiple ranges of cells
simultaneously, Excel highlights each selected range. To select a noncontiguous range of cells, select
the first block of cells, and then press the Ctrl
key and select the next block. If you do not hold
down the Ctrl key, Excel unselects the first range
of cells when you select a new range of cells.

SELECT A RANGE OF CELLS

⁄ Click the corner of the ‹ Press Ctrl. ■ Excel highlights each of ■ Any changes you make
first block of cells. the selected cell blocks. affect only the highlighted
› Select the next block of cells.
¤ Drag the mouse to cells.
highlight the desired cells.
■ Repeat steps 3 and 4 to
select all cell blocks.
7