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:

  • 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

    • Sumit Bansal says:

      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

  • >