Line break in excel means inserting a new line in any cell value, simply pressing enter will take us to the next cell, to insert a line break we can use the keyboard shortcut which is ALT + Enter to insert a new line inside a cell, as we insert a line break in excel the height of the cell also increases as it represents the data in the cell.

**Line Break in Excel (Table of Contents)**

## What is Line Break in Excel Cell?

Line break in excel works to insert a new line in a cell itself. If we just press enter excel takes us to next cell opposite to what is in other applications. Like if we press enter in a WordPad or Microsoft word it takes us to another line. In excel there are different ways to insert a line break in a cell. We can do it the regular way which is the conventional way or use some formulas to do the same.

Line breaks are similar to page breaks. But page breaks works when a sheet is printed and line breaks works in the sheet itself. We will talk about three ways to insert a line break in a cell.

**How to Insert Line Break in Excel Cell?**

We have learned three ways to insert a line break in Excel Cell.

- Use of Concatenate Function.
- & function.
- Use of Alt + Enter Method.

Let us try all the three methods with examples to have a clear idea about line breaks.

### Example #1 – Line Break with Excel Formula (& Function)

Suppose we have Name, Phone Number and department name in a column. We want them in a single cell combined but all three separated with a line. The data is as follows,

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 use of the & function in this example. First, we need to understand what a char function is. Char function: it returns the character which is specified by our computer a specific code.

Char(10) returns a line break in cell.

**Step #1 –** Now we need to wrap text D column so we can see all of the data in the D column.

**Step #2 –** Select the blank cells opposite to data in the D column.

**Step #3 –** Click on Excel Wrap Text in the Alignment section of Home Tab.

**Step #4 –** Now In cell D2, write down the following formula,

**Step #5 –** Press Enter to see the result.

**Step #6 –** We currently don’t 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 & A3.

**Step #7 –** Now drag the formula to cell D6.

We can see that we have successfully inserted a line break in excel cell using the & Formula.

### Example #2 – Line Break with Excel Formula (Concatenate)

In the above example, we used the & (And) formula to insert a line break in excel cell. Now we will learn to insert a line break in excel cell using the concatenate function. But first what is a concatenate function? Concatenate function is used to join several strings or numbers or values into a single string.

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

Char(10) inserts a line break in an excel cell. Now have a look at the below data,

We have a house number, street name, locality, and city in column A, b, c, and D. Like we fill forms it is the same. We want the combined address in E column. We will use the concatenate formula and use char function to insert a line break in excel cell.

**Step #1 –** First, we need to wrap the text so that we can see all the data.

**Step #2 –** Select all the cells parallel to data in the E column.

**Step #3 –** Now click on Wrap text under the alignment section in the home tab.

**Step #4 –** In cell E2, write the following formula,

**Step #5 –** When we press enter we see the following result,

**Step #6 –** We currently don’t 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 & A3.

**Step #7 –** Now we drag the formula to cell E8 and see the result.

We have successfully inserted a line break using the concatenate excel formula.

### Example #3 – Line Break in Excel Cell (Conventional way)

Now 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 and for the next cell we need to repeat the process. Like a formula, we cannot copy the same formula to other cells.

We will try to insert a line break in a 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 F2 button to get In the cell.

**Step #2 –** Write I and then press Alt + Enter.

**Step #3 –** We can see that it inserted a line break after I now do this for every word.

**Step #4 –** Press Enter and see the result.

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

**Things to Remember**

There are a few things we need to remember in Line breaks:

- To Use & and concatenate function we need to wrap text to view the whole data.
- We need to expand the rows after wrapping the text.
- Char (10) function inserts a line break.
- Alt + Enter method works in a single cell, for it to work in another cell we need to repeat the process.

### Recommended Articles

This has been a guide to Line Break in Excel Cell. Here we discuss how to insert a line break in Excel using 1) & 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 –

- BreakPoint in VBA
- Excel Concatenate Columns
- Concatenate Function in VBA
- Format Phone Numbers in Excel
- Draw Line in Excel
- How to Count Characters in Excel?
- How to Combine Cells in Excel?
- How to Remove Space in Excel?
- Insert Excel Comment Quickly

- 35+ Courses
- 120+ Hours
- Full Lifetime Access
- Certificate of Completion