Exceljet

Quick, clean, and to the point

Start a new line in the same cell

Windows shortcut 
AltEnter
Mac shortcut 
Return

Use this shortcut when you need to start a new line inside a cell.

Notes:

  1. You can use this technique to make nested IF formulas easier to read.
  2. You can also enter a new line as part of a formula using concatenation.

Related videos

Tip: 30+ Excel Shortcuts in 12 minutes
Shortcuts are a great way to save time and energy in Excel, but there are more than 200, so the list can seem overwhelming. In this rapid fire video, we demonstrate more than 30 popular Excel shortcuts you can use to save time every day in Excel. We built this list of shortcuts based on a survey of over 800 Excel users.
Tip: How to make a nested IF formula easier to read
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.
Yes, that is exactly what I mean, thank you! You guys are great - who would’ve thought that Excel could be fun :) - Alex
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course