Data Analysis with Microsoft Excel: Updated for Office 2007

16 Excel

3 With the CTRL key still pressed, select the range F4:F17.

The selected range is shown in Figure 1-12.

The cell reference for this group of cells is B4:B17;F4:F17, where the

semicolon indicates a joining of two distinct ranges.

Moving Cells

Excel allows you to move the contents of your cells around without affect-

ing their values. This is a great help in formatting your worksheets. To move

a cell or range of cells, simply select the cells and then drag the selection

to a new location. Try this now with the table of usage data from the Total

Usage worksheet.

To move a range of cells:

1 Select the range B4:F17.

2 Move the mouse pointer to the border of the selected area so that the

pointer changes from a to a.

ranges B4:B17 and

F4:F17 are selected

Figure 1-12

Noncontiguous
cell range