Deleting Horizontal Lines that Appear on Protected Documents

 Last reviewed: November 30, 1994
Article ID: Q74652
The information in this article applies to:
  • Microsoft Excel for Windows versions 2.x, 3.0 and 4.0
  • Microsoft Excel for OS/2 versions 2.2 and 3.0
  • Microsoft Excel for the Macintosh version 2.x, 3.0 and 4.0

SUMMARY

Microsoft Excel underlines all unlocked cells on a worksheet or macro sheet when the document has been protected by choosing Protect Document from the Options menu, and when the Gridlines option has been turned off in the dialog box that appears when you choose Display from the Options menu.

MORE INFORMATION

In Microsoft Excel version 2.x, the unlocked cells will display underlines in the document, in print preview, and on the printed output.

In Microsoft Excel versions 3.0 or 4.0, the unlocked cells will display underlines in the document, but will neither display the underlines in print preview nor print them out.

The difference between the two workarounds below is that in Workaround 1 with Microsoft Excel versions 3.0 and 4.0, your row and column headings will not display. Microsoft Excel version 2.x will still display the row and column headings. Workaround 2 will display the row and column headings and can only be used with Microsoft Excel versions 3.0 or 4.0.

Workaround 1

To keep the underlines from displaying, previewing or printing in Microsoft Excel versions 2.x, 3.0 or 4.0, do the following:

  1. Activate your document.

  2. From the Options menu, choose Display and select the Gridlines check box.

  3. Set the Gridline & Heading Color options to white and choose OK.

Workaround 2

To keep the underlines from displaying in Microsoft Excel versions 3.0 or 4.0:

  1. Activate your document.

  2. Select the entire document by pressing CTRL+SHIFT+SPACEBAR.

  3. Unprotect your document by choosing Unprotect Document from the Options menu.

  4. From the Format menu, choose Border.

  5. Select Bottom and set the color option to match your worksheet background. Choose OK.

  6. Reprotect your document by choosing Protect Document from the Options menu and typing a password if preferred. Choose OK.

REFERENCES

"User's Guide 1," version 4.0, page 90

"Microsoft Excel User's Guide," version 3.0, page 566

"Microsoft Excel Reference Guide," version 2.1, page 578

KBCategory: kbusage
KBSubcategory:

Additional reference words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0
3.00 4.0 4.00

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: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.