In most applications, you can easily go to the next line by just pressing Enter. But in Excel, this process is a little different. You can use the keyboard shortcut, find and replace option, or some formulas to go to the next line in an excel cell. In this article, we will demonstrate **4 **simple methods to **go to the next line in an Excel cell**. So, without further ado, let’s start the discussion.

## Download Practice Book

Download the practice book here.

## 4 Methods to Go to Next Line in Excel Cell

To explain the methods, we will use a dataset that contains information about the **Sales Amount**. We will try to go to the next line while writing comments on the dataset.

### 1. Use Keyboard Shortcut to Go to Next Line in Excel Cell

In **Excel**, you can use a keyboard shortcut to go to the next line in a cell very easily. This is the easiest method of all. We use different shortcuts for **Windows **and **Mac**. Follow the steps below to learn the method.

**STEPS:**

- First of all, type a word in
**Cell D5**. We have written**Performance**in**Cell D5**. - Now, to go to the next line, press
**Alt**+**Enter**if you are a windows user. For mac, press**Control**+**Option**+**Return**.

- After pressing
**Alt**+**Enter**, you will see results like the picture below.

- You can use the shortcut after each word to go to the next line in the same cell. Or, you can use it after the words you want.

- After typing the full sentence or formula, you need to hit
**Enter**to get out of editing mode. - Next, you need to adjust the height of the row. To do so, put the cursor on the division line between two rows and
**double-click**it.

- Finally, you will see results like the picture below.

- Alternatively, you can also use the shortcut after completing the full sentence. Just put the cursor before the word from where you need to go to the next line.

- After placing the cursor before the desired word, press
**Alt**+**Enter**. Mac users need to press**Control**+**Option**+**Return**.

- Do the same for the rest of the cells to get results like the image below.

**Read More:** **New Line in Cell Formula in Excel (4 Cases)**

### 2. Go to Next Line inside a Cell Using Wrap Text in Excel

In this method, we will use the **Wrap Text **option to go to the next line in an excel cell. If you need to maintain a constant cell width, then, you must follow this method. To explain the steps, we will use a dataset that contains the comments. In this case, you can not autofit the column width.

Let’s pay attention to the steps below to know more.

**STEPS:**

- In the beginning, select the cells. Here, we have selected
**Cell D5**to**D8**.

- Secondly, go to the
**Home**tab and select**Wrap Text**.

- After that, you will see results like the screenshot below. You just need to adjust the row height now.
- To adjust the row height, put the cursor on the division line between two rows and
**double-click**it.

- Finally, you will see results like the picture below.

**Read More:** **How to Enter within a Cell in Excel (5 Methods)**

**Similar Readings**

**How to Add a Line in Excel Cell (5 Easy Methods)****How to Put Multiple Lines in Excel Cell (2 Easy Ways)****How to Replace a Character with a Line Break in Excel (3 Easy Methods)**

### 3. Apply Formula in an Excel Cell to Create Next Line

In Excel, you can use some formulas to go to the next line inside a cell. We can build these formulas using the **Ampersand (&) **sign, **the CONCATENATE function**, or **the TEXTJOIN function**. To explain this method, we will bring the values of **Cell B5**, **C5 **& **D5 **to **Cell E5**.

#### 3.1 Use Ampersand (&) Sign

We can use the **Ampersand (&) **sign to create a simple formula. Follow the steps below to learn the formula.

**STEPS:**

- Firstly, select
**Cell E5**and type the formula:

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

- In the second place, hit
**Enter**to see the result.

In this case, we have **the CHAR(10) function **to introduce line breaks.

- Now, use the
**Fill Handle**down to see results in the rest of the cells.

- After that, select the cells and then, go to the
**Home**tab and select**Wrap Text**.

- You will see results like below after selecting
**Wrap Text**.

- Next, adjust the row height by placing the cursor on the division line between two rows and
**double-click**it.

- Finally, the cells will look like this.

#### 3.2 Apply CONCATENATE Function

We can use the **CONCATENATE **function for the same purpose. Let’s observe the steps below for this sub-method.

**STEPS:**

- To begin with, select
**Cell E5**and type the formula:

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

- Then, hit
**Enter**.

Here, to introduce line breaks, we have used the **CHAR(10) **function after every cell inside the formula.

- After that, drag down the
**Fill Handle**and select the desired cells.

- Next, select
**Wrap Text**from the**Home**tab in the ribbon.

- Finally, adjust the row height to observe the below result.

#### 3.3 Insert TEXTJOIN Function

Like the previous two methods, we can also use the **TEXTJOIN **function to build a formula to go to the next line in an excel cell. But the **TEXTJOIN **function is available in **Excel 365 and Excel 2019 only**. Follow the steps below for the procedure.

**STEPS:**

- Select
**Cell E5**first and type the formula:

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

- After that, press
**Enter**to see the result.

Here, the **CHAR(10) **function is used for line breaks. The second argument ignores the empty cells and the third argument contains the cells that need to be joined.

- Next, autofill the formula in the below cells and select them.

- Now, go to the
**Home**tab and select**Wrap Text**.

- In the end, adjust the row height to see results like below.

**Read More:** **How to Add New Line with CONCATENATE Formula in Excel (5 Ways)**

### 4. Insert Line Break with ‘Find and Replace’ Feature to Go to Next Line in Cell

Excel provides another option to introduce** line breaks**. Using the line breaks you can go to the next line easily. And that is to use the ‘**Find and Replace**‘ option. Here, the dataset will contain the comments. Follow the steps below to learn this method.

**STEPS:**

- First of all, select the cells where you want to introduce the line breaks.

- In the second place, press
**Ctrl**+**H**to open the**Find and Replace**window. - In the
**Find and Replace**window, press**the space key**one time in the ‘**Find what’**field. - Then, press
**Ctrl**+**J**in the ‘**Replace with’**field. You will not do anything on the field but it will add some special characters.

- After that, press
**Replace All**to see results like the picture below.

- Finally, adjust the row height to see the below results.

**Read More:** **Find and Replace Line Breaks in Excel (6 Examples)**

## Things to Remember

You could extra space while going to the next line inside an excel cell. This can create problems later. So, be extra careful about that.

## Conclusion

In this discussion, we have demonstrated **4** easy methods to** Go to the Next Line in an Excel Cell**. **Method-1 **is the easiest of all. I hope these methods will help you to perform your tasks easily. Furthermore, we have also added the practice book at the beginning of the article. You can download it to learn more. Last of all, if you have any suggestions or queries, feel free to ask in the comment section below.