Cell size

D

Dale Wares

I have a text box in an Excel worksheet that only accepts about 200
characters of text. Is there a way to expand the cell to include additional
text? I get around the problem by splitting the text into multiple cells,
but this is inconvenient and messy.
 
J

Jim Rech

A cell can contain up to 32k characters of text. I'm not sure what the
limit of a Drawing toolbar Text Box or a Control Toolbox Text Box is but it
is many more than 200 characters. If you're using the latter make sure the
wordwrap and multiline properties are set on.

--
Jim Rech
Excel MVP
|I have a text box in an Excel worksheet that only accepts about 200
| characters of text. Is there a way to expand the cell to include
additional
| text? I get around the problem by splitting the text into multiple cells,
| but this is inconvenient and messy.
 
G

Guest

a suggestion.
don't use the text box for the toolbox.
use the text box from the drawing tool bar.
 
Top