Quick, clean, and to the point

Start a new line in the same cell

Windows shortcut 
Mac shortcut 

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


  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.
In this video, we look at a few reasons why VLOOKUP is a better option than nested IF statements.
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 lesson, we review shortcuts you can use to edit cells more efficiently.