Embedded Excel File within Word Document, borders issue.

J

jmc2009

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

Hi there,

I have a mail merge Word document that has an embedded Excel file within it. When I click on the Excel file all the lines appear meaning that it'll show in the PDF version. I am aware I can take the lines off through options but is there a default option to stop me having to do that every single time?

Thanks,
 
J

John McGhie

Are you SURE they will show up in the PDF?

Did you test it? The fact that Word makes the borders visible does not mean
it's going to print them.

In my testing, Excel borders show up. Gridlines do not.

Cheers


Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

Hi there,

I have a mail merge Word document that has an embedded Excel file within it.
When I click on the Excel file all the lines appear meaning that it'll show in
the PDF version. I am aware I can take the lines off through options but is
there a default option to stop me having to do that every single time?

Thanks,


--

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]
 
J

jmc2009

Hi there,

Yes, it comes out on the PDF, so I have all the borders of the Excel file.

Thanks,
 
J

John McGhie

Then open the Excel file and turn the borders off in there.

If you have applied borders in the Excel file, they will appear in Word.
Make sure you understand the difference between "borders" and "gridlines".
Borders print, gridlines don't.

Word has no control over this, it's out of the picture. Word just makes a
"hole" in the document to allow Excel to display whatever it wants inside.
The formatting and display is all done by Excel.

Cheers


Hi there,

Yes, it comes out on the PDF, so I have all the borders of the Excel file.

Thanks,


--

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]
 

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

Top