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 lesson, we review shortcuts you can use to edit cells more efficiently.
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.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
