Line Breaks In Excel

Article byWallstreetmojo Team
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

What Is A Line Break In Excel Cell?

Line break in Excel means inserting a new line in any cell value. Simply pressing the “Enter” key can take us to the next cell. We can use the keyboard shortcut, “ALT + Enter,” to insert a new line inside a cell to insert a line break. As we insert a line break, the cell’s height also increases as it represents the data in the cell.

For example, consider the below table.

With line breaks in Excel, our data appears as shown in the below image.

Key Takeaways

  • Line break in Excel refers to inserting a new line within a cell value. By simply pressing the “Enter” key, we can move to the next cell. One way to add a line break inside a cell is by using the “ALT + Enter” keyboard shortcut. This increases the cell’s height to display the enclosed data.
  • To view the complete data while using the AND and CONCATENATE functions, we need to wrap the text and expand the rows.
  • The CHAR(10) function inserts a line break. However, to insert line breaks in multiple cells, we must use the “Alt + Enter” method repeatedly.

How To Insert Line Break In Excel Cell?

  1. Concatenate Function in excelConcatenate Function In ExcelThe CONCATENATE function in Excel helps the user concatenate or join two or more cell values which may be in the form of characters, strings or numbers.read more.
  2. AND function
  3. Use of Alt + Enter Method.

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

You can download this Line Break Excel Template here – Line Break Excel Template

#1 – Line Break In Excel Cell (Alt + Enter)

We will use the last and the most convenient way of using a line break in a cell while working on data. We need to keep in mind that this method only works in a cell. For the next cell, we need to repeat the process. We cannot copy the same formula to other cells like a formula.

We will try to insert a line break in the sentence “I am a Boy” and insert a line break after every word.

  • Step #1 – In any cell, double click on the cell or press the F2 button to get in the cell.
  • Step #2 – Write I and press the “Alt + Enter” keys.
Line Break Example 3
  • Step #3 – We can see that it inserted a line break after I. Now, do this for every word.
  • Step #4 –Press the “Enter” key and see the result.

We have successfully inserted a line break using the “Alt + Enter” method.

#2 – Line Break With Excel Formula (& Function)

Suppose we have the name, phone number, and department name in a column. We want them in a single cell combined, but a line separates all three. The data is as follows:

Use Concatenates function 1

We want all the three data combined in one column D column and want each data to be separated by a line. We will learn the method of using the AND function in this example. But, first, we need to understand what a CHAR function is. Char function in excelChar Function In ExcelThe character function in Excel, also known as the char function, identifies the character based on the number or integer accepted by the computer language. For example, the number for character "A" is 65, so if we use =char(65), we get A.read more: returns the character specified by our computer, a specific code.

Use Concatenates function 1-1

Char(10) returns a line break in the cell.

Below are the steps of inserting line break in Excel:

  1. Now, we need to wrap the text D column to see all the data in the D column.

    Concatenates-Function-step-1

  2. Select the blank cells opposite to the data in the D column.

    Concatenates-Function-step-2

  3. Click on the Excel Wrap Text in the “Alignment” section of the “Home” tab.

    Concatenates Function step 2

  4. Now in cell D2, we must write the following formula:

    Concatenates Function step 4

  5. Now, press the Enter key to see the result.

    Concatenates Function step 4

  6. We currently do not see the whole data; we need to expand the row by clicking on the expand row button by hovering our mouse between the two cells, A2 and A3.

    Concatenates Function step 5

  7. Now, drag the formula to cell D6.

    Concatenates Function step 5

    We can see that we have successfully inserted a line break in cells using the AND formula.

#3 – Line Break With Excel Formula (Concatenate)

In the above example, we used the AND formula to insert a line break in a cell. We will learn to insert a line break in the cell using the CONCATENATE function. But first, what is a CONCATENATE  function? The CONCATENATE function joins several strings or numbers, or values into a single string.

Line Break Example 2

Also, we know what a CHAR function does, but for our revision, let us look again at what a char function does. The CHAR function returns the character specified by our computer, a specific code.

Line Break Example 2-1

The CHAR(10) inserts a line break in a cell. Now, have a look at the below data:

Line Break Example 2-2

We have a house number, street name, locality, and city in columns A, B, C, and D. Like we fill out forms, it is the same. However, we want the combined address in the E column. We will use the CONCATENATE  formula and the CHAR function to insert a line break in the cell.

  • Step #1 –  First, we need to wrap the text to see all the data.
Line Break Example 2-3
  • Step #2 – Select all the cells parallel to data in the E column.
Line Break Example 2-4
  • Step #3 – Now, click on “Wrap text” under the “Alignment” section in the “Home” tab.
Line Break Example 2-5
  • Step #4 – In cell E2, we must write the following formula:
Line Break Example 2-6
  • Step #5 – When we press the “Enter” key, we can see the following result:
Line Break Example 2-7
  • Step #6 – We currently do not see the whole data. We need to expand the row by clicking on the expand row button by hovering our mouse between the two cells, A2 and A3.
Line Break Example 2-8
  • Step #7 – Now, we must drag the formula to cell E8 and see the result.
Line Break Example 2-9

We have successfully inserted a line break using the concatenate excel formulaConcatenate Excel FormulaThe CONCATENATE function in Excel helps the user concatenate or join two or more cell values which may be in the form of characters, strings or numbers.read more.

Insert A Line Break After A Specific Character

We can also insert line break after a specific character. To do this, simply select the cells where we want to insert a line break.

Then, click on Home – Find & Select – Replace. We can also use the shortcut key Ctrl + H. In the Find and Replace window, select the specific character in Find what field.

Similarly, in the Replace with field, enter Ctrl + J to insert line break.

Finally, click on Replace all.

Likewise, we can insert line breaks in Excel.

Important Things To Note

  • To use AND and CONCATENATE functions, we must wrap text to view the whole data.
  • We must expand the rows after wrapping the text.
  • The CHAR (10) function inserts a line break.
  • The “Alt + Enter” method works in a single cell. However, for it to work in another cell, we must repeat the process.

Frequently Asked Questions

1. Explain the use of line breaks in Excel with an example.

A line break refers to inserting a new line within a cell value.
For example, consider the below table.



With line breaks in Excel, our data appears as shown in the below image.

2. How do you automate a line break in Excel?

To insert line breaks in a cell, you can use the ALT + Enter shortcut. First, select the cell you want to format and press Alt + Enter. This will create a line break immediately within the cell. If you need multiple line breaks, simply repeat the process until you have added all the necessary breaks.

3. What is line break in data?

A line break is a term used to describe the process of breaking a line of text and starting a new one.

This article is a guide to Line Break in Excel Cell. We discuss how to insert a line break in Excel using 1) AND Formula, 2) CONCATENATE  Formula, and 3) Alt + Enter method, along with practical examples and a downloadable template. You may learn more about Excel from the following articles: –

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *