A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Mulitple text lines in a single cell



 
 
Thread Tools Display Modes
  #1  
Old March 6th, 2009, 11:49 PM posted to microsoft.public.excel.newusers
Mrs.Aguire
external usenet poster
 
Posts: 1
Default Mulitple text lines in a single cell

I need to type several sentences into one single cell but I can not for the
life of me figure out how to get it to make mulitple text lines in one
cell...

It looks like this........

and I need
it to look
like this.

Please please help!
  #2  
Old March 6th, 2009, 11:56 PM posted to microsoft.public.excel.newusers
Sheeloo[_3_]
external usenet poster
 
Posts: 1,713
Default Mulitple text lines in a single cell

After typing each line press ALT-ENTER instead of ENTER to go to the next
line in the same cell.
--
--------
If this is what you wanted then press the ''''YES'''' button (if you see it)


"Mrs.Aguire" wrote:

I need to type several sentences into one single cell but I can not for the
life of me figure out how to get it to make mulitple text lines in one
cell...

It looks like this........

and I need
it to look
like this.

Please please help!

  #3  
Old March 7th, 2009, 03:31 AM posted to microsoft.public.excel.newusers
Dave
external usenet poster
 
Posts: 2,331
Default Mulitple text lines in a single cell

Hi,
Right click on the cell you want, then choose Format cells. Choose the
Alignment tab, then tick the Wrap text tick box.
This will give you multiple lines in your cell, but you won't have much
control over where each line starts and finishes. To control this, when you
type some text, then want to start a new line within the same cell, press
Alt+Enter.
Hope this helps.
Regards - Dave.
 




Thread Tools
Display Modes

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 Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:08 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.