What-If Analysis, Charting, And Working With Large Worksheets Page 32
ADVERTISEMENT
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87EX 168
Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets
To Copy Formulas with Absolute Cell References Using the Fill Handle
The following steps use the fi ll handle to copy the July formulas in column B to the other fi ve months in
columns C through G.
1
•
Select the range
B14:B25 and then
point to the fi ll handle
in the lower-right
corner of the selected
cell, B25 in this
case, to display the
crosshair mouse
source area
is B14:B25
pointer (Figure 3 –32).
mouse pointer
changes to
cross hair
Figure 3 – 32
2
•
Drag the fi ll handle to
the right to copy the
formulas from the
columns B (July),
source area, B14:B25
C (August), and
in this case, to the
D (September)
do not appear
destination area,
C14:G25 in this case,
and display the
calculated amounts
and Auto Fill Options
button (Figure 3 –33).
source area
B14:B25 copied
to destination
What happens to
area C14:G25
the formulas after
performing the copy
projected December expenses
based on projected December
operation?
revenue (cell G4) and
assumptions in range B2:B8
Because the formulas
in the range B14:B25
use absolute cell
references, the
Auto Fill
formulas still refer to
Options button
the current values in
Figure 3 – 33
the Assumptions table
when the formulas are copied to the range C14:G25.
What happened to columns B, C, and D?
As shown in Figure 3 – 33, as the fi 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.
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education