Insert a line break in a LibreOffice cell

Solved
caro -  
 nao -
Hello,

I was wondering what the equivalent of [alt]+[enter] is in LibreOffice Calc. I can't seem to go to the next line in a cell!
Thank you in advance for your help!
Configuration: Linux / Firefox 7.0.1

2 réponses

Raymond PENTIER Posted messages 58545 Registration date   Status Contributeur Last intervention   17 474
 
Indeed, it's more complicated than in Excel!
In the Help of OpenOffice.org Calc, under the section "Inserting line breaks in cells," it states:

To insert a line break in a spreadsheet cell, press the combination Ctrl+Enter. This feature is only active when the text editing cursor is within the cell, not in the input line. First, double-click on the cell, then click where you want to insert a line break in the text.

--
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂
76
galopin
 
On Mac, Ctrl+Enter doesn't work, but Cmd+Enter does...
0
jani
 
For me, what worked on Mac is Alt+Ctrl+Enter.
0
Sylvie28
 
Thank you!
0
Pascal65
 
Thank you for these expert tips and for sharing them with others... I was stuck!
0
nao
 

for me, it's with alt (option) + return that it works

0