You're typing in an Excel cell and press Enter — but instead of starting a new line, Excel jumps to the next cell below. This is one of the most searched Excel questions right now, and the answer is a simple keyboard shortcut most people don't know.

Quick Answer: Press Alt + Enter (Windows) or Option + Return (Mac) to move down a line within the same cell.

The Keyboard Shortcut

Windows: Alt + Enter Mac: Option + Return (or Ctrl + Option + Return) Sheets: Same shortcuts work

Step-by-Step Instructions

  1. Click on the cell where you want multiple lines
  2. Type your first line of text
  3. Press Alt + Enter (Windows) or Option + Return (Mac)
  4. Type your second line
  5. Repeat as needed
  6. Press Enter when finished to confirm and move to the next cell

Why Regular Enter Doesn't Work

Excel treats Enter as "submit this cell and move down." This is intentional — when entering data into a column, you want to move to the next row after each entry. The Alt+Enter combination is the specific override for creating line breaks within a single cell.

Real Examples

Multi-Line Address

Type in one cell:

John Smith [Alt+Enter] 123 Main Street [Alt+Enter] New York, NY 10001

Task List in One Cell

Monday Tasks: [Alt+Enter] • Send report [Alt+Enter] • Call client [Alt+Enter] • Update sheet

Auto Wrap Text

If you want Excel to automatically wrap long text without manually inserting line breaks:

  1. Select the cell(s)
  2. Go to Home tab in the ribbon
  3. Click Wrap Text button

Text will now automatically wrap when it hits the column boundary.

Line Breaks in Formulas

Alt+Enter doesn't work inside formula bar text strings. Use CHAR(10) instead:

=A2 & CHAR(10) & B2

With Wrap Text enabled on the cell, this creates a multi-line result combining A2 and B2 on separate lines.

⚠️ After adding line breaks, your cell row may look too narrow. Drag the row border down or use Format → Row Height → AutoFit to make all lines visible.

Mac vs Windows — Quick Reference

Try FormulaZa — Free AI Excel Tool

Type what you want in plain English → get the exact formula. Free, no signup required.

Generate Formula Free →