What-If Analysis, Charting, And Working With Large Worksheets Page 11
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
87What-If Analysis, Charting, and Working with Large Worksheets
Excel Chapter 3
EX 147
4
•
Drag the fi ll handle to
the right to select the
range to fi ll, C10:G10
in this case. Do not
release the mouse
button (Figure 3– 7).
fi ll handle dragged
ScreenTip indicates
to cell G10
proposed value of
rightmost cell
Figure 3 – 7
5
•
Release the mouse
button to create a
month name series
in the selected range
and copy the format
of the selected cell to
the selected range.
•
Click the Auto Fill
Options button
below the lower-right
corner of the fi ll area
to display the Auto
format of cell B10
applied to range
Fill Options menu
C10:G10
months propagated
(Figure 3 – 8).
using fi ll handle
What if I do not want
to copy the format of
Auto Fill Options
cell B10 during the
button
auto fi ll operation?
In addition to creating
a series of values,
dragging the fi ll
Auto Fill Options
menu
handle instructs Excel
to copy the format of
cell B10 to the range
C10:G10. With some
fi ll operations, you
Figure 3 –8
may not want to copy
the formats of the
source cell or range to the destination cell or range. If this is the case, click the Auto Fill
Options button after the range fi lls and then select the option you desire on the Auto Fill
Options menu (Figure 3 – 8).
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education