[Solved] Alt/Enter command for line break

[PapaLloyd]

The Alt/Enter command in Office 2007/Excel will allow you to type a second line into a cell, how does it work in openoffice?

[acknak]

Edit the cell "in place" (double-click on the cell) and press Ctrl+Enter.

This only works when editing the cell; it does not work in the formula bar.

[PapaLloyd]

How does it work when you are entering new data into cell.

[RoryOF]

You enter the first line, press Enter and then edit the cell. Position cursor at line end then start with Ctrl-Enter.

[PapaLloyd]

Ok Great that worked. Thanks for your help

[mriosv]

In a blank cell, double left click the edit.

[MrProgrammer]

To open a cell for editing, whether there's data in it or not, select the cell and press F2.
People running OpenOffice.org on a Mac should use ⌘Enter instead of Control Enter to insert a Newline into a cell.
A formula can insert a NewLine with CHAR(10), as in =CONCATENATE("Line 1";CHAR(10);"Line 2").