Microsoft Office Tutorials and References
In Depth Information
Using the Fill Handle to Copy a Cell to Adjacent Cells
• Repeat Steps 1–3
to copy the SUM
cell B17 to the
(Figure 1– 22).
SUM function entered in range C17:M17
Figure 1– 22
1. Select source area, tap or click Copy button (HOME tab | Clipboard
group), select destination area, tap or click Paste button (HOME
tab | Clipboard group)
2. Press and hold or right-click source area, tap or click Copy on shortcut
menu; press and hold or right-click destination area, tap or click Paste
on shortcut menu
To Determine Multiple Totals
at the Same Time
1 ENTER TEXT | 2 CALCULATE SUMS & USE FORMULAS | 3 SAVE WORKBOOK | 4 FORMAT TEXT
5 INSERT CHART | 6 NAME TAB | 7 PREVIEW & PRINT WORKSHEET
The next step in building the worksheet is to determine the budget item totals for each budget item and
total income and expenses in column N. To calculate these totals, you can use the SUM function much as it was
used to total the budget items for each month in rows 6 and 17.
In this example, however, Excel will determine totals for all of the rows at the same time. Why? By
determining multiple totals at the same time, the number of steps to add totals is reduced. The following steps sum
multiple totals at once.
• Tap or click cell N4
to make it the active
cell (Figure 1– 23).
pointer is block
cell N4 is
Figure 1– 23