#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default how do you

how do you have a double line within a cel when useing exel

another way to explain it would be

in the data is to long in the cell and i want to break it up into two lines
within the same cel
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 964
Default how do you

For text already entered do formatcellsalignment and select wrap text,
for text when entering press alt + enter for a new line to type, then make
sure the row size is adjusted
to fit the text

--


Regards,


Peo Sjoblom

"lewis" wrote in message
...
how do you have a double line within a cel when useing exel

another way to explain it would be

in the data is to long in the cell and i want to break it up into two
lines
within the same cel



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default how do you

Try,

Format|Cells
Alignment tab
Check 'Wrap text'

Mike

"lewis" wrote:

how do you have a double line within a cel when useing exel

another way to explain it would be

in the data is to long in the cell and i want to break it up into two lines
within the same cel

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default how do you

Two ways:

Format Cells... Alignment Wrap text
or
Insert hard returns in the text by touching ALT-ENTER
--
Gary''s Student - gsnu200800


"lewis" wrote:

how do you have a double line within a cel when useing exel

another way to explain it would be

in the data is to long in the cell and i want to break it up into two lines
within the same cel

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



All times are GMT +1. The time now is 01:39 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"