How to wrap text in a cell in LibreOffice Calc

How can I wrap text in a single cell in LibreOffice Calc??


Solution 1:

An image is worth a thousand words… so I got 2 thousand words (Plus change) right here:

  1. Select in the Menu: Format → Cells…

  2. Select in the Format Cells window: Alignment Tab

  3. Select Wrap Text Automatically from the Properties section.

    The end result will be something similar to this:

Note that, at least up to LibreOffice 4.0, this option only works on cells that I written in after the option is activated. It will not automatically wrap cells created before.1 See the following image:

The cell above was written before the option was activated. The bottom cell was written after the option was activated.


1 For those wanting to wrap all of their already existing cells in a spreadsheet, simply execute Ctrl+A, following by Ctrl+C, and finally Ctrl+V.

Solution 2:

You can use Format > Cells > Alignment to have a variety of effects including Wrap text automatically.
Use Ctrl+Enter to have more than one line of text per cell if that's what you mean.