Word and PowerPoint will print gridlines of embedded Excel object


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.

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:

Proprietà

ID articolo: 2616546 - Ultima revisione: 16 ago 2012 - Revisione: 1

Microsoft Office Excel 2003, Microsoft Office Excel 2007, Microsoft Excel 2010

Feedback