Microsoft Knowledge Base

MXL: Cannot Set Row Height to a Decimal Value
Last reviewed: September 12, 1996
Article ID: Q141179
The information in this article applies to:
  • Microsoft Excel for the Macintosh, versions 2.2, 2.2a, 3.0, 3.0a, 4.0, 5.0, 5.0a
  • Microsoft Excel for the Power Macintosh, versions 5.0, 5.0a

SYMPTOMS

In Microsoft Excel for the Macintosh, when you enter a row height as a decimal value, the number is rounded to a whole number.

STATUS

Microsoft has confirmed this to be a problem in the versions of Microsoft Excel listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

To set the height of a row, use the appropriate procedure for your version of Microsoft Excel.

Method 1: Microsoft Excel version 5.0 

          1. On the Format menu, point to Row, and then click Height.

          2. Enter any number in the Row Height box, and then
             click OK.
Method 2: Microsoft Excel versions 2.2, 3.0, and 4.0 

          1. On the Format menu, click Row Height.

          2. Enter any number in Row Height box, and then click OK.
After you use either of these methods, the number that you entered for the row height may be rounded down to the nearest multiple of .25. For example, if you set the row height to 14.9 and then select the row height in the row height dialog box, the value 14.75 will be displayed.

If you place the insertion point on the border between the row for which you just changed the height and the next row, and then click and hold down your mouse button, the actual height of the row (14.00 in this example) is displayed in the reference box of the formula bar. Microsoft Excel takes the number you enter for the row height and sets the actual row height to the integer portion of that number.

REFERENCES

"Microsoft Excel User's Guide," version 5.0, Chapter 12, "Changing Column Widths and Row Heights"

For more information about Row Heights, choose the Search button in Help and type: 

   row height

KBCategory: kbusage
KBSubcategory: xlmac

Additional reference words: 2.20 2.20a 3.00 3.00a 4.00 5.00 5.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.