Datasheet

Format Cells
(continued)
I
f the text you enter is too long to fit in a single cell,
Excel allows the text to spill over into an adjacent
cell. If you place text or data in the adjacent cell,
Excel cuts off the text in the original cell and you cannot
see all of it. If you want to display the text in the original
cell on multiple lines in a single cell, use the Excel Wrap
Text feature.
By default, data or text you enter in a cell displays
from left to right. You can change this by clicking the
Orientation button and selecting a new orientation.
You can angle your text or show your text vertically.
Titles provide a brief summary of your data and you may
want to center them over the data they summarize. You
can center text within a cell by using the Center button.
To center text across several cells, you can use the Merge
and Center button. In addition to being able to merge and
center, you can merge cells in Excel 2007 without
centering and you can merge several rows and columns
of cells into a single cell. If you want to return merged
cells to their original state, you can select the cells and
then click the Unmerge Cells option.
The Excel Ribbon also has several options you can use to
align text within a cell. You can align text with the top,
middle, or bottom of a cell and/or with the left, right, or
center of a cell.
MERGE AND CENTER
1 Click the Home tab.
2 Click and drag to select the cells
you want to merge and center.
3 Click the Merge and Center button
in the Alignment group.
1
2
2
3
1
Format Cells (continued)
12
•
Excel merges and centers your text.
WRAP TEXT
1 Click and drag to select the cells
whose text you want to wrap.
2 Click the Wrap Text button in the
Alignment group.
04_132296 ch01.qxp 5/24/07 12:53 PM Page 12