Microsoft Office Tutorials and References
In Depth Information
Using the Fill Handle to Copy a Cell to Adjacent Cells
Table 1– 2 Sum Function Entries in Row 6
Cell
SUM Function Entries
Result
B6
=SUM(B4:B5)
Sums cells B4 and B5
C6
=SUM(C4:C5)
Sums cells C4 and C5
D6
=SUM(D4:D5)
Sums cells D4 and D5
E6
=SUM(E4:E5)
Sums cells E4 and E5
F6
=SUM(F4:F5)
Sums cells F4 and F5
G6
=SUM(G4:G5)
Sums cells G4 and G5
H6
=SUM(H4:H5)
Sums cells H4 and H5
I6
=SUM(I4:I5)
Sums cells I4 and I5
J6
=SUM(J4:J5)
Sums cells J4 and J5
K6
=SUM(K4:K5)
Sums cells K4 and K5
L6
=SUM(L4:L5)
Sums cells L4 and L5
M6
=SUM(M4:M5)
Sums cells M4 and M5
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
.
1
ENTER
TEXT

2
CALCULATE
SUMS
&
USE
FORMULAS

3
SAVE
WORKBOOK

4
FORMAT
TEXT
5
INSERT
CHART

6
NAME
TAB

7
PREVIEW
&
PRINT
WORKSHEET
To Copy a Cell to Adjacent Cells in a Row
The easiest way to copy the SUM formula from cell B6 to cells C6:M6 is to use the fill handle.
Why?
Using the fill handle means that Excel creates the formulas for you.
The
fill handle
is the small black square located in
the lowerright corner of the heavy border around the active cell. The following steps use the fill handle to copy
cell B6 to the adjacent cells C6:M6.
1
•
With cell B6 active,
if you are using a
touch screen, press
and hold cell B6
to display the mini
toolbar, then tap
AutoFill on the
mini toolbar; if you
are using a mouse,
point to the fill
handle to activate
it (Figure 1– 19).
Why is my fill handle
not a black square?
If you are using a
touch screen, the fill
handle appears as
a black and white
rectangle with a
blue down arrow
in it.
pointer changes to crosshair
indicating fill handle is selected
Figure 1– 19