How to remove unwanted gridlines from an Excel object (152299)



The information in this article applies to:

  • Microsoft Office 98 Macintosh Edition
  • Microsoft Office for the Macintosh 4.2
  • Microsoft Office for the Macintosh 4.2.1
  • Microsoft Office 2004 for Mac Standard Edition
  • Microsoft Office 2001 for Mac
  • Microsoft Office 2003, All Editions
  • Microsoft Office XP
  • Microsoft Office 2000, All Editions
  • Microsoft Office 97 for Windows
  • Microsoft Office for Windows 95
  • Microsoft Office for Windows 4.2
  • Microsoft Office for Windows 4.3

This article was previously published under Q152299

SUMMARY

When you embed or link a Microsoft Excel object to a document created in another Office program, you may notice that the gridlines from Microsoft Excel are visible in the destination document.

MORE INFORMATION

To remove the gridlines, use the following steps.

For Microsoft Office versions 4.2 and later versions of Office for Microsoft Windows and for Microsoft Office versions 4.2 and 4.2.1 for Macintosh

  1. Double-click the Microsoft Excel object to activate in-place editing in Microsoft Excel.
  2. On the Tools menu, click Options.
  3. Click the View tab.

    If you do not see a View tab, check the Apple menu (Macintosh) or the Help menu (Windows) to verify that Microsoft Excel is active. If Microsoft Excel is active, you should see About Microsoft Excel as the first entry on the Apple menu or the last entry in the Help menu.
  4. In the Window Options section, clear the Gridlines check box.
  5. Return to the destination document by clicking outside the boundaries of the Microsoft Excel object.
If you want to display gridlines, repeat the above steps except select (put a check mark in) the Gridlines check box in step 4.

For Microsoft Office 98 Macintosh Edition

  1. Double-click the Microsoft Excel object.
  2. On the Tools menu, click Preferences.
  3. On the View tab, click to clear the Gridlines check box, and then click OK.
  4. On the File menu, click Quit to close the Microsoft Excel object.

For Microsoft Office 2001 for Mac and for Microsoft Office 2004 for Macintosh Edition

  1. Double-click the Microsoft Excel object.
  2. On the Excel menu, click Preferences.
  3. In Windows options, click to clear the Gridlines check box, and then click OK.
  4. On the File menu, click Quit to close the Microsoft Excel object.

Modification Type:MajorLast Reviewed:2/10/2006
Keywords:kbhowto kbinterop KB152299