MS Excel 2002 - Text Field Size Limit
This is a discussion about MS Excel 2002 - Text Field Size Limit in the Windows Software category; I've got a large chunk of text in a cell, formatted to general under the numbers tab, but it won't display or print all the text, even though there is plenty of room at the bottom of the cell. The only place it shows all the text is in the dropdown fx box where you enter formulas.
I've got a large chunk of text in a cell, formatted to general under the numbers tab, but it won't display or print all the text, even though there is plenty of room at the bottom of the cell. The only place it shows all the text is in the dropdown fx box where you enter formulas.
Anyone know how to get this information to show on the sheet and also when printing?
Anyone know how to get this information to show on the sheet and also when printing?
Participate in our website and join the conversation
This subject has been archived. New comments and votes cannot be submitted.
Aug 14
Aug 27
0
1 minute
Responses to this topic
Excel XP can only have a maximum row height of 500 and cell width of 255. If your text exceeds that then you are out of luck.
OP
Thanks for the reply.
My cell height though isn't even at 500, nor the width 255, though. Any ideas?
My cell height though isn't even at 500, nor the width 255, though. Any ideas?
You've got wrap text on?
Rgds
AndyF
Rgds
AndyF
Specifications of Microsoft Excel 2002:
32,767 characters per cell. Only 1,024 displayed in a cell; all 32,767 display in the formula bar.
Maybe this is why?
32,767 characters per cell. Only 1,024 displayed in a cell; all 32,767 display in the formula bar.
Maybe this is why?
OP
Hmm...
That's likely it. I'll try to find out for sure and post back later.
Thanks for the responses.
That's likely it. I'll try to find out for sure and post back later.
Thanks for the responses.
