[OpenOffice - Calc] Line break Solved

Question

Hello,  How do you create a line break in a cell in OpenOffice Calc? It's a function that existed in Excel but I haven't found it.

Stéphane Lauper · Accepted Answer

Hello, actually there's an important detail!

When you have selected the cell, press "F2" and then hold down the "Ctrl" + "Enter" keys

Tested with Ubuntu 7.04 Feisty Fawn (English version) and OpenOffice.org 2.2.0 (English version)
On July 9, 2007 at around 8:00 PM.

A wink ( ;-) ) to Long Live the spirit of OpenSource and free software

Alright, have a good continuation of the day everyone!

Sanguo · Answer

I am answering myself: "ctrl-Enter" and you need to be in the cell.

Stéphane Lauper · Answer

I am writing to you because being in the cell with the "Mouse" click does not allow for a line break A++

Gaspard · Answer

Maybe it would be good to clarify what the F2 key is for? The only thing I found is that it is used to "enter input mode". What does that mean?

den · Answer

does not work on Mac: F2 adjusts the brightness and ctrl+enter does nothing at all except move to the next cell...

lafraich · Answer

- Enter the first line in the cell - Press the Alt and Enter keys on the keyboard simultaneously The cursor moves down and you enter the second line.

fefouilleuh · Answer

It's very kind of you to say that it doesn't work ON Mac (which is quite logical for us to understand on our own), but if you could also tell us how to create a line break on Mac, that would be really nice! :)

Magoo380 · Answer

Double click in the cell (the cursor changes from an arrow to a text entry line) then CMD+ENTER.

aha · Answer

In fact, I just tried your solution on PC and I got a bit mixed up, so you need to double-click on the desired cell, then press ctrl + alt + enter simultaneously.

Rose · Answer

It's all well and good...  ... but there is a

André · Answer

Writing text on multiple lines
1. To insert a manual line break, press Ctrl+Enter.
This shortcut only works in the cell, not in the input line.
Once the right border of the cell is reached, the text can be automatically wrapped:
1. Select all the cells whose text needs to be wrapped.
2. In Format - Cells - Alignment, check the Wrap text option, then click OK.

NickBob007 · Answer

Actually, on MAC OS X, you need to: 1. Enter edit mode in the cell where you want to insert the line break 2. Press CTRL+ALT+ENTER  PS: Open Office Version 4.1.0 / MAC OS X Version 10.9.3

[OpenOffice - Calc] Line break

12 answers

The black swift flies for 10 months in a row without interruption

My pc won’t charge anymore and runs super slowly

Laptop: password forgotten

My second pc monitor

My computer stays connected for very little time

Unable to open xsl and xslx files

Pixma ts printer is broken

No internet connection possible

Print a page in the right orientation under windows 11

Change a contact’s ringtone