Microsoft Office Tutorials and References
In Depth Information
Working with Alignment and Spacing
Indenting Cell Data
What about those cells that you want left-aligned,
but not all the way to the edge? You could insert
some spaces in front of the text, but because of
font styles, the text doesn’t line up evenly. If you
insert spaces in front of values, Excel simply
ignores them. So what can you do? You can use the
Indent buttons. Just follow these steps:
If the data is left-aligned, Excel indents
to the left.
If the data is right-aligned, Excel
indents to the right.
If the data is centered, with the first
click Excel indents to the right, but
subsequent clicks cause Excel to move
the data to the left.
Select the cells you want to indent.
2. Choose Home>Alignment>Increase Indent.
Each Increase Indent click adds a small
amount of space between the cell border and
the data itself. See Figure 10-17, where cells
A5 through A7 and cells A11 through A15
are indented. How Excel indents depends on
how you format the cell:
Click the Decrease Indent button to remove
Wrapping Text in a Cell
The Wrap Text feature treats each cell like a
miniature word processor, with text wrapping around in
Decrease Indent Increase Indent
Select the cells you want to format.
2. Choose Home>Alignment>Wrap Text. As in
Figure 10-18, if the selected text cells contain
more text than will fit the width of the cell,
Excel displays it on multiple lines. Notice
that Excel automatically increases row height
to accommodate the additional text lines.
To force a new line of text in a wrapped cell,
press Alt+Enter where you want the new line
Indenting helps set data apart from other cells.