+5 votes
85 views
in Office by (242k points)
reopened
Excel: Insert a line break in a cell

1 Answer

+3 votes
by (1.6m points)
 
Best answer

Automatic breaking
Enter a line break manually

For a better overview, you can also insert line breaks in Excel cells. We explain how to do this here..

image image

In Microsoft Excel, you can use a line break to format text in a cell so that it appears on multiple lines within the cell. You can decide whether the text should be wrapped automatically or whether you want to enter the line break manually. You can do both in next to no time if you follow our instructions.

Automatic breaking

In your Excel document, select all of the cells that you want to format. Then click in the " Start " tab on the button for the line break, also " Text break ".

image

Enter a line break manually

To insert a line break manually, double-click the cell and move the cursor to the position in the text where the break should be inserted. Then press [Alt] + [Enter] ..

image

...