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.
Step 2: In the Home tab you select Wrap Text in Alignment , the cells you select will be automatically down the line.
The following results:
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.
Step 2: Press the key combination Alt + Enter , you will get the following results:
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!