Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1,805
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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1,388
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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to split wrapped text in a single cell into multiple lines Dr Fumanchu Excel Discussion (Misc queries) 2 February 27th 08 01:30 PM
Need to add 2 or more lines of data into a single cell in Excel Susan Excel Discussion (Misc queries) 2 July 31st 07 06:50 AM
Mulitple Windows in Single Workspace KT Excel Discussion (Misc queries) 1 May 29th 07 11:00 PM
two lines of text in a single row? SteveB Excel Discussion (Misc queries) 18 June 30th 05 05:09 PM
two lines of text in single row SteveB Excel Discussion (Misc queries) 2 May 17th 05 08:17 PM


All times are GMT +1. The time now is 05:54 AM.

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

About Us

"It's about Microsoft Excel"