It appears you have not yet registered with our community. To register please click here...

Go Back [M] > Hardware Madness > Hardware/Software Problems, Bugs
Multiple lines in excel cell Multiple lines in excel cell
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Multiple lines in excel cell
Closed Thread
Thread Tools
Old 22nd February 2006, 13:54   #1
Posts: n/a
Default 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.

Old 22nd February 2006, 14:03   #2
jmke's Avatar
Join Date: May 2002
Location: 7090/Belgium
Posts: 78,993
jmke has disabled reputation

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
jmke is offline  
Old 22nd February 2006, 14:38   #3
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.
Closed Thread

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 Articles & Howto's 4 29th November 2003 16:27
INFO: Keyboard shortcuts jmke FAQ / INFO / HOW-TO 3 3rd November 2003 14:32

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

All times are GMT +1. The time now is 01:19.

Powered by vBulletin® - Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO