How to Start a New Line in Excel Cell – Quick Tips

In this tutorial, I will show you how to start a new line in Excel cell.

You can start a new line in the same cell in Excel by using:

  • A keyboard shortcut to manually force a line break.
  • A formula to automatically enter a line break and force part of the text to start a new line in the same cell.

Start a New Line in Excel Cell – Keyboard Shortcut

To start a new line in Excel cell, you can use the following keyboard shortcut:

  • For Windows – ALT + Enter.
  • For Mac – Control + Option + Enter.

Here are the steps to start a new line in Excel Cell using the shortcut ALT + ENTER:

  • Double click on the cell where you want to insert the line break (or press F2 key to get into the edit mode).
  • Place the cursor where you want to insert the line break.
  • Hold the ALT key and press Enter.

Start a New Line in Excel Cell - Keyboard Shortcut Demo

See Also: 200+ Excel Keyboard Shortcuts.

Start a New Line in Excel Cell Using Formula

In real life, there are many situations when you need to combine text from different cells. Suppose we have a dataset as shown below:

Start a New Line in Excel Cell - Dataset Formula

if you want to combine text from different cells to create the complete address, you can use the ampersand (&) operator or the CONCATENATE function.

For example, if I combine using the text in these cells using an ampersand (&), I would get something as shown below:

Start a New Line in Excel Cell - Dataset Formula

While this combines the text, this is not really the format that I want. You can try using the text wrap, but that wouldn’t work either.

If I am creating a mailing address out of this, I need the text from each cell to be in a new line in the same cell.

To insert a line break in this formula result, we need to use CHAR(10) along with the above formula.

CHAR(10) is a line feed in Windows, which means that it forces anything after it to go to a new line.

So to do this, use the below formula:

=A2&CHAR(10)&B2&CHAR(10)&C2&CHAR(10)&D2&CHAR(10)&E2

This formula would enter a line break in the formula result and you would see something as shown below:

Start a New Line in Excel Cell - Line break in formula

IMPORTANT: For this to work, you need to wrap text in excel cells. To wrap text, go to Home –> Alignment –> Wrap Text. It is a toggle button.

Start a New Line in Excel Cell - wrap text

Tip: If you are using MAC, use CHAR(13) instead of CHAR(10).

Related Excel Tutorial:

  • Andrew says:

    Sorry to come in so late.
    I want to clear up something about the keyboard shortcut for the Mac in case anyone has seen this blog post, tried it, and then is wondering why it doesn’t work.

    On the Mac, the Enter key and the Return key are different keys. When I read this blog entry, I commented to someone with me that I will be surprised if it is the Enter key rather than the Return key. They are different keys on a standard Mac keyboard. The Return key is the more commonly used one. Then I added that I was saying all of that without trying it, so I could end up with egg on my face!

    Then I tried it. And I was correct. As you have written the shortcut, it doesn’t work.
    Control+Option+Enter does nothing. (The Enter key on an Extended Mac keyboard is grouped with the numeric keypad.)

    Control+Option+Return does indeed start a new line.
    And that’s what I came to find out, and now I know. Thank you for your post. 🙂

  • César Cariboni says:

    Thanks Sumit Bansal, I usually use below format with Alt+Enter between cells in the formula. What do you think?

    =+A2&”
    “&B2&”
    “&C2

    • Thanks for sharing Cesar.. This works great as well.

    • Purvik says:

      I was trying to find some formulae that work in Pages. I was finding it difficult to use CHAR formulae in Pages, but your trick helped me. Thanks César Cariboni.

    • Kelly says:

      char(10) char(13) wrap text never worked for me, but this one worked! big thank you!!!

  • Thanks for the video Sumit ! On the flip side, see how to use ‘Ctrl’ & ‘J’ with Text to Columns to split out text separated by line breaks (carriage returns) https://youtu.be/ky-RdiwnHoM
    This ‘Ctrl’ & ‘J’ trick was made popular by Bob Umlas

  • >