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.