How To Apply Wrap Text In Excel

In that location are plenty of options to fit text in Excel but not all of them are obvious. Here's your choices for wrapping text, adding line breaks and merging cells.

At offset, when yous blazon text in a jail cell it just keeps going across the next cell, if it'due south empty.

Sure, you can drag the border of the column to make it bigger, merely you can only practise that so much earlier you start running out of room for your other columns. If there's only i cell in the column with longer text, information technology's a waste of infinite for the remainder of the cavalcade or it'll mess up the formatting for the rest of the worksheet.

Text flows outside cell boundary when the next cell is empty (row ane). If the next prison cell is used, the extra text is subconscious.

Never fear, at that place are four ways that you tin easily brand that text fit into the cell.

Enter line breaks manually.
Set the format of the prison cell so that it automatically wraps text.
Merge cells to make more than room
Reduce the font size (manifestly!).

Line Breaks inside a prison cell

It's non immediately obvious how to enter line breaks in Excel, because the Enter key doesn't work – information technology just takes you down to the side by side cell. Instead, in Excel yous demand to hitting Alt + Enter to make a line break. This will also automatically increment the height of the cell (and the row) to fit the number of lines you take entered.

Utilize Alt + Enter to insert a line break in a cell.

Adding line pause is proficient in headings to elegantly split the text.

The line break tin make editing the text confusing because it doesn't appear in a unmarried line. Click the wedge on the right to see two lines.

Wrapping Text

The quickest way to make the text in a cell automatically menstruation down to the side by side line is to click in the prison cell (or select multiple cells) and and then click the Wrap Text button under Habitation | Alignment.

Click the Wrap Text button to wrap the text in the jail cell

You can also accomplish the same thing in the Format Cells dialog, opened by right-clicking on a cell or highlighting multiple cells, and selecting Format Cells. So Alignment and tick the "Wrap text" box.

Once y'all've wrapped the text, if y'all then resize the column or row, the text volition e'er re-wrap itself to fit in with the new size of the cell.