Line Object Is Missing When Printed or Viewed in Print Preview (177843)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q177843 SYMPTOMS
If you create a line, arrow, or connector line with the Drawing toolbar,
and then move it to a cell boundary by using the Snap To Grid tool or by
pressing ALT, the line may not appear when you print it or when you view
it in print preview.
CAUSE
This problem occurs when following conditions are true: - You move a line, arrow, or connector to the edge of a cell by pressing
ALT or by using the Snap To Grid tool on the Drawing toolbar.
-and-
- You align the line, arrow, or connector horizontally.
NOTE: The problem also occurs if you align the object vertically
on a vertical page break.
-and-
- There are no other objects on the worksheet.
This behavior occurs regardless of the thickness you specify for the line
or the presence of gridlines.
WORKAROUND
To work around this behavior, try adding lines or data to the worksheet.
When you do this, the lines may appear when you print the worksheet or
when you view the worksheet in print preview. You can insert another kind
of graphic object on the same worksheet and set the object properties so
that it is not printed. To do this, follow these steps: - Click Toolbars on the View menu and click Drawing if the Drawing
toolbar is not selected.
- Click the Rectangle tool on the Drawing toolbar.
- Position the insertion point on the worksheet that contains the line
object, and then drag the pointer to insert a rectangle on the
worksheet.
NOTE: The size of the rectangle doesn't matter. - With the rectangle selected, click AutoShape on the Format menu.
- Click the Colors And Lines tab.
- Under Fill, click No Fill in the Color list.
- Under Line, click No Color in the Color list.
- Click OK.
STATUS
Microsoft has confirmed this to be a problem in the products listed at the
beginning of this article.
| Modification Type: | Minor | Last Reviewed: | 8/19/2003 |
|---|
| Keywords: | kbbug kbprint KB177843 |
|---|
|