Line breaks are important to improve visuals in cells. It can also be used to store more than one piece of data if needed in a single cell. Whatever your cause might be, here I will help you with how to do a line break in Excel.

**Table of Contents**hide

## Download Practice Workbook

You can download the workbook with all the sheets and examples used for this demonstration below. Download and give it a try.

## 4 Ways to Do a Line Break in Excel

There are 4 distinct ways you can do a line break in Excel. There can be sub-methods of the methods. Either way, I will be going through each method. Follow along to learn how each one works or find the suitable one for you from the table of contents above.

For most of the article, I will be using the following dataset to do a line break in between in Excel.

### 1. Do a Line Break Using Keyboard Shortcut

You can easily add a line break by using keyboard shortcuts depending on the operating system you are using. For Windows users it is **Alt+Enter **and for Mac users it is **Control+Option+Enter**.

For more details, go through these steps.

**Steps:**

- First, select cell
**C5**. - Then go into edit mode either by double-clicking the cell or pressing
**F2**on your keyboard. - After that, click the exact position where you want to break the line to get the cursor there.

- Now press
**Alt+Enter**if you are a Windows user or press**Control+Option+Enter**if you are using Mac. It will do a line break there.

- Repeat as many times as you need. You will finally have your desired lines.

**Note: **You need to manually increase the row height if you want a full view of all the contents in the cell.

**Read More:** **[Fixed!] Line Break in Cell Not Working in Excel**

### 2. Utilizing Wrap Text Command in Excel

You can use the **Wrap Text **feature to do a line break in an Excel cell. **Wrap Text **generally helps to avoid the cell content overlapping on the next cell and tries to give a clearer view of what is inside of the cell. If you want to automate a line break using wrap text follow these steps.

**Steps:**

- First, select the cells where you want to add your line breaks.

- Then go to the
**Home**tab from your ribbon and from the**Alignment**group, select**Wrap Text**.

- Now, write down your text in your cell. It will automatically break the line if the value overflows the cell boundary.

- Repeat this for all the cells and you will have cells with line breaks.

**Read More:** **How to Remove Line Breaks in Excel (5 Ways)**

**Similar Readings**

**How to Put Multiple Lines in Excel Cell (2 Easy Ways)****VBA to Generate Multiple Lines in Email Body in Excel (2 Methods)****How to Add a Line in Excel Cell (5 Easy Methods)**

### 3. Using ‘Find and Replace’ Command

You can also use the **Find and Replace command in Excel to do a line break**. With this tool, you can replace a character or a set of characters with other ones. To break lines we can suitably **use a particular character to replace it with a line break.** Follow these steps for a detailed guide.

**Steps:**

- First, copy and paste the value into your desired cell. If you want to replace the original data you can skip this step.

- After that, select all the cells you want to put line breaks in.
- Then, press
**Ctrl+H**to open up the**Find and Replace**tool on your Excel. - Put a space inside the
**Find what**field. In the**Replace with**field, select and press**Ctrl+J**to insert break here.

- After that, click on
**Replace All**. You will have your spaces replaced by line breaks.

**Read More:** **How to Replace Line Break with Comma in Excel (3 ways)**

### 4. Applying Different Formulas to Do a Line Break

There are formulas and functions you can use to do a line break in Excel. Usually, **the CHAR function** takes a numerical argument and returns the character which the number represents. **CHAR(10) **indicates a line break in Excel formulas. You can combine it with other functions like **TEXTJOIN** or **CONCAT** functions or just simply with the ampersand (&) sign in the formulas to add line breaks.

For formulas, I modified the dataset slightly for the simplicity of applications and understanding. This is the version I will be using for the rest of the article containing formulas.

#### 4.1 Using Ampersand Sign

You can combine **the CHAR function** with the ampersand (**&**) sign in formulas to add a line break after texts. Follow the steps for the formula and application.

**Steps:**

- First, select cell
**E5**. - Write down the following formula.

`=B5&CHAR(10)&C5&CHAR(10)&D5`

- Then press
**Enter**. You will have all the text values added with a line break in between them.

- Click and drag the
**Fill Handle**icon to fill out the rest of the cells.

#### 4.2 Applying CONCAT Function

Similarly, you can add text values with a line break between them with **the CONCAT function****. **This function takes several arguments and concatenates all the values in them.

Follow these steps for more details.

**Steps:**

- Select cell
**E5**. - Write down the following formula in the cell.

`=CONCAT(B5,CHAR(10),C5,CHAR(10),D5)`

- Now press
**Enter**on your keyboard.

- Finally click and drag the
**Fill Handle**icon to fill out the rest of the cells.

🔍 **Breakdown of the Formula**

`👉`

**CHAR(10) **represents the line break. And when used in a formula, returns the line break.

`👉`

**CONCAT(B5,CHAR(10),C5,CHAR(10),D5) **concatenates the values in the range of cells **B5:D5 **with a line break in between them.

#### 4.3 Utilizing TEXTJOIN Function

There is another function called **the TEXTJOIN function** to join texts with a delimiter in between them. This function takes the delimiter as the first argument, a boolean argument of whether to ignore the empty strings or not and text values as the later arguments. If we add line breaks in place of delimiter, we can easily add line breaks with this function.

Follow these steps below for a more detailed guide.

**Steps:**

- First, select cell
**E5**. - Write down the following formula.

`=TEXTJOIN(CHAR(10),TRUE,B5:D5)`

- Press
**Enter**to get the value.

- Finally, click and drag the
**Fill Handle**icon to fill up the rest of the cells.

🔍 **Breakdown of the Formula**

`👉`

**CHAR(10) **returns a line break in the formula.

`👉`

The boolean value **TRUE **indicates it will ignore all the empty cells while joining the values.

`👉`

Finally, **TEXTJOIN(CHAR(10),TRUE,B5:D5) **joins the values within the range of cells **B5:D5 **with a line break after each cell value and ignores all the empty values.

## Conclusion

These were all the methods to do a line break in Excel. Hope you found this guide informative and helpful. If you have any questions or suggestions let us know below. For more detailed guides like this, visit **Exceldemy.com***.*