Microsoft KB Archive/108080

= Microsoft Knowledge Base =

Excel: Text Box Not Justified Correctly
Last reviewed: September 12, 1996

Article ID: Q108080

The information in this article applies to:


 * Microsoft Excel for the Macintosh, version 4.0

SUMMARY
When you set the alignment of a text box to Justify, all the text in that text box will be justified. This behavior occurs regardless of carriage returns (normally a carriage return terminates a line prevents it from being justified).

Steps to Reproduce Behavior
 Open a new worksheet. Create a text box.  Type the following lines: This is the shortest test of the wrap issue.  Another line.  And then another.  Finally.  The end.   Adjust the right border of the text box so that the last "t" in "test" is cut off and forced to wrap to the next line. With the box still selected, choose the item "Text..." from the "Format" menu. Select the Justify option under Horizontal, and click the OK button.</li>  The test box should resemble the following example: This   is    the    shortest test of   the   wrap   issue. Another                 line. And       then       another. Finally. The                      end. </li></ol>

The following example shows how the text box should appear and how it appears if an operation is performed in a cell.

This   is    the    shortest test of the wrap issue. Another line. And then another. Finally. The end.