When you view a text box in a worksheet, text in the text box may be misaligned or truncated.
↑ Back to the top
This behavior may occur when the following conditions are true:
� | The text box has rounded corners.
-and-
|
� | You use a large (greater than 18) point size for some of the text in the text box.
Note that the larger the point size you use, the more pronounced the problem becomes. |
↑ Back to the top
To work around this behavior, use either of the following methods:
� | Reduce the point size of text in the text box.
Reducing the point size prevents text from appearing truncated. Note
that reducing the point size does not correct the problem if the text
box is simply too small to display all the text.
-or-
|
� | Resize the text box to a shape that can display all of the text. |
↑ Back to the top
In versions of Microsoft Excel earlier than Excel 97, when you apply rounded corners to a text box, the radius that defines the corners is the same in all text boxes regardless of the size of the text box.
In Microsoft Excel 2000, the radius that defines rounded corners in a text
box varies with the size of the text box. So, the radius of the corners of
a text box of width "x" and height "y" may be larger in Microsoft Excel 2000 than it is in versions of Microsoft Excel earlier than Excel 97.
This difference in behavior may cause problems when the text box contains
text that is formatted in a large point size. For example, text at the top
of the text box may shift down and to the right, away from the larger
rounded upper-left corner of the text box. This behavior may cause text in
the lower-right side of the text box to become truncated.
↑ Back to the top