Microsoft KB Archive/110725

Microsoft Knowledge Base

XL: Line Object Not Printing in Column A

Last reviewed: March 27, 1997
Article ID: Q110725

3.00 4.00 4.00a 5.00 5.00c 7.00 7.00a | 3.00 4.00 5.00 5.00a

WINDOWS                               | MACINTOSH

kbusage

The information in this article applies to:

• Microsoft Excel for Windows versions 3.0, 4.0, 4.0a, 5.0, 5.0c
• Microsoft Excel for the Macintosh, versions 3.0, 4.0, 5.0, 5.0a
• Microsoft Excel for Windows 95, versions 7.0, 7.0a

SYMPTOMS

When you use the Line Drawing button on the Drawing toolbar to attach a line to the left side of column A, the line may not appear when you print your document or view it in print preview.

CAUSE

This behavior occurs when the Cell Gridlines check box is cleared in the Page Setup dialog box.

WORKAROUND

To work around this problem, do either of the following to add a border (rather than a line) to the left of the column:

• Select the left border option from the Borders button on the Formatting toolbar. (You can display the Formatting toolbar by choosing Toolbars from the Options menu.)

  -or-

1. Select the cells in column A that require a line on the left-hand side of the column.
2. In versions 3.x and 4.x, choose Border from the Format menu. In version 5.0, choose Cells from the Format menu, and then select the Border tab.
3. In the Border dialog box, choose the appropriate line weight and select Left. Select OK to accept the change.

REFERENCES

"User's Guide," version 5.0, pages 207-208 "User's Guide 1," version 4.0, page 239 "User's Guide 2," version 4.0, page 180

KBCategory: kbusage KBSubcategory: Additional reference words: 3.00 4.00a 4.00 5.00 7.00 Keywords : kbusage Version : 3.00 4.00 4.00a 5.00 5.00c 7.00 Platform : MACINTOSH WINDOWS 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: March 27, 1997 ©1997 Microsoft Corporation. All rights reserved. Legal Notices.