PC Review


Reply
Thread Tools Rate Thread

How can I insert a newline inside a cell?

 
 
!George Sgouros
Guest
Posts: n/a
 
      19th Nov 2003
Hello everybody

In several cases I need to write inside an Excel cell using multiple lines.
When I am in Word everything works just fine (I just press Enter inside the
cell)
but in Excel, I have to fill the rest of the line with spaces so that the
line 'folds' inside the cell.
Since this isn't a very elegant way of changing lines inside an Excel cell I
would appreciate any help

thanks in advance

George






 
Reply With Quote
 
 
 
 
Don Guillett
Guest
Posts: n/a
 
      19th Nov 2003
try alt/enter

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"!George Sgouros" <(E-Mail Removed)> wrote in message
news:bpfuc2$1g3$(E-Mail Removed)...
> Hello everybody
>
> In several cases I need to write inside an Excel cell using multiple

lines.
> When I am in Word everything works just fine (I just press Enter inside

the
> cell)
> but in Excel, I have to fill the rest of the line with spaces so that the
> line 'folds' inside the cell.
> Since this isn't a very elegant way of changing lines inside an Excel cell

I
> would appreciate any help
>
> thanks in advance
>
> George
>
>
>
>
>
>



 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      19th Nov 2003
George

Use ALT + ENTER to produce a new line in a cell.

Gord Dibben XL2002

On Wed, 19 Nov 2003 16:27:05 +0200, "!George Sgouros" <(E-Mail Removed)>
wrote:

>Hello everybody
>
>In several cases I need to write inside an Excel cell using multiple lines.
>When I am in Word everything works just fine (I just press Enter inside the
>cell)
>but in Excel, I have to fill the rest of the line with spaces so that the
>line 'folds' inside the cell.
>Since this isn't a very elegant way of changing lines inside an Excel cell I
>would appreciate any help
>
>thanks in advance
>
>George
>
>
>
>
>


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert a Tab character inside cell ryanmhuc@yahoo.com Microsoft Excel Discussion 18 4th Nov 2011 02:26 AM
insert entire row inside existing cell rsdamaso Microsoft Word Document Management 1 27th Aug 2009 09:30 PM
Insert newline in cell through formula (excel 2003) =?Utf-8?B?QmFydCBXb3V0ZXJz?= Microsoft Excel Worksheet Functions 2 23rd Jul 2007 04:04 PM
Add Newline(s) inside a Cell Without Splitting Content into Different Cells Emily Microsoft Excel Programming 1 5th Sep 2006 11:31 PM
How do I insert a new line of text inside a cell =?Utf-8?B?dGh1ZHNvbg==?= Microsoft Excel New Users 4 3rd Apr 2006 06:08 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:46 PM.