Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
My problem is that I have a large amount of text in one cell. I've clicked on the wrap text box and have tried the format/row/auto fit selection also. Not all of my text is being displayed or when I try to print . Any ideas??? Thanks -- Bruce DiPaola |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
This is a well-known problem (Excel's not yours). The text is actually
there, it just doesn't show. To fix the problem, insert a hard return every 1000 characters or so. Use ALT-ENTER as the hard return -- Gary's Student "Bruce D." wrote: Hello, My problem is that I have a large amount of text in one cell. I've clicked on the wrap text box and have tried the format/row/auto fit selection also. Not all of my text is being displayed or when I try to print . Any ideas??? Thanks -- Bruce DiPaola |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
There is a limit to what can be type in a cell, and a limit to what will be
displayed. Cell limits a 32,767 characters maximum. Only 1,024 display in a cell All 32,767 display in the formula bar. -- Kevin Backmann "Bruce D." wrote: Hello, My problem is that I have a large amount of text in one cell. I've clicked on the wrap text box and have tried the format/row/auto fit selection also. Not all of my text is being displayed or when I try to print . Any ideas??? Thanks -- Bruce DiPaola |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If you add alt-enters to force a new line every 80-100 characters, you can see
more. Bruce D. wrote: Hello, My problem is that I have a large amount of text in one cell. I've clicked on the wrap text box and have tried the format/row/auto fit selection also. Not all of my text is being displayed or when I try to print . Any ideas??? Thanks -- Bruce DiPaola -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Just one cell in an Excel column won't text wrap. | New Users to Excel | |||
Possible to wrap text in combo box? | Excel Worksheet Functions | |||
Wrap text ceases to function in Excel if cell exceeds 9 lines | Excel Worksheet Functions | |||
####### within a wrap text cell. | Excel Discussion (Misc queries) | |||
Wrap Text won't work | Excel Discussion (Misc queries) |