How to create a newline in Excel 2020

During data entry in Excel, there is much longer content than the width of the cell, so the data is overflowed to other cells. So you want to go down the line so that the data is displayed in a full cell, making your Excel file more beautiful and easier to see. If you do not know how to make a new line in Excel, please refer to the following article.

How to create a newline in Excel 2020 Picture 1

The article guides in detail 3 ways to create new line breaks in Excel, you can work on all versions of Excel 2007, 2010, 2013, 2016.

Method 1: Use the key combination Alt + Enter

Using the Alt + Enter key combination, you can go down the line at any position in the cell that you want, you do the following:

Step 1: First you need to select the cell you need to go down, then place your cursor in the position you want to go down the line.

How to create a newline in Excel 2020 Picture 2

Step 2 : Press the key combination Alt + Enter on the keyboard to wrap the line, the content after the cursor will be down the line immediately.

How to create a newline in Excel 2020 Picture 3

You just need to adjust the content accordingly.

How to create a newline in Excel 2020 Picture 4

Method 2: Use the Wrap Text feature (automatic line breaks)

Using the Wrap Text feature , your content will be indented automatically, the position of the line depends on the width of the cell, meaning that the content does not show up enough on the line to be flowing down to the next line. another box. You can apply this feature to automatically line breaks multiple cells at once. To use Wrap Text, follow these steps:

Step 1: Select the cell you need to go down the line, you can select multiple cells to go down by pressing and holding Ctrl and using the mouse to select the cells you want to go to the next line.

How to create a newline in Excel 2020 Picture 5

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

How to create a newline in Excel 2020 Picture 6

To position the line with the content, you can adjust the width of the cell, then align the content accordingly.

How to create a newline in Excel 2020 Picture 7

Method 3: Customize Wrap Text feature in Format Cells.

This method is an extension of method 2, you can align the content, create the angle, change the font font, create the frame for the cell, . for the cell need to go down the line. You do the following:

Step 1: Select the cell you need to go down the line, then right-click -> Format Cells .

How to create a newline in Excel 2020 Picture 8

Step 2: The Format Cells dialog box appears , select the Alignment tab . To put a new line in a cell, select the checkbox in the square before Wrap text, and you can align the cell as you like with the features in Format Cells . Click OK after done.

How to create a newline in Excel 2020 Picture 9

The results of the cell you select will be inline and displayed according to what you align.

How to create a newline in Excel 2020 Picture 10

So you all know how to use simple and fast line breaks in Excel, hope this article will help you. Good luck!