Re: Unwanted Excel gridlines in Word

[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
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Craig Bowden" <Craig...@discussions.microsoft.com> wrote in message
news:E12F3BD4-2A5A-4BCB...@microsoft.com...
> I've also made sure the option in Word under Tables to Hides Grid Lines is
> correct.
>
> "Craig Bowden" wrote:
>
> > 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!

[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
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Craig Bowden" <Craig...@discussions.microsoft.com> wrote in message

news:3F1C64F9-B736-4E7E...@microsoft.com...
> 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!