MS Excel 2002 - Text Field Size Limit

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.

Windows Software 5498 This topic was started by ,


data/avatar/default/avatar18.webp

484 Posts
Location -
Joined 2001-10-23
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?

Participate on our website and join the conversation

You have already an account on our website? Use the link below to login.
Login
Create a new user account. Registration is free and takes only a few seconds.
Register
This topic is archived. New comments cannot be posted and votes cannot be cast.

Responses to this topic


data/avatar/default/avatar12.webp

75 Posts
Location -
Joined 2003-05-05
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.

data/avatar/default/avatar18.webp

484 Posts
Location -
Joined 2001-10-23
OP
Thanks for the reply.
 
My cell height though isn't even at 500, nor the width 255, though. Any ideas?

data/avatar/default/avatar05.webp

748 Posts
Location -
Joined 2001-05-21
You've got wrap text on?
 
Rgds
AndyF

data/avatar/default/avatar38.webp

5 Posts
Location -
Joined 2003-08-26
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?

data/avatar/default/avatar18.webp

484 Posts
Location -
Joined 2001-10-23
OP
Hmm...
 
That's likely it. I'll try to find out for sure and post back later.
 
Thanks for the responses.