What-If Analysis, Charting, And Working With Large Worksheets Page 13
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 149
Custom Fill Sequences
Table 3 – 3 Examples of Series Using the Fill Handle
You can create your own
custom lists for use with the
Example
Contents of Cell(s) Copied
Next Three Values of Extended Series
fi ll handle. For example, if
Using the Fill Handle
you often type in the same
1
4:00
5:00, 6:00, 7:00
list of products or names
2
Qtr2
Qtr3, Qtr4, Qtr1
into Excel, you can create
a custom fi ll sequence.
3
Quarter 1
Quarter 2, Quarter 3, Quarter 4
You then can type the
4
22-Jul, 22-Sep
22-Nov, 22-Jan, 22-Mar
fi rst product or name and
5
2012, 2013
2014, 2015, 2016
then use the fi ll handle
automatically to fi ll in the
6
1, 2
3, 4, 5
remaining products or
7
625, 600
575, 550, 525
names. To create a custom
8
Mon
Tue, Wed, Thu
fi ll sequence, open the
Excel Options dialog box by
9
Sunday, Tuesday
Thursday, Saturday, Monday
clicking the Options button
10
4th Section
5th Section, 6th Section, 7th Section
in the Backstage view. Click
11
205,
208
211,
214,
217
the Advanced tab (Excel
Options dialog box) and
then click the Edit Custom
Lists button (Excel Options
To Increase Column Widths
dialog box).
In Chapter 2, you increased column widths after the values were entered into the worksheet. Sometimes,
you may want to increase the column widths before you enter the values and, if necessary, adjust them later. The
following steps increase the column widths.
1
•
Move the mouse
pointer to the
boundary between
column heading A
and column heading B
so that the mouse
pointer changes to
a split double arrow
in preparation of
adjusting the column
widths.
split double arrow
mouse pointer
•
Drag the mouse
pointer to the right
until the ScreenTip
displays the desired
column width, Width:
36.00 (293 pixels)
in this case. Do not
release the mouse
button (Figure 3– 9).
proposed width
of column A
Figure 3 –9
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education