Unwanted Excel gridlines in Word

[Guest]

I have a table I have copied and pasted as a link from Excel into a Word
document. I have the gridlines option turned off in Excel. The table shows
up correctly in the Word document and in a print preview of the word
document, but when I print a hard copy, the gridlines show in the table. How
do I fix this?

Much thanks!

 

[Guest]

I've also made sure the option in Word under Tables to Hides Grid Lines is
correct.

 

[Suzanne S. Barnhill]

Gridlines and borders are not the same (see
http://word.mvps.org/FAQs/TblsFldsFms/Gridlines.htm). You can remove the
table border with Ctrl+Alt+U.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Guest]

OK, got it figured out and decided I would post what I found for anyone
with a similar issue.

Turns out there are 3 areas that control whether gridlines show up in an
Excel Worksheet object, pasted as a link, in a Word document. If you DON'T
want the gridlines to print on the table in Word, make sure

1) In Excel under Tools Options make sure on the View tab Gridlines is NOT
checked. Do this for each tab in the workbook that will support a table in
the Word document.

2) In Excel under File Page Set Up, on the Sheet tab make sure Gridlines is
not checked. Do this for each tab in the workbook that will support a table
in the Word document.

3) In Word under Table make sure the option for Hide Gridlines has been
selected. (If it has, then the menu selection will be Show Gridlines

Hope this helps all!

 

[Suzanne S. Barnhill]

Hiding or showing gridlines in Word has no effect on whether they will
print; if they print, they're borders, not gridlines. And I believe it's
only (2) that governs whether data pasted from Excel into Word gets borders.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.