Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/108080

From BetaArchive Wiki

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).

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open a new worksheet.
  2. Create a text box.
  3. Type the following lines:

          This is the shortest test of the wrap issue. <CR>
          Another line. <CR>
          And then another. <CR>
          Finally. <CR>
          The end. <CR>
  4. 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.
  5. With the box still selected, choose the item "Text..." from the "Format" menu.
  6. Select the Justify option under Horizontal, and click the OK button.
  7. 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.
    

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.

KBCategory: kbusage

KBSubcategory:

Additional reference words: 4.00



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 12, 1996
©1997 Microsoft Corporation. All rights reserved. Legal Notices.