Microsoft Office Tutorials and References
In Depth Information
Note that when you press the Enter key, the active cell becomes cell A2, not cell G2.
Excel recognizes that when you enter a row of data and then press the Enter key, you have
completed the task of entering data in the current row, so the insertion point moves to the
start of the next row. If you had started entering data in cell C1 rather than A1, pressing
the Enter key would have made cell C2 the active cell.
Entering Several Lines of Text Within a Cell
In the next row, you’ll enter actual sales information. One cell in this row contains the
customer’s address. In Sandra’s records, this information is presented on two separate
lines, with the street address on one line and the city, state, and ZIP code on the other. To
place text on separate lines within the same cell, you press and hold the Alt key on the
keyboard while pressing the Enter key.
Entering Multiple Lines of Text Within a Cell
Click the cell in which you want to enter the text.
Enter a line of text.
Press and hold the Alt key, and then press the Enter key to move the insertion point to a
new line within the cell.
Enter the next line of text.
Press the Alt + Enter keys for each new line of text you need to enter within the cell.
Try this technique now by entering the first customer’s name and address.
To enter the address on two lines within a cell:
1. Verify that cell A2 is the active cell, type Alison Wilkes , and then press the Tab key to
move to column B, where you will enter the two-line address.
2. Type 45 Lincoln Street in cell B2, but do not press the Tab or Enter key.
3. Press and hold the Alt key, and then press the Enter key to insert a line break, moving the
insertion point to a new line within the cell.
4. Type Midtown , FL 80481 on the second line of the cell, and then press the Tab key.
Figure 1-10 shows the worksheet with the text you have entered so far.
Entering the customer name and address
row height i ncreases
to accommodate the text
text in this cell is cut off