Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am wondering how to wrap text in a single cell in libreoffice Calc. Does anyone know?

share|improve this question
up vote 18 down vote accepted

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

  1. Select in the Menu: Format -> Cells...

    enter image description here

  2. Select in the Format Cells Window: Alignment Tab

    enter image description here

  3. Select Wrap Text Automatically from the Properties Section.

The end result will be something similar to this:

enter image description here

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 work with the ones that were created before. See the following image:

enter image description here

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

share|improve this answer
I use a dutch version so I could not make nice images :( Can you check if when you set this BEFORE typing it changes wrap? Mine did not... – Rinzwind Mar 25 '13 at 12:49
Mine does not either. For what I can see (Even on LibreOffice 4.0) is that it takes effect on newly written cells. Not one already created ones. Will make an image of this. – Luis Alvarado Mar 25 '13 at 12:59
Thanks...that did the magic. :) Do you know if there is a way to add that to the toolbar instead of accessing it all the time thru the menu? – Elysium Mar 26 '13 at 15:03
@Elysium You can select all the cells then apply the above option to do them all at once. – Giraldi Jun 12 '14 at 3:28
What if I want to wrap text but I do not want cell height to change automatically? – Trismegistos Jul 1 '14 at 17:55

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.

share|improve this answer


Type control + enter from inside a cell.


Seems bugged if you set it before editing the cell:

Setting the 'wrap' from a column or field in the tab 'alignment' works but you need to do this after inserting text.

share|improve this answer

Select the cell, follow the path "Format\Cells\Allignment" and mark "Wrap text automatically".

share|improve this answer
There isnt such a "wrap text automatical" option there. – Elysium Mar 25 '13 at 10:25
@Elysium The option is "Wrap text automatically." It appears near the bottom off the window. Make sure the Alignment tab is up. – Eliah Kagan Mar 25 '13 at 11:40

This extension for calc create a toolbar which has button for wrap text in selected cell(s), unwrap text in selected cell(s), insert copied row(s) or cell(s), insert copied column(s)or cell(s) and paste value

share|improve this answer

In case of an imported xlsx file (but I not sure whether the file being xlsx-format is the point), the Wrap Text Automatically simply did not work, until I checked "Optimal Height" in Format/Row/.

share|improve this answer

Cell wrapping by "Format->Cells->Allignment->Wrap text automatically" makes it wrap horizontally.
To Wrap it completely, You need to select the cell or all the rows and select "Optimal Row Height" which will automatically increases the row height according to the text within...

Hope this helps:)

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.