In Excel and in Calc, you can create a carriage return, aka line break, to go to a new line within the same cell.
You do this by pressing Ctrl Enter to go to a new line.
However. In Excel you can do this with your cursor in the input field at the top or in the cell. In Calc, your cursor needs to be in the cell.
Also (thanks to a reader for a note on this). One occasional issue. This applies rarely and only if you've got some serious spreadsheet action. But keep in mind that the carriage return will sometimes be interpreted as a space. Do you care? Probably not if you're not running any evaluations of that cell. But keep this bug in mind.
It's greate! Thanks for your help.
Posted by: Liao Yun | September 13, 2008 at 10:43 PM
Exactly what I was after. Thank you! and thank you Google.
Posted by: Luuk | February 04, 2009 at 07:25 PM
Just to add, in OS X it's + :)
Posted by: steve | March 14, 2009 at 01:37 AM
sorry it removed part of my comment, it's apple key + enter. :D
Posted by: steve | March 14, 2009 at 01:39 AM
Thank you for this tip.
Posted by: Michael | March 22, 2009 at 07:30 PM
http://www.gamegoldme.com/
http://www.wowgold-powerleveling.com/
http://www.wowgold-wow.com/
http://www.wowpowerleveling.me
http://www.watchrolexshop.com
http://www.wowgold-wow.com/wow-power-leveling
http://rs-runescapegold.com/
http://www.watchrolexshop.com/wow-power-leveling/
http://www.cheap-lotrogold.com/
http://www.globalsale.me/Aion-gold-083.aspx
http://www.cheap-gamegold.org
http://www.gamegoldvip.org
http://www.globalsale.me/
Posted by: wow power leveling | July 05, 2009 at 11:20 PM
It just helped me out!
Thank You
Posted by: Novin | November 09, 2009 at 11:29 PM