Excel: Aligning Text or Numbers at the Top of a Cell

Last reviewed: November 2, 1994
Article ID: Q70111

SUMMARY

In Microsoft Excel version 3.00, to align text or numbers at the top of a cell, choose Alignment from the Format menu and select Wrap Text for that cell.

When a single-line text string is in the same row as multiple-line text strings or text with a large font, Excel defaults the text to align at the bottom of the cell. When Wrap Text is turned on, Excel moves the value to the top of the cell. (Note: This procedure also works for numbers.)

For more information on the Format Alignment command, see page 186 of the "Microsoft Excel User's Guide" version 3.0 manual.

KBCategory: kbother
KBSubcategory:
Additional reference words: noupd

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: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.