Microsoft Office Tutorials and References
In Depth Information
Using the Fill Handle to Copy a Cell to Adjacent Cells
3
Release the mouse
button to copy the
SUM function from
the active cell to the
destination area and
calculate the sums
(Figure 1– 22).
heavy border
and transparent
blue background
indicate range
B9:G9 remains
selected
SUM function
SUM(G4:G8)
assigned to cell
calculates value
Auto Fill Options
button remains
on-screen until
you begin next
activity
no transparent blue
background for cell B9
because it is the active cell
SUM function
SUM(C4:C8)
assigned to cell
calculates value
SUM function
SUM(D4:D8)
assigned to cell
calculates value
SUM function
SUM(E4:E8)
assigned to cell
calculates value
SUM function
SUM(F4:F8)
assigned to cell
calculates value
Figure 1–22
What is the purpose of the Auto Fill Options button?
When you copy one range to another, Excel displays an Auto Fill Options button
(Figure 1– 22). The Auto Fill Options button allows you to choose whether you want to copy
the values from the source area to the destination area with formatting, do so without
formatting, or copy only the format. To view the available i ll options, click the Auto Fill
Options button. The Auto Fill Options button disappears when you begin another activity
in Excel, such as typing data in another cell or applying formatting to a cell or range of cells.
Other Ways
1. Select source area, click
Copy button (Home tab |
Clipboard group), select
destination area, click
Paste button (Home tab |
Clipboard group)
2. Right-click source area,
click Copy on shortcut
menu, right-click
destination area, click
Paste on shortcut menu
3. Select source area and
then point to border of
range; while holding
down CTRL , drag source
area to destination area
To Determine Multiple Totals at the Same Time
The next step in building the worksheet is to determine the lifetime fundraising totals for each fundraising
activity and total lifetime fundraising for the organization in column H. To calculate these totals, you can use the
SUM function much as it was used to total the lifetime fundraising amounts by city in row 9. In this example,
however, Excel will determine totals for all of the rows at the same time. The following steps sum multiple totals
at once.
 
Search JabSto ::




Custom Search