Quick, clean, and to the point

Insert line break in cell

Windows shortcut 
Mac shortcut 

Normally, when you press the Enter key, Excel moves the cursor to the next cell. To insert a line break (i.e. a new line) inside a 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.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.