How to Quickly Insert Line Break in Excel

A line break in Excel can be used to end the current line and start a new line in the same cell.

Insert Line Break in Excel Formula

Notice that in the pic above, Morning is in the second row in the same cell.

This has been done by inserting a line break in this text string.

Inserting a Line Break in Excel

There are a couple of ways you can insert a line break in Excel.

Inserting a Line Break Using the Keyboard Shortcut

If you only have to do this for a couple of cells, using the keyboard shortcut would be the way to go.

To insert a line break in Excel:

  • Double click on the cell (or press F2) to get into the edit mode and then get the cursor where you want the line break.
  • Use the keyboard shortcut – ALT + ENTER (hold the ALT key and then press Enter).

This would insert a line break at the right of the cursor.

Note that you need the cell to be in the ‘wrap text’ mode to see the content appear in the next line.

As mentioned, the keyboard shortcut is the way to go if you only have to do this for a few cells. But if you have to do this a lot of cells, you can resort to using Excel formulas.

Inserting Line Breaks Using Formulas

If you’re working with text data and want to insert line break in Excel formula results, you can do that as shown below.

  1. In the formula, where you want to insert a line break, add Char(10).
    • For example, instead of =A1&A2, use =A1&Char(10)&A2.
      CHAR formula returns the character based on the ASCII code. And in this case, 10 represents the ACSII code for a line break.
  2. Select the cell with the formula, go to Home –> Alignment –> Wrap Text
    • If the Wrap Text is NOT applied, adding Char(10) would make no changes in the formula result.

Insert Line Break in Excel

Note: If you are using Mac, use Char(13) instead of Char(10).

Using Define Name Instead of Char(10)

If you have to use Char(10) or Char(13) often, a better way would be to assign a name to it by creating a defined name.

To do this:

  • Go to Formulas –> Defined Name.Insert Line Break in Excel Formula - Defined Name
  • In the New Name dialogue box, enter the following details:
    • Name: LB (you can name it whatever you want – without spaces)
    • Scope: Workbook
    • Refers to: =Char(10)Insert Line Break in Excel Formula - Defined Name Details
  • Click OK.

Now you can use LB instead of =CHAR(10).

Live Example:

Related Tutorials:
>