Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Writing Multi-line Text

Pressing the Ctrl+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.

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