Microsoft Office Tutorials and References
In Depth Information
Using the Fill Handle to Copy a Cell to Adjacent Cells
EX 27
To place the SUM functions in cells C9, D9, E9, and F9, you could follow the same
steps shown previously in Figures 1–32 through 1–34. A second, more effi cient method
is to copy the SUM function from cell B9 to the range C9:F9. 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 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, and F9 is to use the fi ll handle.
The fi 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 fi ll handle to copy cell B9 to the adjacent cells C9:F9.
With cell B9 active, point to the fi ll
handle (Figure 1–35).
mouse pointer
changes to cross
hair indicating fi ll
handle is selected
Figure 1–35
Drag the fi ll handle to select the
destination area, range C9:F9, to
display a shaded border around
the destination area, range C9:F9,
and the source area, cell B9
(Figure 1–36). Do not release the
mouse button.
as dragging takes place,
Excel displays border
around destination area
and source area
source area
(cell B9)
destination area
(range C9:F9)
Figure 1–36
Search JabSto ::

Custom Search