Microsoft KB Archive/104579

From BetaArchive Wiki

XL3/XL4: Function with Best Fit Removes Borders from Worksheet

The information in this article applies to:

  • Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a
  • Microsoft Excel for OS/2, version 3.0
  • Microsoft Excel for the Macintosh, versions 3.0, 3.0a, 4.0


In Microsoft Excel, if you use the ROW.HEIGHT() macro function to format a range of cells with a best-fit height, borders may be removed from your worksheet.

This problem occurs most frequently when borders have been applied to the entire row or column.


To work around this problem, do one of the following:

  • Apply borders to a range of cells rather than to the entire column or row.


  • If you must apply borders to the entire column and/or row, specify the entire worksheet for the reference argument. For example, use


to change all the rows on the worksheet to a best-fit row height.

Note that when you use this workaround borders may still be removed from the first row of the worksheet.


  • Use the BORDER() function in your macro to replace the borders on the worksheet after you've applied the best-fit formatting.


Microsoft has confirmed this to be a problem in Microsoft Excel versions 3.0, 4.0 and 4.0a for Windows, and Microsoft Excel versions 3.0 and 4.0 for the Macintosh. We are researching this problem and will post new information here as it becomes available.


"Function Reference," version 3.0, pages 201-202
"Function Reference," version 4.0, pages 365-366

Additional query words: deleted clear M_eXceL XL3 XL4

Keywords :
Version : WINDOWS:3.0,4.0,4.0a; OS/2:3.0; MACINTOSH:3.0,4.0
Issue type :
Technology :

Last Reviewed: April 7, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.