Microsoft Office Tutorials and References
In Depth Information
Rotating Text and Using the Fill Handle to Create a Series
proposed width of
columns B through F
Columns B through
Release the mouse button to change
the width of the column.
split double arrow
• the column and then drag through
column heading G to select the
range in which to change the widths.
Click column heading B to select
Move the mouse pointer to the
boundary between column headings
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).
Figure 3 –10
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 i 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.
If necessary, scroll the worksheet
so that column A and row 23 are
visible and then enter the row titles
in the range A11:A23 but without
the indents (Figure 3 – 11).
Select cell A12 and then click the
Increase Indent button (Home tab |
Alignment group) to increase the
indentation of the text in the
Select the range A16:A20
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).
Select cell A1 to i 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.
1. To indent, right-click
range, click Format Cells
on shortcut menu, click
Alignment tab (Format
Cells dialog box), click Left
(Indent) in Horizontal list,
type number of spaces to
indent in Indent text box,
click OK button (Format
Cells dialog box)