Excel: insert line break in cell
Related Videos: How to insert a line break in the same cell in Excel (May 2024).
This guide shows you how to insert a line break in a cell in Excel.
Insert line break in Excel cell
There are two ways to insert a line break in Excel.
- Manual line break: If you want to insert a line break manually, press the key combination Alt + Enter at the appropriate point. You can now continue to write on a new line within the cell. Pressing Alt + Enter several times creates several line breaks in a row.
- Automatic line break: Right-click on the relevant cell and select "Format cells". Click on the "Alignment" tab and check the "Line break" item. Then confirm by clicking on "OK".
We will show you in the next practical tip how you can open tables side by side in Excel.