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
Step-by-Step Instructions
- Click on the cell where you want multiple lines
- Type your first line of text
- Press Alt + Enter (Windows) or Option + Return (Mac)
- Type your second line
- Repeat as needed
- 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:
Task List in One Cell
Auto Wrap Text
If you want Excel to automatically wrap long text without manually inserting line breaks:
- Select the cell(s)
- Go to Home tab in the ribbon
- 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:
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
- Windows: Alt + Enter
- Mac: Option + Return
- Mac alternative: Ctrl + Option + Return
- Google Sheets (both): Same shortcuts