Copying a spreadsheet in to a Word Document

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am copying part of a spreadsheet in to a word document and would like to remove the gridlines from the "Excel Object" that I paste in. Can this be done without removing the gridlines from my spreadsheet?
 
Usually if you Copy and Paste part of a spreadsheet into Word it comes in in
the form of a table. You can click the "Table" menu and click "Hide
Gridlines" if you want. If your spreadsheet data has borders around your
cells, you will need to select the table, open the Tables and Borders
toolbar and select the "No Border" option, then turn off the gridlines if
you want. Keep in mind that regular gridlines do NOT normally print so
there really isn't any need to turn them off.

--
Bill Foley, Microsoft MVP (PowerPoint)
Microsoft Office Specialist Master Instructor
www.pttinc.com
Check out PPT FAQs at: http://www.rdpslides.com/pptfaq/
"Success, something you measure when you are through succeeding."

RB said:
I am copying part of a spreadsheet in to a word document and would like to
remove the gridlines from the "Excel Object" that I paste in. Can this be
done without removing the gridlines from my spreadsheet?
 
As long as you don't link the object to the original spreadsheet, but rather
embed it, you can open the embedded object back up in Excel by
right-clicking it and choosing Excel object>Open. Then in Excel,
Tools>Options>View>Window Options: uncheck Gridlines. Close and quit Excel,
your object in Word should now show without gridlines, but the original
spreadsheet unchanged.

cjd


RB said:
I am copying part of a spreadsheet in to a word document and would like to
remove the gridlines from the "Excel Object" that I paste in. Can this be
done without removing the gridlines from my spreadsheet?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top