OOo spreadsheet format question.

tardigrade · 01-20-2005, 01:04 PM

Ok this is probably the dumbest question ever asked on this site. how to i make a cell have two lines of text. ill try to illustrate. | Prominent line wavelengths (nm) | thats what i have. I want this

thanks.

Code:

|  Prominent line wavelengths  |
|            (nm)             |

mjrich · 01-20-2005, 01:37 PM

Press CTRL-ENTER (in the cell, not the input line) just before typing (nm). Or, go to Format cells -> Alignment -> Tick "automatic line break", and then just adjust the column width to fit. You'll probably want to select centre aligned also.

Cheers,

mj

tardigrade · 01-20-2005, 01:44 PM

Thanks a bunch! Esp. for such a quick reply.

mjrich · 01-20-2005, 01:47 PM

No worries

mj