Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]() 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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]() 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
![]() |
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
Why doesn't text wrap in a cell in Excel? | Excel Discussion (Misc queries) | |||
how many lines can be in wrap text within a cell? | Excel Worksheet Functions | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) |