Microsoft Office Tutorials and References
In Depth Information
Entering text in cells
Entering text in cells
No workbook worthy of the name stays empty for long. You can
type any sort of text you want directly in a cell, whether the text
is a label identifying the data in a row or column or an
explanation reminding you and your colleagues of any limitations
on the data to be entered in a cell. Most text entered in Excel
workbooks is short enough to fit on one line, but if you want to
have the text in a cell appear on two or more lines and break at
a specific location, you can easily insert a line break.
Enter text as one line
1 Click the cell in which you want to enter text.
2 Type the text that you want to appear.
3 Press Enter.
2
1
Enter text with forced line breaks
1 Click the cell in which you want to enter text.
2 Type the text that you want to appear on the first line. Press
Alt+Enter to insert a line break.
3 Type the text that you want to appear on the second line, and then
press Enter.
1
2
3
TIP In Excel 2013, the formula bar doesn’t automatically
expand to display all the information in a cell. To scroll through
the contents of the formula bar one line at a time, use the scroll
buttons at the right edge of the formula bar. To display the formula
bar’s entire contents, click the Expand Formula Bar control to the right
of the formula bar. When you expand the formula bar, the Expand
Formula Bar control changes to the Collapse Formula Bar control;
clicking it returns the formula bar to its original one-line height.
SEE ALSo For information about how to make your columns
wider to allow more text to appear within a cell, see “Resize a
column” on page 160.
Search JabSto ::




Custom Search