How to wrap text in an Excel cell - Wrap text in an Excel cell

You enter data for cells in Excel, but many long data cells should not display all the data. So you want to make a new line break in Excel so that the data is fully displayed in one cell. For those of you who do not know how to create a newline in an Excel cell, you can refer to the following article.

The article shows two ways to wrap text in an Excel cell.

Method 1: Use Wrap Text (automatic line break) to wrap text automatically.

Step 1: You select the cell to break the line.

How to wrap text in an Excel cell - Wrap text in an Excel cell Picture 1

Step 2: In the Home tab you select Wrap Text in Alignment , the cells you select will be automatically down the line.

How to wrap text in an Excel cell - Wrap text in an Excel cell Picture 2

The following results:

How to wrap text in an Excel cell - Wrap text in an Excel cell Picture 3

Method 2: Use the key combination Alt + Enter.

You want to go down the line from the position you want, as in the example above you want to break the line from Thai Binh to the bottom line to make it easier for you to see the following:

Step 1: Put the cursor in the position you want to go down the line.

How to wrap text in an Excel cell - Wrap text in an Excel cell Picture 4

Step 2: Press the key combination Alt + Enter , you will get the following results:

How to wrap text in an Excel cell - Wrap text in an Excel cell Picture 5

So with Alt + Enter you can go to any line in the line, this is the most common way to make a new line in a cell in Excel. But if you need quick editing and lots of data cells, using Wrap Text for automatic line breaks is also a good choice. Good luck!