Results 1 to 5 of 5

Thread: How to insert new line (line break) in a cell – OpenOffice Calc?

  1. #1
    Join Date
    Sep 2008
    Beans
    721
    Distro
    Ubuntu 12.04 Precise Pangolin

    How to insert new line (line break) in a cell – OpenOffice Calc?

    How to insert new line (line break) in a cell – OpenOffice Calc?

    To insert new line in a cell (line break), I tried “CTRL + Enter” that didnt work. So, I tried “Shift + Enter” that didnt work either. I have looked at openoffice.org, and online... it is same thing, either ctrl, or shift combo. However, it doesnt work.

    thank you.
    Using 12.04 Ubuntu

  2. #2
    Join Date
    Mar 2006
    Beans
    Hidden!

    Re: How to insert new line (line break) in a cell – OpenOffice Calc?

    Quote Originally Posted by 007casper View Post
    How to insert new line (line break) in a cell – OpenOffice Calc?

    To insert new line in a cell (line break), I tried “CTRL + Enter” that didnt work. So, I tried “Shift + Enter” that didnt work either. I have looked at openoffice.org, and online... it is same thing, either ctrl, or shift combo. However, it doesnt work.

    thank you.
    Have you tried ALT+ENTER (same as Excel and Gnumeric)
    No longer participating......

  3. #3
    Join Date
    Sep 2008
    Beans
    721
    Distro
    Ubuntu 12.04 Precise Pangolin

    Re: How to insert new line (line break) in a cell – OpenOffice Calc?

    yeah. It is weird. I cant make it to have a line break. Do I need to enable it somewhere?
    Using 12.04 Ubuntu

  4. #4
    Join Date
    Jan 2005
    Location
    South Africa
    Beans
    2,098
    Distro
    Ubuntu 12.04 Precise Pangolin

    Re: How to insert new line (line break) in a cell – OpenOffice Calc?

    I'm using OOo 3.2.0 (default in 10.04) and it just works with <ctrl><enter>; tried in a fresh workbook

    Writing Multi-line Text
    1.Pressing the Ctrl+Enter keys inserts a manual line break. This shortcut only works directly in the cell, not in the input line.
    If you want the text to automatically break at the right border of the cell, proceed as follows:
    1.Select all the cells where you want the text to break at the right border.
    2.In Format - Cells - Alignment, mark the Wrap text automatically option and click OK.
    If you don't make backups of your important data, your data is obviously not important to you.

  5. #5
    Join Date
    Sep 2008
    Beans
    721
    Distro
    Ubuntu 12.04 Precise Pangolin

    Re: How to insert new line (line break) in a cell – OpenOffice Calc?

    thank you. I was trying in the input line. Thank you so much. Ctrl+Enter works
    Using 12.04 Ubuntu

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •