Cut off text in Excel
Related Videos: How to Trim or Remove Text in Excel (May 2024).
Cutting off a text in Excel is usually an option if the text content in a cell extends beyond the edge of the box, but the cell length should not be changed. There are two options for this.
Cut off text in Excel using the neighboring line
You only need one click and the appropriate text value for this process:
- Click the cell to the right of the box that contains the text you want to cut off. Then enter the instruction (equal sign and two quotation marks one after the other) (see screenshot). This assigns the text value "Empty" to the cell.
- Confirm with the Enter key. Now you can see that your text has been cut off at the end of the cell. Your document will be printed out in the same way.
Show text in Excel in multiple lines using line breaks
If you don't want to cut off your text at the end of the cell or want it to flow into the next cell, you can change the height of the text box accordingly. It works like this:
- Right-click on the cell with the text that extends beyond the cell border.
- Now go to "Format cells ..." in the window that opens and click on "Alignment" at the top.
- Now all you have to do is tick "Line break" (see screenshot) and confirm with "OK". The cell is now simply displayed in multiple lines.
The instructions refer to Microsoft Excel 2010.