![excel add new line in cell excel add new line in cell](https://www.exceldemy.com/wp-content/uploads/2022/04/4.-Excel-New-Line-in-Cell-Formula.png)
![excel add new line in cell excel add new line in cell](https://support.content.office.net/en-us/media/415489f5-2700-41ad-a710-cb796cf9123f.png)
This is annoyingly simple and annoyingly easy to forget almost never in Excel will you use the shortcut Ctrl + J, but that's all it takes to separate data by carriage return (new line). Make sure to select a cell to the right of the current cell/column for the Destination option if you do not want to overwrite the original cell that contains all of the data in one cell.
![excel add new line in cell excel add new line in cell](https://www.howtogeek.com/wp-content/uploads/2021/11/4-select-cells.png)
Technically, this method is Text-to-Columns using a carriage return as the delimiter.
#Excel add new line in cell how to
How to split a cell by each line of data within it this will put each line into its own separate cell.