Microsoft Office Tutorials and References
In Depth Information
Using the Fill Handle to Copy a Cell to Adjacent Cells
1
Click cell H4 to make
it the active cell
(Figure 1– 23).
mouse pointer is
block plus sign
H4 is active cell
Figure 1–23
2
With the mouse
pointer in cell H4 and
in the shape of a block
plus sign, drag the
mouse pointer down
to cell H9 to highlight
the range with a
transparent view
(Figure 1– 24).
range H4:H9
selected
Figure 1–24
3
Home tab
Sum button
Click the Sum button
(Home tab | Editing
group) to calculate
and display the sums
of the corresponding
rows (Figure 1– 25).
Select cell A10 to
Editing group
deselect the selected
range.
How does Excel create
unique totals for each
row?
If each cell in a
selected range is next
to a row of numbers,
Excel assigns the SUM function to each
cell when you click the Sum button.
totals for each
row of numbers
Figure 1–25
 
Search JabSto ::




Custom Search