In the process of creating Excel, the line break is not as simple as a word. when you know how to cut a row in an excel cell reasonable will help readers easily grasp the content. There are several ways to add a line break in an Excel cell. However, in this article, we will suggest 4 simple and most common methods that can be applied in all versions of Excel.

How to cut a line in an Excel cell with Alt + Enter

The easiest way if you want to cut a line in an Excel cell is to use the keyboard shortcut Alt + Enter if you are using the Windows operating system, and on macOS, use the Command + Enter key.

For example, the image below when you enter long content, it will overflow to the right. Now to break the content at the line below, click on the position where you want to break the line break. Next, press the Alt + Enter keyboard shortcut to get a line break.

Use the Alt + Enter key combination to cut the line of the content you want

After following the above instructions, you will get the result as shown below. At this point, please align the content to be appropriate and balanced.

With Alt + Enter keyboard shortcut, you can easily enter a row in 1 cell when using Excel

How to cut a line in an Excel cell with Wrap Text

Using Wrap Text is also one of the easiest ways to break lines in an Excel cell. To be more specific, it’s a way to encapsulate content in a cell when using Excel, so the text doesn’t overflow into other cells.

Wrapping content with Wrap Text is very simple. Please enter the contents in an Excel cell you want.

Enter content into a cell in excel

After entering the content, click on the cell that entered this content and click on Wrap Text. At this point, you will get the result of presenting the content which has been encapsulated in 1 box as shown below. Now align the cell content to have the best layout.

Click Wrap Text

Excel line breaks by fitting in format cells

In addition to the above two ways to get new rows in Excel, you can adjust the format of cells. The way to do it is very simple as follows:

• Step 1: Click on the content entered in the box and then right click. At this point, the options will appear as shown below.

Right click on the content cell and select Format Cells

• 2nd step: In the new dialog interface, select Alignment and check the Wrap text item. Moreover, in this dialog panel, you can customize more features like: Create corners, center content, create frames… then click OK to save as shown below.

Select Alignment and check the Wrap text box then select ok

At this point you will see your content wrapped in an Excel cell as shown below. In particular, the content will also be automatically adjusted and aligned to the cell width.

Content has been wrapped and aligned in an excel cell

How to break rows after specific characters in Excel

When using Excel, you may sometimes need to enter a continuous line after certain characters or letters. At this point, apply the following line break.

• Step 1: First, highlight the entire content cell whose row you want to break.

Highlight the content cell that requires a line break

• 2nd step: Then press Ctrl + H to open Find and Select dialog box as shown below.

Find and Select dialog box

Now in the Search field, enter the character you need to search for in the content. The example here we are looking for is the space used to separate words in text.

In the Search field, enter a space

At Replace With, press Ctrl and J simultaneously to add a new line. This is the step to insert a new line instead of spaces in the text.

To Replace with, press Ctrl and J simultaneously

• Step 3: Now click on Replace All box to replace all spaces with newline and get the result as below screenshot shown.

Line break letters after execution

So the above item we suggested to you 4 Ways to Break Rows in 1 Single Excel Cell. Hope these shares help you in the process of using Excel.