Microsoft Office Tutorials and References
In Depth Information
Making Decisions — The IF Function
To Copy Formulas with Absolute Cell References Using the Fill Handle
The following steps use the i ll handle to copy the July formulas in column B to the other i ve months in
columns C through G.
Select the range
B14:B25 and then
point to the i ll handle
in the lower-right
corner of the selected
cell, B25 in this
case, to display the
crosshair mouse
pointer (Figure 3 – 32).
source area
is B14:B25
mouse pointer
changes to
cross hair
Figure 3 –32
Drag the i ll handle to
the right to copy the
formulas from the
source area, B14:B25
in this case, to the
destination area,
C14:G25 in this case,
and display the
calculated amounts
and Auto Fill Options
button (Figure 3 – 33).
columns B (July),
C (August), and
D (September)
do not appear
source area
B14:B25 copied
to destination
area C14:G25
What happens to
the formulas after
performing the copy
Because the formulas
in the range B14:B25
use absolute cell
references, the
formulas still refer to
the current values in
the Assumptions table
when the formulas are copied to the range C14:G25.
projected December expenses
based on projected December
revenue (cell G4) and
assumptions in range B2:B8
Auto Fill
Options button
Figure 3 –33
What happened to columns B, C, and D?
As shown in Figure 3 – 33, as the i ll handle is dragged to the right, columns B, C, and D no
longer appear on the screen because column A now acts just as the row numbers do in that
columns scrolled off of the visible portion of the worksheet disappear behind column A. Column A,
however, remains on the screen, because the row titles were frozen earlier in this chapter.
Search JabSto ::

Custom Search