How to insert a line break in Excel when pressing Enter sends you to the next cell? That’s the trick you will learn in this quick Excel tutorial.
Discover how to write multiple lines in one cell, for clear and formatted worksheets. Watch our short video or continue to read.
Ready to discover a new Excel trick?
How to insert line breaks in Excel cells
Write multiple lines in one cell by pressing Option+Enter keys when typing your text in a cell. This action creates a line break in Excel cells.
In this example, we want to insert a line break in cell E50. We double click the cell where we want to insert the line break.
Then, we press Option and Enter keys on our keyboard.
Now, there are multiple lines in our cell!
Now, you know how to insert line breaks in Excel cells in order to write multiple lines in one cell.
Learn more Excel tips and tricks: how to convert text to date, how to split text into columns, basic keyboard shortcuts to use in Excel, etc.
