| Thread Tools |
22nd February 2006, 14:54 | #1 |
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, 15:03 | #2 |
Madshrimp Join Date: May 2002 Location: 7090/Belgium
Posts: 79,021
| 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, 15: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. |
Similar Threads | ||||
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 |
Thread Tools | |
| |