Excel line break: how to make it work for you

When the content of an Excel cell exceeds the current column width, part of the content disappears into the invisible area. To prevent this, you can make the column wider accordingly or you can use the line break.

Thanks to the line break you always keep control over the width of your cells.

Create excel line break: How to do it

The Excel spreadsheet program offers you numerous ways to organize and clearly display your data. This includes the function to activate an automatic line break for certain cells. The content of the cell will then be split into several rows if it has exceeded the column width. In this way, the rows become taller, but the columns do not automatically become wider, and you still see the entire cell contents. In many cases the result is a better overview. To activate the option only a few steps are necessary.

1. Open Excel on your PC and go to the area where you want to insert a line break.
2. Now mark the corresponding cell.
3. Then click at the top of the menu in the "Start" tab and look for the "Alignment" area.
4. Here you will find the "Text Wrap" option. Click on this to enable automatic line wrapping. Depending on the Excel version can also be here "Line break".
5. This also goes with several cells in one fell swoop. To do this, select all cells in which you want to activate a line break and then click on "Text break" or "Line break"-

Downloads, Apps & Tips on the topic

To download: Microsoft Excel | Microsoft Excel Mobile as a Windows 10 app | Microsoft Excel OnlineOffice alternatives: free replacement for Microsoft OfficeOffice software: free programs you no longer want to do without Print