View original (French)

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 answers

  1.
    Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   17 480
     
    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
    1. galopin
       
      On Mac, Ctrl+Enter doesn't work, but Cmd+Enter does...
      0
    2. jani
       
      For me, what worked on Mac is Alt+Ctrl+Enter.
      0
    3. Sylvie28
       
      Thank you!
      0
    4. Pascal65
       
      Thank you for these expert tips and for sharing them with others... I was stuck!
      0
    5. nao
       

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

      0