Microsoft Office Tutorials and References
In Depth Information
Entering Multiple Lines of Text Within a Cell
Figure 1-6
Text entered for customer orders
text is left-ali gned
within cells
text cov ers the
adjacent empty cell
As you type text into the active cell, Excel tries to anticipate the remaining
characters by displaying text that begins with the same letters as a previous entry in the same
column. This feature, known as AutoComplete , helps make entering repetitive text easier.
To accept the suggested text, press the Tab or Enter key. To override the suggested text,
continue to type the text you want to enter in the cell. AutoComplete does not work with
dates or numbers, or when a blank cell is between the previous entry and the text you’re
Entering Multiple Lines of Text Within a Cell
Addresses are often entered on two or more separate lines. Amanda wants you to follow
that convention with her customers’ addresses. To place text on separate lines within the
same cell, you press and hold the Alt key while you press the Enter key. This creates a
line break within the cell.
You’ll enter the address for the fi rst RipCity Digital customer, which will occupy two
lines within the same cell.
To enter multiple lines of text within a cell:
1. Type 402 Elm St. in cell C2, but do not press the Tab or Enter key. Instead, you’ll
insert a new line break.
2. Hold down the Alt key and press the Enter key, and then release both keys. The
insertion point moves to a new line within cell C2.
Be sure to hold down the
Alt key as you press
Enter; otherwise, only the
first address line will be
entered in cell C2.
3. Type Merrill, MI 48637 on the new line, and then press the Tab key. The two
lines of text are entered in cell C2, and cell D2 becomes the active cell. See
Figure 1-7.
Figure 1-7
Multiple lines of text entered in cell C2
text is wrapp ed
within the cell
Search JabSto ::

Custom Search