#1   Report Post  
anukrish17
 
Posts: n/a
Default Wrap Text


Hi

I pasted a paragraph of text in a cell and then formatted it to wrap
the text.
Now I want to paste another paragraph in the same cell. The second
paragh, however, does not look wrapped and I am unable to wrap it. The
first few/last few lines look deleted and am not able to see the two
paragraphs in full.

Also, is there a maximum limit to the height and width of a cell?

THanks
Aks


--
anukrish17
------------------------------------------------------------------------
anukrish17's Profile: http://www.excelforum.com/member.php...o&userid=24967
View this thread: http://www.excelforum.com/showthread...hreadid=384946

  #2   Report Post  
rook
 
Posts: n/a
Default

on the rows header (where the numbers are) position your cursor between the
numbers and double click. or hold down and drag to the correct width.

"anukrish17" wrote:


Hi

I pasted a paragraph of text in a cell and then formatted it to wrap
the text.
Now I want to paste another paragraph in the same cell. The second
paragh, however, does not look wrapped and I am unable to wrap it. The
first few/last few lines look deleted and am not able to see the two
paragraphs in full.

Also, is there a maximum limit to the height and width of a cell?

THanks
Aks


--
anukrish17
------------------------------------------------------------------------
anukrish17's Profile: http://www.excelforum.com/member.php...o&userid=24967
View this thread: http://www.excelforum.com/showthread...hreadid=384946


  #3   Report Post  
anukrish17
 
Posts: n/a
Default


I tried both but it did not work for me.
I did widen the cell and could see the entire content. But I want the
paragraphs one below the other. All I have to do is enter the first
paragh copy paste it in the same cell --- it's the same paragh twice
one below the other so that it need not be too wide. Any ideas?


--
anukrish17
------------------------------------------------------------------------
anukrish17's Profile: http://www.excelforum.com/member.php...o&userid=24967
View this thread: http://www.excelforum.com/showthread...hreadid=384946

  #4   Report Post  
swatsp0p
 
Posts: n/a
Default


I think you need to force a carriage return. With your cell selected,
press F2 to enter the edit mode. Place the cursor at the end of your
first paragraph and press ALT+ENTER to force a new line within your
cell. Press ENTER to commit. Now your next paragraph will be below
the first one.

Does this work for you?

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=384946

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
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
Wrap text limits in Excel 2003 cell formatting Adelrose Excel Discussion (Misc queries) 1 April 19th 05 06:32 PM
Why doesn't text wrap in a cell in Excel? rohrbaught Excel Discussion (Misc queries) 6 April 8th 05 06:13 PM
how many lines can be in wrap text within a cell? pearsms Excel Worksheet Functions 2 December 27th 04 06:11 PM
Concatenation formula loses text wrap formatting DFM Excel Discussion (Misc queries) 5 December 27th 04 01:45 PM


All times are GMT +1. The time now is 11:00 AM.

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

About Us

"It's about Microsoft Excel"