| ||Thread Tools|
|22nd February 2006, 14:54||#1|
Multiple lines in excel cell
How can I type a text with multiple lines in an MS excel cell.
When I press enter I jump immediately to the cell under the one I was editing.
The same with CTRL+ENTER and SHIFT+ENTER.
Is there a way to edit a text in a cell and use enters in it?
Possible solution is typing the text in another editor with the hard enters and stuff, just like I want the text and then copy/paste it to the excell cell. But it is easier and faster if I can do it immediately in excell.
In Openoffice Calc it works with CTRL+ENTER. Unfortunately at work when creating official documents I have to use M$ stuff.
|22nd February 2006, 15:03||#2|
Join Date: May 2002
Excel's online help - 20 seconds:
"To start a new line of text at a specific point in a cell, click where you want to break the line, and then press ALT+ENTER."
|22nd February 2006, 15:38||#3|
Should have thought about the program's own help function.
Shame on me.
It's been ages since I used an apps own help function. Normally I google or just ask someone else. Works like a charm.
Thanx for the help jmke.
|Thread||Thread Starter||Forum||Replies||Last Post|
|End of the line for IBM's Cell||jmke||WebNews||0||24th November 2009 11:50|
|Very slow opening Excel files? Speed Up Excel 2007 Opening Files from Network||jmke||WebNews||0||13th February 2009 16:10|
|Panasonic Says Fuel Cell for Notebooks Coming in 2012||jmke||WebNews||0||20th October 2008 17:54|
|IBM, Sony, Toshiba push Cell chip beyond games||Sidney||WebNews||0||25th August 2005 18:13|
|Intel Debuts New Processors for Cell Phones, PDAs||jmke||WebNews||0||13th April 2004 09:04|
|Review: Splinter Cell||Da`Hitch||Articles & Howto's||4||29th November 2003 17:27|
|INFO: Keyboard shortcuts||jmke||FAQ / INFO / HOW-TO||3||3rd November 2003 15:32|