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
AngeluS
 
Posts: n/a
Default 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...
 
Old 22nd February 2006, 14:03   #2
Madshrimp
 
jmke's Avatar
 
Join Date: May 2002
Location: 7090/Belgium
Posts: 78,717
jmke has disabled reputation
Default

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
AngeluS
 
Posts: n/a
Default

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 Mad Game Reviews 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 13:39.


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