What-If Analysis, Charting, And Working With Large Worksheets Page 9
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 145
To Rotate Text and Use the Fill Handle to Create a Series of Month Names
The design of the worksheet calls specifi cally for only six months of data. Because there always will be only six
months of data in the worksheet, the months should be placed across the top of the worksheet as column headings
rather than as row headings. The data for the worksheet includes more data items regarding each month than there
are months, and, possibly, more expense categories could be added in the future. A proper layout, therefore, includes
placing each month as column headings.
When you fi rst enter text, its angle is zero degrees (0°), and it reads from left to right in a cell. Excel allows
you to rotate text in a cell counterclockwise by entering a number between 1° and 90°.
The following steps enter the month name, July, in cell B10; format cell B10 (including rotating the text); and
then use the fi ll handle to enter the remaining month names in the range C10:G10.
Home tab active
1
•
If necessary, select the
Home tab and then
Format Cells
dialog box
select cell B10 because
this cell will include
the fi rst month name
in the series of month
Orientation area
names.
July
•
Type
as the
cell entry and then
click the Enter box.
•
Click the Format Cells:
Note: To help you
Alignment Dialog Box
locate screen elements
that are referenced in
Launcher (Home tab |
the step instructions,
Alignment group) to
such as buttons and
commands, this book
display the Format
uses red boxes to
Cells dialog box
point to these screen
(Figure 3 – 4).
cell B10 selected
elements.
Figure 3 – 4
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education