Microsoft Office Tutorials and References
In Depth Information
Rotating Text and Using the Fill Handle to Create a Series
• Lift your nger or release the
mouse button to change the
width of the column.
• Tap or 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 pointer to the boundary
between column headings B and
C in preparation of resizing column B and then drag the pointer to the right until the ScreenTip displays the desired
width, Width: 14.50 (121 pixels) in this case. Do not lift your nger or release the mouse button (Figure 3 – 10).
proposed width of
columns B through G
columns B through
Figure 3 – 10
• Lift your nger or 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 18.00.
1 ENTER HEADINGS & DATA | 2 ENTER FORMULAS & FUNCTIONS | 3 CREATE SPARKLINE CHARTS
4 FORMAT WORKSHEET | 5 CREATE COLUMN CHART | 6 CHANGE VIEWS | 7 ASK WHAT - IF QUESTIONS
To Enter and Indent Row Titles
Excel allows you to indent text in cells. The following steps enter the row titles in column A and indent
several of the row titles to create a visual hierarchy. Why? Often, indentation sets off titles, such as row titles, from
other titles to create a hierarchy, such as you may nd in a table of contents in a book.
• If necessary, scroll the worksheet
so that column A and row 4 are
visible and then enter the row
titles in the range A4:A16 but
without the indents, as shown in
Figure 3 – 11.
• Select cell A5 and then tap or
click the Increase Indent button
(HOME tab | Alignment group) to
increase the indentation of the
text in the selected cell.
• Select the range A9:A13
and then tap or 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 A18 to nish entering
the row titles and deselect the current cell.
Figure 3 – 11
What happens when I tap or click the Increase Indent button?
The Increase Indent button (HOME tab | Alignment group) indents the contents of a cell to the right by two spaces each
time you tap or click it. The Decrease Indent button decreases the indent by two spaces each time you tap or click it.
1. Press and hold range and tap ‘Show Context Menu’ button on mini toolbar or right-click range, tap or click Format Cells on shortcut menu,
tap or click Alignment tab (Format Cells dialog box), tap or click Left (Indent) in Horizontal list, type number of spaces to indent in Indent box,
tap or click OK button (Format Cells dialog box)