Multiple lines in excel cell

22nd February 2006, 13:54

Oi,

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.

Help...

jmke · 22nd February 2006, 14:03

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."

it works

22nd February 2006, 14:38

hehe, oops.
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.

22nd February 2006, 13:54	#1
AngeluS Posts: n/a	Multiple lines in excel cell Oi, 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. Help...

22nd February 2006, 14:03	#2
jmke Madshrimp Join Date: May 2002 Location: 7090/Belgium Posts: 78,458	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." it works __________________

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
End of the line for IBM's Cell	jmke	WebNews	0	24th November 2009 10:50
Very slow opening Excel files? Speed Up Excel 2007 Opening Files from Network	jmke	WebNews	0	13th February 2009 15:10
Panasonic Says Fuel Cell for Notebooks Coming in 2012	jmke	WebNews	0	20th October 2008 16:54
IBM, Sony, Toshiba push Cell chip beyond games	Sidney	WebNews	0	25th August 2005 17:13
Intel Debuts New Processors for Cell Phones, PDAs	jmke	WebNews	0	13th April 2004 08:04
Review: Splinter Cell	Da`Hitch	Mad Game Reviews	4	29th November 2003 16:27
INFO: Keyboard shortcuts	jmke	FAQ / INFO / HOW-TO	3	3rd November 2003 14:32

22nd February 2006, 14:38	#3
AngeluS Posts: n/a	hehe, oops. 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.