Microsoft Office Tutorials and References
In Depth Information
Entering Text in a Cell
• Click the Enter box to complete the
entry and enter the worksheet title
in cell A1 (Figure 1–21).
Enter box and
Cancel box no
into cell A1
• Click cell A2 to select it.
• Type First Quarter Rock-It
MP3 Sales as the cell entry.
• Click the Enter box to complete
the entry and enter the worksheet
subtitle in cell A2 (Figure 1–22).
into cell A2
1. To complete entry, click
any cell other than
2. To complete entry, press
3. To complete entry, press
HOME, PAGE UP, PAGE
DOWN, or END key
4. To complete entry, press
UP, DOWN, LEFT, or
When you complete a text entry into a cell, a series of events occurs. First, Excel
positions the text left-aligned in the cell. Left-aligned means the cell entry is positioned
at the far left in the cell. Therefore, the W in the worksheet title, Walk and Rock Music,
begins in the leftmost position of cell A1.
Second, when the text is longer than the width of a column, Excel displays the
overﬂ ow characters in adjacent cells to the right as long as these adjacent cells contain
no data. In Figure 1–22, the width of cell A1 is approximately nine characters. The text
consists of 19 characters. Therefore, Excel displays the overﬂ ow characters from cell A1 in
cells B1 and C1, because cells B1 and C1 are empty. If cell B1 contained data, Excel would
hide the overﬂ ow characters, so that only the ﬁ rst nine characters in cell A1 would appear