Anyone Any Good With Spreadsheets?

[Sharingan]

Hi, I wonder if someone could give me a hand with my spreadsheet please, as I seem to be being a total moron with it. I'm using Open Office Calc. I've set the cells to the height I want to input all the info I want to neatly but when I try to put text into them it types one line and then when I hit enter for a new line it selects the next cell. What is the command for a new line please within the same cell? Thank you.xx

[Sharingan]

It's okay I've just found it accidentally, it's ctrl enter if anyone else ever needs it. Thanks you anyway xx

[China Doll]

Alt & enter at same time

[Psybbo]

Don't press enter just keep typing? I use excel but not expert in it

[Psybbo]

Thanks Shar, I'll try that

[factor-fiction]

In Excel it does move down to the cell below for me.
Rather than pressing 'enter' can you just click on the cell below and then start tying in it?

[factor-fiction]

Sorry, I was half watching Corrie whilst playing with Excel- I didn't see you'd solved it Sharingan

[China Doll]

You'd could factor... but I wouldn't recommend it ;o)

Clicking in the next cell just means you're typing in the next row which is fine if you want another row but if you want to just have a cell with a lot of infomation in it then having the information spread over two rows is messy and not helpful either for when you are sorting your data.

[Sharingan]

Thank you all. The split second I posted it after half an hour of dabbing about on the keyboard and trying to read their bloated useless help section I found it by accident.