When you need to force a line break in Excel, you have several reliable options depending on whether you are working inside a cell, across multiple cells, or preparing data for export.
This guide walks through practical techniques, keyboard shortcuts, and formulas so you can control exactly where line breaks appear in your worksheets.
| Method | Where it works | How to use | Best for |
|---|---|---|---|
| Keyboard shortcut | Cell edit mode | Alt + Enter inside a cell | Manual entry and quick fixes |
| CHAR(10) formula | Any cell with formula | =A1 & CHAR(10) & B1 | Dynamic combinations |
| Flash Fill | Adjacent column | Type example, press Ctrl + E | Quick pattern recognition |
| Text to Columns | Selected column range | Data tab, Delimited, Other ^ J | Splitting existing line-break entries |
| Wrap Text or Newline Fit | Cell formatting | Home tab, Wrap Text or Newline Fit | Display control without changing content |
Using Alt Enter for Manual Line Breaks
Inside any cell, you can create a line break at the exact position you need by using a simple keyboard shortcut.
Start typing your text, press Alt + Enter, then continue typing on the next line within the same cell.
This method gives you full control and is ideal when you are entering or editing data directly.
Adding Line Breaks with Formulas
CHAR(10) in concatenation
Use CHAR(10) inside formulas to insert a line break between cell values or combined text.
For example, =A1 & CHAR(10) & B1 places the contents of A1, a line break, and then the contents of B1 in one cell.
Clean up with SUBSTITUTE
If your source data contains inconsistent line breaks, combine SUBSTITUTE with CHAR to normalize them before merging.
Splitting Content with Text to Columns
If existing cells already contain line breaks and you want each segment in its own column, use the Text to Columns feature.
Choose Delimited, enable Other, and press Ctrl + J, which represents the line break character.
This splits content cleanly while preserving the original data in a separate step for review.
Wrapping vs Inserting Breaks
Wrap Text for display only
Turning on Wrap Text keeps the cell value intact but visually shows content on multiple lines when the column is narrow.
It does not change where line breaks occur in the actual cell data.
Newline Fit behavior
Some modern Excel environments label Wrap Text as Newline Fit, which adjusts row height automatically to better fit wrapped content.
Key Takeaways for Managing Line Breaks
- Press Alt + Enter inside a cell to create manual line breaks during data entry.
- Use CHAR(10) in formulas to dynamically concatenate text with controlled line breaks.
- Apply Text to Columns with Ctrl + J to split existing line-break content into separate columns.
- Wrap Text and Newline Fit control visual display but do not alter the underlying cell value.
- Replace or remove line breaks before exporting to CSV to avoid unintended record splits.
FAQ
Reader questions
How do I force a line break in a formula combining names?
=FirstName & CHAR(10) & LastName inserts a line break between the first and last name when the cell is wrapped.
Can I split a column that already has Alt Enter breaks?
Yes, use Text to Columns, select Delimited, and choose Ctrl + J so each segment moves into its own column correctly.
Will line breaks be preserved when I export to CSV?
CSV files typically treat line breaks within fields as new record starts, so consider replacing CHAR(10) with a space or pipe before exporting.
How do I remove unwanted line breaks quickly across the sheet?
Use Find and Replace (Ctrl + H), enable Match entire cell contents, search for ^ J with Ctrl + J, and replace with nothing or another character.