Page 1 of 1
[Solved] Alt/Enter command for line break
Posted: Sun Oct 10, 2010 10:27 pm
by 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?
Re: Alt/Enter command
Posted: Sun Oct 10, 2010 10:35 pm
by 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.
Re: Alt/Enter command
Posted: Sun Oct 10, 2010 10:41 pm
by PapaLloyd
How does it work when you are entering new data into cell.
Re: Alt/Enter command
Posted: Sun Oct 10, 2010 10:54 pm
by RoryOF
You enter the first line, press Enter and then edit the cell. Position cursor at line end then start with Ctrl-Enter.
Re: Alt/Enter command
Posted: Sun Oct 10, 2010 11:01 pm
by PapaLloyd
Ok Great that worked. Thanks for your help
Re: Alt/Enter command
Posted: Sun Oct 10, 2010 11:16 pm
by mriosv
In a blank cell, double left click the edit.
Re: [Solved] Alt/Enter command for line break
Posted: Mon Oct 11, 2010 4:18 pm
by 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").