How to do a line return (multi-line text) in a cell in NeoOffice Calc

First published on March 2, 2007

I wanted to do something like this in NeoOffice Calc (similar to OpenOffice.org):

Pressing Enter goes to the next cell in spreadsheets, instead of creating a new line in the existing cell. I think in Excel on a PC, you press something like Alt+Enter. Anyway, I needed to find the equivalent in NeoOffice. I googled for “line return in a cell NeoOffice” and came up empty. Then I searched in the NeoOffice help files and found this:

Pressing the Ctrl+Enter keys inserts a manual line break. This shortcut only works directly in the cell, not in the input line.

Being a Mac newbie, I kept following the above instruction and was met with no success.

So anyway, it’s Command+Enter. (Remember that the Command button on a Mac is the one with the apple icon on it.) And make sure that you’re editing the text in the cell instead of in the input line at the top. To edit text in the cell, double click the cell, and edit the text directly, like in a word processor.

Maybe they just copied over the instructions from OpenOffice.org and didn’t update it?

Facebook Twitter Email this

This entry is filed under Mac OS X tips and written by Peter Keung. You can follow any responses to this entry through the RSS 2.0 feed.