Microsoft Office Tutorials and References
In Depth Information
Using the Fill Handle to Copy a Cell to Adjacent Cells
To place the SUM functions in cells C9, D9, E9, F9, and G9, you could follow the
same steps shown previously in Figures 1–18 on page EX 15 and 1–19. A second, more
efi cient method, however, is to copy the SUM function from cell B9 to the range C9:G9.
The cell being copied is called the source area or copy area . The range of cells receiving
the copy is called the destination area or paste area .
Although the SUM function entries in Table 1– 2 are similar, they are not exact
copies. The range in each SUM function entry uses cell references that are one column
to the right of the previous column. When you copy formulas that include cell references,
Excel automatically adjusts them for each new position, resulting in the SUM function
entries illustrated in Table 1– 2. Each adjusted cell reference is called a relative reference .
To Copy a Cell to Adjacent Cells in a Row
The easiest way to copy the SUM formula from cell B9 to cells C9, D9, E9, F9, and G9 is to use the i ll
handle. The i ll handle is the small black square located in the lower-right corner of the heavy border around
the active cell. The following steps use the i ll handle to copy cell B9 to the adjacent cells C9:G9.
With cell B9 active,
point to the i ll
handle to activate
it (Figure 1– 20).
mouse pointer changes to crosshair
indicating i ll handle is selected
Drag the i ll handle to
select the destination
area, range C9:G9,
to display a shaded
border around the
source area and the
(Figure 1– 21). Do not
release the mouse
as dragging takes place,
Excel displays a shaded
border around destination
area and source area