2020. 11. 9. 15:33ㆍ카테고리 없음
Microsoft Excel can wrap text so it appears on multiple lines in a cell. You can format the cell so the text wraps automatically, or enter a manual line break.
In Microsoft Excel, if you manually modify the height of a row, and you then format a cell in that row to Wrap Text, Microsoft Excel does not change the height of the row to fit all the text in the cell. The spreadsheet has two columns, 100 rows, all in text format, words of 8 to 12 characters separated by blank spaces, all text wrapped, no merged cells (I repeat: NO merged cells), each cell with maximum 60 characters. Column “A” has all cells with font Arial, 11, bold. Column “B” has all cells with font Arial, 10, normal (not bold).
Wrap text automatically
In a worksheet, select the cells that you want to format.
On the Home tab, in the Alignment group, click Wrap Text .
Notes:
Data in the cell wraps to fit the column width, so if you change the column width, data wrapping adjusts automatically.
If all wrapped text is not visible, it may be because the row is set to a specific height or that the text is in a range of cells that has been merged.
Adjust the row height to make all wrapped text visible
Select the cell or range for which you want to adjust the row height.
On the Home tab, in the Cells group, click Format.
Under Cell Size, do one of the following:
To automatically adjust the row height, click AutoFit Row Height.
To specify a row height, click Row Height, and then type the row height that you want in the Row height box.
Tip: You can also drag the bottom border of the row to the height that shows all wrapped text.
Enter a line break
To start a new line of text at any specific point in a cell:
How To Wrap Text Excel
Double-click the cell in which you want to enter a line break.
Tip: You can also select the cell, and then press F2.
In the cell, click the location where you want to break the line, and press Alt+ Enter.
Why Is Wrap Text Not Working
Need more help?
Wrap Text Not Working In Word
You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.