33

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

38

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.

  • 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
8

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.

4

Manually

Type control + enter from inside a cell.

Automatically

Seems bugged if you set it before editing the cell: https://bugs.freedesktop.org/show_bug.cgi?id=57519

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

2

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

  • There isnt such a "wrap text automatical" option there. – Elysium Mar 25 '13 at 10:25
  • 1
    @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
2

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

http://extensions.libreoffice.org/extension-center/wrap-unwrap-insert-copied-row-or-column-and-paste-value/releases/1.0.1

1

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/.

0

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:)

0

Here's how to add a shortcut icon to toggle "Wrap text automatically" on and off:

Doing it one time through the Format Cells menu is great and all, but I use this operation all the time. Let's add a shortcut button, shall we?

Click View --> Toolbars --> Customize.
In the Toolbar drop down select Formatting. Now in the Toolbar Content section scroll down and click on Justified, since I want to add my cell wrap icon just after that one.

Click Add, then choose Format from the "Category" menu and Automatic Row Break from the "Commands" menu. Here's what those menus look like:

enter image description here

Click Add then Close.

Now click on Modify --> Change Icon... and choose an icon you think looks half-way decent. I chose this one:
enter image description here

when done, click Ok as necessary to exit the menus, then click on View --> Toolbars and ensure the "Formatting" toolbar we just added the icon to is visible. It will have a check mark next to it to indicate it is visible.

Here's what my icons look like now:

enter image description here

Focus in on this area:
enter image description here

Here's the icon I just added right after the "Justify" icon.
enter image description here

Select a cell and click this icon to toggle "Automatic Row Break" (ie: "Wrap text automatically") on and off, just like you can do in Microsoft Excel!

Demo'ed in LibreOffice 4.2.8.2, Ubuntu 14.04 LTS.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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