What-If Analysis, Charting, And Working With Large Worksheets Page 14
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 150
Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets
2
proposed width of
Columns B through
columns B through F
F selected
•
Release the mouse button to change
the width of the column.
split double arrow
mouse pointer
•
Click column heading B to select
the column and then drag through
column heading G to select the
range in which to change the widths.
•
Move the mouse pointer to the
boundary between column headings
Figure 3 – 10
B and C in preparation of resizing
column B, and then drag the mouse to the right until the ScreenTip displays the desired
width, Width: 14.88 (124 pixels) in this case. Do not release the mouse button (Figure 3 –10).
3
•
Release the mouse button to change the width of the selected columns.
•
If necessary, scroll the worksheet so that column H is visible and then use the technique
described in Step 1 to increase the width of column H to 16.00.
To Enter Row Titles
Excel allows you to indent text in cells. Often, indentation sets off titles, such as row titles, from other titles to
create a hierarchy, such as you may fi nd in a table of contents in a book. The following steps enter the row titles in
column A and indent several of the row titles.
1
Home tab
Decrease Indent
•
If necessary, scroll the worksheet
button
so that column A and row 23 are
visible and then enter the row titles
in the range A11:A23 but without
Alignment
the indents (Figure 3– 11).
group
•
Select cell A12 and then click the
Increase
Increase Indent button (Home tab |
Indent button
Alignment group) to increase the
indentation of the text in the
selected cell.
row titles
•
Select the range A16:A20
indented
row titles
and then click the Increase
Indent button (Home tab |
Alignment group) to increase
the indentation of the text in the
selected range (Figure 3 – 11).
2
•
Select cell A1 to fi nish entering the
Figure 3 – 11
row titles and deselect the current cell.
What happens when I click the Increase Indent button?
The Increase Indent button (Home tab | Alignment group) indents the contents of a cell to the right by three spaces each
time you click it. The Decrease Indent button decreases the indent by three spaces each time you click it.
Other Ways
1. To indent, right-click
Cells dialog box), click Left
click OK button (Format
range, click Format Cells
(Indent) in Horizontal list,
Cells dialog box)
on shortcut menu, click
type number of spaces to
Alignment tab (Format
indent in Indent text box,
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education