Microsoft KB Archive/100387

Microsoft Knowledge Base

Excel: Text Formatted with Vertical Center Alignment Skewed

Last reviewed: September 12, 1996
Article ID: Q100387

The information in this article applies to:

• Microsoft Excel for Windows, versions 4.0, 4.0a
• Microsoft Excel for the Macintosh, versions 4.0

SUMMARY

In Microsoft Excel, if the vertical alignment of a cell is set to center, the screen may be incorrectly redrawn and the text within the cell may be shifted vertically up or down a very small amount.

Workaround

To realign the text in the cell, repaginate the worksheet by scroll up or down through the text of your document; to do this, press PAGE UP or PAGE DOWN or use the scroll bars.

MORE INFORMATION

If you format a cell to have vertical center alignment, any text you enter into the cell will be centered correctly within the cell. However, if you reapply the vertical centering to the same cell, the text may shift up or down slightly from the center of the cell. Because the repositioning of the text is extremely slight (approximately one pixel), this problem will be more noticeable if you are using a lower-resolution video display.

REFERENCES

"Microsoft Excel User's Guide 1," version 4.0, pages 228-229

KBCategory: kbother KBSubcategory: Additional reference words: 4.00 4.00a 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.