Insert line break in cell
Windows shortcut
AltEnter
Mac shortcut
⌃⌥Return
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
(2) Type Alt + Enter
(3) Make sure "wrap text"is enabled to see lines wrap in cell:
Notes
- You can use this technique to make nested IF formulas easier to read.
- You can also enter a new line using a formula.
- 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.
