Donate SIGN UP

Anyone Any Good With Spreadsheets?

Avatar Image
Sharingan | 18:46 Fri 03rd May 2013 | ChatterBank
8 Answers
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
Gravatar

Answers

1 to 8 of 8rss feed

Best Answer

No best answer has yet been selected by Sharingan. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Question Author
It's okay I've just found it accidentally, it's ctrl enter if anyone else ever needs it. Thanks you anyway xx
Alt & enter at same time
Don't press enter just keep typing? I use excel but not expert in it
Thanks Shar, I'll try that
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?
Sorry, I was half watching Corrie whilst playing with Excel- I didn't see you'd solved it Sharingan
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.
Question Author
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.

1 to 8 of 8rss feed

Do you know the answer?

Anyone Any Good With Spreadsheets?

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.