\<bookmark_value\>text in cells; multi-line\</bookmark_value\>\<bookmark_value\>cells; text breaks\</bookmark_value\>\<bookmark_value\>breaks in cells\</bookmark_value\>\<bookmark_value\>multi-line text in cells\</bookmark_value\>

Writing Multi-line Text

Pressing the +Enter keys inserts a manual line break. This shortcut works directly in the cell or in the input line. The input line can be expanded to the multi-line by the Down arrow button on the right.

If you want the text to automatically break at the right border of the cell, proceed as follows:

  1. Select all the cells where you want the text to break at the right border.

  2. In Format - Cells - Alignment, mark the Wrap text automatically option and click OK.

note

For automatic wrapping in XLS files, the rows in question should be set to Optimal Height.


Please support us!