Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text is cutoff in a cell
I have a large amount of text in a merged, wrapped cell. It is about 25
lines long, but only the first 12 are showing. I have tried to enlarge the height of the cell, but then it just shows black space, not the rest of the text. How would I fix this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text is cutoff in a cell
Excel will accepts 32,000+ characters in a cell, but it limits the display to
1,024 characters. My guess is that you've maxed out the display limit. If you have MS Word you can copy the text into a Word document and then do a word count, you'll also get a count of characters along with the word count total. -- Kevin Backmann "Jessica" wrote: I have a large amount of text in a merged, wrapped cell. It is about 25 lines long, but only the first 12 are showing. I have tried to enlarge the height of the cell, but then it just shows black space, not the rest of the text. How would I fix this. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text is cutoff in a cell
That would explain it. Thank you!
"Kevin B" wrote: Excel will accepts 32,000+ characters in a cell, but it limits the display to 1,024 characters. My guess is that you've maxed out the display limit. If you have MS Word you can copy the text into a Word document and then do a word count, you'll also get a count of characters along with the word count total. -- Kevin Backmann "Jessica" wrote: I have a large amount of text in a merged, wrapped cell. It is about 25 lines long, but only the first 12 are showing. I have tried to enlarge the height of the cell, but then it just shows black space, not the rest of the text. How would I fix this. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text is cutoff in a cell
You can see lots more than those approximately 1000 characters if you add
alt-enters every 80-100 characters. Jessica wrote: I have a large amount of text in a merged, wrapped cell. It is about 25 lines long, but only the first 12 are showing. I have tried to enlarge the height of the cell, but then it just shows black space, not the rest of the text. How would I fix this. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text is cutoff in a cell
WOW! At first I thought you were crazy but I just tried alt-enter and it
works perfectly! Thank you so much for sharing. It's always good to learn something new. Steph "Dave Peterson" wrote: You can see lots more than those approximately 1000 characters if you add alt-enters every 80-100 characters. Jessica wrote: I have a large amount of text in a merged, wrapped cell. It is about 25 lines long, but only the first 12 are showing. I have tried to enlarge the height of the cell, but then it just shows black space, not the rest of the text. How would I fix this. -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text is cutoff in a cell
Just because it worked doesn't necessarily eliminate the possibility that I'm
crazy!!!!!! Both things could be true! <vbg Stephanie Nicolosi wrote: WOW! At first I thought you were crazy but I just tried alt-enter and it works perfectly! Thank you so much for sharing. It's always good to learn something new. Steph "Dave Peterson" wrote: You can see lots more than those approximately 1000 characters if you add alt-enters every 80-100 characters. Jessica wrote: I have a large amount of text in a merged, wrapped cell. It is about 25 lines long, but only the first 12 are showing. I have tried to enlarge the height of the cell, but then it just shows black space, not the rest of the text. How would I fix this. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Y Axis Label is Cutoff | Charts and Charting in Excel | |||
need to add colored horizontal line on chart to show cutoff level | Charts and Charting in Excel | |||
Excel "Value (Y) Axis" is cutoff--Fix it! | Charts and Charting in Excel | |||
Information in the cells is being cutoff when i print in Excel. | Excel Discussion (Misc queries) | |||
CUTOFF | Excel Discussion (Misc queries) |