Microsoft Office Tutorials and References
In Depth Information
To Copy Formulas with Absolute Cell References Using the Fill Handle
Drag the fi ll handle
to the right to select
the destination area
C5:G16 to copy the
formulas from the
source area (B5:B16)
to the destination
area (C5:G16) and
display the calculated
amounts and Auto
Fill Options button
(Figure 3–32).
columns B (January),
C (February), and
D (March) do not
What happens to
the formulas after
the copy is made?
Because the formulas
in the range B5:B16
use absolute cell
references, the
formulas still refer
to the current values
in the Assumptions
table when the
formulas are copied
to the range C5:G16.
source area
B5:B16 copied
to destination
area C5:G16
projected June expenses
based on projected June sales
(cell G4) and assumptions in
range B19:B25
Auto Fill
Options button
What happened to
columns B, C, and D?
As shown in
Figure 3–32, as
the fi ll handle is
dragged to the
right, columns B, C,
and D no longer
appear on the screen. Column A, however, remains on the screen, because the row titles
were frozen earlier in this chapter.
Figure 3–32
Search JabSto ::

Custom Search