Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text Wrapping Problem
I have a text wrapping problem. Text Doesn't wrap after a certain point.
I have following text in a cell . Cell height is 380 and width 81. mfdslfmsdlf sdflsdlfksdf sdfksdf'ksdf sdf'kdsf;kdsf dsf';kdsf;kdsf dsf;kdjashd asjdhasdh asldkhslad saldhksadas asdlhsdlhas asdlhasldkhasd asdlhasldhasd sadlkhsadkhasd asdlkhasdkhasd sadlkashdkasd asdkshadlhasd asdlkhasdkhasd asdlkhsadkhsad sadlkshdkhsad asdkhasdhaslkd asdkshadlhasd asdlkhsakdh sadlhsadlhas sadlasldkh sadlhsakdsh sdksakd asdlkhasdkhas asdlkhsadkas asdlkhsdkhsd asdlksahdkhasd asdlkashdlkhsad asdlkhasdklhsad asdlkhsdkhasd sldkhsalkdhasd asdlhaskdhasd sdashlkdhas asdlkhasdkhasd asdlkhsakdhas skdhsakhd asdklhsadlkhas aslkdhaslkdh asdlkhasldhas asdkhasdh sdlkhsadkhasld asdklhsadkhas ZZZZZZZZ asdlkhsakdh dslkashdkhasd asdlkhsdlkhsad asdlkhasldkhas saldhaslkhdas asdlkhasdlhasd asdlkhaskdhas asdkhsakhdalks asdlkhsaldkhasd asldhaslkdh sdlhasldkhas asdlkhasklhdas sdlkhasdkhask asdklhasdkhasd sadlhaslkdhaskd asdlkhsadkhasd sdlkhaslkdhasl daslkdhakshdkasld sadlkhasdhlkas dsakhaskdhlas sadkhasdhasd sadlhslakhd saldkhaslkdhlask asdlkhslkdhasl asdlsalkdhas sadlkhaskdhasd asdkhaslkdhsa sdlkhaslkd sadlkh Text doesn't wrap after ZZZZZZZ . What's the solution for this problem? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text Wrapping Problem
go into your text at various location and do
Alt+Enter to force a return. This should allow you to show more characters. There is an upper limit on cell height, so you might want to make the font smaller as well. -- Regards, Tom Ogilvy "Shashi Bhosale" wrote in message ... I have a text wrapping problem. Text Doesn't wrap after a certain point. I have following text in a cell . Cell height is 380 and width 81. mfdslfmsdlf sdflsdlfksdf sdfksdf'ksdf sdf'kdsf;kdsf dsf';kdsf;kdsf dsf;kdjashd asjdhasdh asldkhslad saldhksadas asdlhsdlhas asdlhasldkhasd asdlhasldhasd sadlkhsadkhasd asdlkhasdkhasd sadlkashdkasd asdkshadlhasd asdlkhasdkhasd asdlkhsadkhsad sadlkshdkhsad asdkhasdhaslkd asdkshadlhasd asdlkhsakdh sadlhsadlhas sadlasldkh sadlhsakdsh sdksakd asdlkhasdkhas asdlkhsadkas asdlkhsdkhsd asdlksahdkhasd asdlkashdlkhsad asdlkhasdklhsad asdlkhsdkhasd sldkhsalkdhasd asdlhaskdhasd sdashlkdhas asdlkhasdkhasd asdlkhsakdhas skdhsakhd asdklhsadlkhas aslkdhaslkdh asdlkhasldhas asdkhasdh sdlkhsadkhasld asdklhsadkhas ZZZZZZZZ asdlkhsakdh dslkashdkhasd asdlkhsdlkhsad asdlkhasldkhas saldhaslkhdas asdlkhasdlhasd asdlkhaskdhas asdkhsakhdalks asdlkhsaldkhasd asldhaslkdh sdlhasldkhas asdlkhasklhdas sdlkhasdkhask asdklhasdkhasd sadlhaslkdhaskd asdlkhsadkhasd sdlkhaslkdhasl daslkdhakshdkasld sadlkhasdhlkas dsakhaskdhlas sadkhasdhasd sadlhslakhd saldkhaslkdhlask asdlkhslkdhasl asdlsalkdhas sadlkhaskdhasd asdkhaslkdhsa sdlkhaslkd sadlkh Text doesn't wrap after ZZZZZZZ . What's the solution for this problem? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text Wrapping Problem
hi i tried your text and row and column setting - i have no problem wrapping the text. i am using excel 2000 - what are you using? what font size? *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text Wrapping Problem
remove all the hard returns you get from copying it from the email, so it is
a text string with no hard returns in it. Put it in a cell, select it in the formula bar using Ctrl+C, go to the end of the string and do Ctrl+V to paste a copy - now the string is twice as long. You should see that the entire string is not displayed in the worksheet (it is in the formula bar). -- Regards, Tom Ogilvy wrote in message ... hi i tried your text and row and column setting - i have no problem wrapping the text. i am using excel 2000 - what are you using? what font size? *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I prevent a long string of text from wrapping in a text fil | Excel Discussion (Misc queries) | |||
Wrapping text with line breaks problem | Excel Discussion (Misc queries) | |||
Auto fit and text wrapping problem | Excel Worksheet Functions | |||
text wrapping when text is pasted in excel | Excel Discussion (Misc queries) | |||
I am using wrap text in excel, so why isn't all my text wrapping? | Excel Discussion (Misc queries) |