Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Word and PowerPoint will print gridlines of embedded Excel object


View products that this article applies to.


If you are a Small Business customer, find additional troubleshooting and learning resources at the Support for Small Business Support for Small Businesssite.

Consider the following scenario:
  • In an Excel Worksheet, in the Sheet Optionssection of the Page Layout tab of the ribbon, you clear the Print box option under Gridlines.
  • You copy a part of that worksheet to your clipboard.
  • You paste that content into Word or PowerPoint as an Excel Worksheet Object, by using the “Paste Special” option.
  • You may have selected either the “Paste” or “Paste link” option in the “Paste Special” dialog box.
  • You save and close the document or presentation.
  • You reopen the document or presentation.
  • When you print the document or presentation the gridlines are printed.
  • You may also see the gridlines are visible in the print preview.

↑ Back to the top


Resolution

Turn off the Gridlines before you Copy and Paste the cells into a Word document or PowerPoint slide.

Note: You can also do this within the object you pasted into Word or PowerPoint.


Excel 2007 and 2010

  1. Go to the View tab and select the Show or Show/Hide group.
  2. Clear the Gridlines check box.

Excel 2003
  1. Select Tools > Options and click the View tab.
  2. Under Window options, clear the Gridlines check box.

For more information about how to work with gridlines in Excel, please review these version specific articles:

For more information about how to link and embed Excel objects in Word or PowerPoint, please review these useful articles:

↑ Back to the top


Keywords: consumeroff2010track, consumertargetofficefy12, kb

↑ Back to the top

Article Info
Article ID : 2616546
Revision : 1
Created on : 1/7/2017
Published on : 8/16/2012
Exists online : False
Views : 341