/text/scalc/guide/text_wrap.xhp text in cells; multi-line cells; text breaks breaks in cells multi-line text in cells Writing Multi-line Text

Pressing the CommandCtrl+Enter keys inserts a manual line break. This shortcut only works directly in the cell, not in the input line. If you want the text to automatically break at the right border of the cell, proceed as follows: Select all the cells where you want the text to break at the right border. In Format - Cells - Alignment, mark the Wrap text automatically option and click OK.

Format - Cell