Exceljet

Quick, clean, and to the point

Start a new line in the same cell

Windows shortcut 
AltEnter
Mac shortcut 
Return

Normally, when you press the Enter key, Excel moves the cursor to the next cell. If you want to enter a line break inside the same cell, you need to use a shortcut. Here at the steps:

(1) Move the cursor where you want to break the line

Move cursor to break point

(2) Type Alt + Enter

Type Alt + Enter

(3) Make sure "wrap text"is enabled to see lines wrap in cell:

Make sure Wrap Text is enabled

Notes

  1. You can use this technique to make nested IF formulas easier to read.
  2. You can also enter a new line using a formula.
  3. Mac Excel 365 supports Alt + Enter. Otherwise see original shortcut above.

Related videos

The videos below demonstrate this shortcut.
By their nature, nested IF formulas are hard to read. In this video, we show you how to easily make a nested IF formula more readable, by adding line breaks.
In this video, we look at a few reasons why VLOOKUP is a better option than nested IF statements.
In this lesson, we review shortcuts you can use to edit cells more efficiently.