9 easiest ways to add line breaks in Excel

There are many ways to wrap text in Excel, depending on the content and requirements for wrapping text in Excel. We can adjust to wrap text in an Excel cell while still seeing the content clearly. Or set up automatic wrapping in Excel. The following article will guide you through wrapping text in Excel.

Table of Contents

• Method 1: Line break in an Excel cell using Alt + Enter
• Method 2: Line breaks in Excel using Wrap Text
• Method 3: Adjust in Format Cells to line break Excel
• Method 4: Line breaks in Microsoft Excel using Find & Replace
• Method 5: Instructions for adding a line break in an Excel cell using the ChAR function
• Method 6: How to add a line break in an Excel cell when concatenating strings
• 7. Line breaks in Excel using the Justify function
• 8. Line break in Excel using SUBSTITUTE function to join characters
• 9. How to wrap text in an Excel cell on iPhone, Android
• Video tutorial on line breaks and line breaks in Excel cells

Method 1: Line break in an Excel cell using Alt + Enter

If you need to write multiple lines in an Excel cell, to break the line in Excel, place the mouse at the position where you want to break the line and press the Excel shortcut key combination Alt + Enter on Windows or Command + Enter on macOS.

For example, when entering content as shown in the image, long content will overflow to the right. To break the line to the content below, place the mouse cursor at the position where you want to break the line, then press Alt + Enter to break the line.

The result will be as shown below. The content has been put into 1 cell. Then we proceed to edit and align the content to fit.

Method 2: Line breaks in Excel using Wrap Text

More precisely, Wrap Text is a way to wrap content in a cell, preventing the text from overflowing into other cells. You enter content into an Excel cell, then click on the cell where the content has been entered, then click on Wrap Text above as shown.

The content will also wrap as shown. You can realign the content to have a more beautiful layout.

Method 3: Adjust in Format Cells to line break Excel

Step 1:

You click on the text entered in Excel, then right-click and select Format Cells... from the list that appears.

Step 2:

A new dialog box appears. Here, click the Alignment tab and check Wrap text as shown below.

In addition, here you can customize more with the cell such as centering the content, creating corners, changing fonts, creating frames for the cell... Click OK to save.

Step 3:

The text content will also be moved to the next line without going to another column. At the same time, the content in the line will also be automatically aligned without us having to edit it manually.

If you want the content in an Excel cell to be automatically aligned, adjust in Format Cells, the content will be adjusted to fit the width of the column containing it.

Method 4: Line breaks in Microsoft Excel using Find & Replace

Sometimes, practical requirements force you to continuously add line breaks after certain characters or letters. So what to do?

First, highlight all the cells where you want to insert a line break.

Look up at the toolbar, find the “ Home ” tab and click on it. A corresponding options menu will immediately open. Here, you navigate to Find & Select > Replace . If you don’t want to use the mouse, you can also press Ctrl+H to quickly access this Find & Select dialog box.

In the dialog box that appears in the middle of the screen, in the “ Find what ” text field, type the character you are looking for. In the example below, what we are looking for is the comma that is used to separate the person’s name and title.

In the “ Replace with ” field, press Ctrl + J to add a new line break. This will insert a line break in place of each comma.

Now, click on the “ Replace All ” button at the bottom to replace all commas with newline breaks.

Method 5: Instructions for adding a line break in an Excel cell using the ChAR function

You can use this function to wrap text in a cell when there is long text.

In the cell with the content that needs to be broken into new lines, enter the function content ="Phung Khac Khoan" & CHAR(10) & " Thach That" as shown below and press Enter. Then the content is entered into the Excel cell.

Next, you just need to click on the Wrap Text box above so that the characters in an Excel cell wrap to a new line as shown below.

The result of the content in an Excel cell has a new line as shown below.

Method 6: How to add a line break in an Excel cell when concatenating strings

For example, we will concatenate the string in each cell and then add a new line for each character.

We enter the string concatenation formula =B12&CHAR(10)&C12&CHAR(10)&F12&CHAR(10)& and then press Enter.

The strings are then concatenated together as shown below.

Next, we just need to click on Wrap Text to wrap the text in an Excel cell.

7. Line breaks in Excel using the Justify function

Line breaks in Excel using the Justify function are not too difficult to perform.

Step 1:

Highlight the content you want to break into new lines, then right-click on the cell and select Format Cells in the displayed list.

Step 2:

Display the customization interface. You click on the Alignment tab to do it.

Next, look down under the Horizontal section , click on the arrow and then click Justify in the displayed list. Finally, click OK to save.

As a result, we will see the content wrapped as shown below.

8. Line break in Excel using SUBSTITUTE function to join characters

For example, we have an example like the picture. The requirement is to go down to the line of Instructions to combine the content into 1 and remove the spaces.

We will enter the formula in a new line =SUBSTITUTE(C34,CHAR(10)," ") and then press Enter to execute.

As a result, we will see the content go to the next line and form a row as shown below.

9. How to wrap text in an Excel cell on iPhone, Android

The mobile version of Excel also has a line break option for you to quickly use for content in your spreadsheet.

Step 1:

We click on the content that needs a line break, then click on the 3-dot icon in the toolbar below as shown.

Step 2:

Display options for document content, you continue to click on the Text Wrap option . Immediately we see the content wrap in the Excel cell depending on the size of the cell as shown below.

Step 3:

Continue clicking on Merge & Center to center the content you want to wrap.

This way the cell content will look nice in the middle of the line.

Video tutorial on line breaks and line breaks in Excel cells

When using Excel, with long or simple content, we want to center the content to display more balanced, we need to go to the line. However, going to the line in Excel is not the same as in Word where you just need to press Enter to finish.

Hopefully with the above Excel line break instructions your spreadsheet will be more beautiful and professional.