5 Ways to Insert Line Breaks in Excel — Alt+Enter, Wrap Text, CHAR(10), SUBSTITUTE, and Ctrl+J
Excel line breaks let you display text on multiple lines within a cell. This guide covers five practical methods step by step, from the fastest manual line break to automatic wrapping, formula-based line breaks (CHAR(10)), SUBSTITUTE/replacement, and Power Query.
Quick Fix: Manual Line Break Shortcut
- Windows: Alt + Enter
- macOS: Control + Option + Return
Place the cursor where you want the break, then press the shortcut to start a new line. Use AutoFit Row Height to adjust the row height.
Method ① Wrap Text and Row Height
Turn on Wrap Text from Home to automatically wrap text based on the cell width. Wrap Text is required to display formula-based line breaks (CHAR(10)).
Method ② Insert Line Breaks with Formulas — CHAR(10)/TEXTJOIN/CONCAT
=A2 & CHAR(10) & B2=TEXTJOIN(CHAR(10), TRUE, A2:A5)=CONCAT(A2, CHAR(10), B2, CHAR(10), C2)Note: Turn on Wrap Text to see line breaks in the cell.
Method ③ Replace Delimiters with Line Breaks Using SUBSTITUTE
=SUBSTITUTE(A2, ", ", CHAR(10))Replace commas, semicolons, or slashes with line breaks to make lists easier to read.
Method ④ Bulk Replace with Find and Replace Using Ctrl+J
- Select the range → Ctrl+H
- Find what:
,/ Replace with: Ctrl+J - Select Replace All → turn Wrap Text ON
Method ⑤ Create Text with Line Breaks in Power Query
Go to Data > From Table/Range, then enter Ctrl+J as the delimiter when grouping or merging columns to combine multiple values into one cell with line breaks.
Troubleshooting Common Issues
| Issue | Cause | Solution |
|---|---|---|
| CHAR(10) displays on one line | Wrap Text is not enabled | Home > Wrap Text |
| Alt+Enter does not work | Cell is not in edit mode | Double-click the cell or press F2, then enter the shortcut |
| Line spacing feels cramped | Insufficient row height | AutoFit Row Height or adjust it manually |
| Only some values are replaced | Multiple delimiter patterns | Apply SUBSTITUTE in stages or clean up spaces |
| Print layout looks awkward | Scaling or margin issue | Page Layout > adjust scaling, margins, and column width |
Checklist
- Fastest line break: Alt+Enter on Windows, Control+Option+Return on Mac
- Formula line breaks: CHAR(10) + Wrap Text
- Delimiter → line break: SUBSTITUTE
- Bulk replacement: Ctrl+H + Ctrl+J
- Before reporting: Check columns, rows, and scaling one last time