Microsoft KB Archive/178023

= XL97: Line and Border Are Not Aligned When Printed or Viewed in Print Preview =

Article ID: 178023

Article Last Modified on 11/23/2002

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q178023



SYMPTOMS
If you connect a line object to a thin cell border, the object may not be aligned to the cell border when you print it. Instead, the object may be slightly above the border (if the line is horizontally aligned ) or the object may be slightly to the left of the border (if the line is vertically aligned).



CAUSE
This behavior may occur when the following conditions are true:
 * You use a tool on the drawing toolbar to draw a line or arrow, and then align the object with a cell boundary by using the Snap To Grid feature or by pressing the ALT key as you move the line object.

To use the Snap to Grid feature, click Draw on the Drawing toolbar, and then point to Snap. -and-


 * You click an adjacent cell and apply the thinnest border available (Click Cells on the Format menu and click the Border tab). -and-


 * You connect the border to the line to make the border appear longer. -and-


 * You print the worksheet or view it in print preview.

NOTE: The problem is more noticeable in the printed output.



WORKAROUND
To work around this problem, use cell borders only to format the cells or to use line drawings only to format the cell. That is, do not mix line objects and borders when you create a long horizontal or vertical line.

NOTE: It may be possible work around this problem by decreasing the printer resolution for your printer.



STATUS
Microsoft has confirmed this to be a problem in the products listed above.



MORE INFORMATION
When you use the drawing tool, the default line weight is .75 point. If you change the line object weight to .25 point so that the line and the thin border are the same thickness, the line object and the cell border still are not aligned.

Additional query words: XL97 constrain constrained lined up line

Keywords: kbprint KB178023

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.