Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Grid lines won't go away in pasted Excel table

1,431 views
Skip to first unread message

Dave Montcalm

unread,
May 23, 2001, 9:17:05 AM5/23/01
to
I've pasted part of an Excel spreadsheet into a Word97 doc, but I can't get
the grid lines to go away.

I try setting the cell properties in Excel so that the lines are turned off
in Excel before I copy, but that doesn't help. I try to turn off the lines
in Word too, but Word sees the Excel stuff as an object, not a table, and it
won't let me set individual borders as with a table.

Help!
-Dave


Beth Melton

unread,
May 23, 2001, 9:53:00 AM5/23/01
to
Hi Dave,

Try turning off the gridlines in Excel under Tools/Options/View
instead.

Also if you're concerned that the gridlines will print, the embedded
Excel worksheet will follow the print options as specified in Excel
under File/Page Setup. So if you do not have Gridlines selected on the
Sheet tab then when you print the Word document they will not print.
Note that they will still display in Print Preview, however they will
not appear when the document is actually printed.

As another suggestion, if you do not need to edit the Excel worksheet
then you can also copy it as a picture instead. For this, in Excel
select your cells, hold <Shift>, click the Edit menu and select Copy
Picture. You would want the option "As shown when printed".
~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Please post replies/further questions to the newsgroup so that all may
benefit.

Dave Montcalm wrote in message <#bwn8m44AHA.1696@tkmsftngp03>...

Drew Paterson

unread,
May 24, 2001, 7:52:51 PM5/24/01
to
Also, in Word, check that Tables=>Hide Gridlines is checked.

Drew


"Beth Melton" <melt...@etrademail.com> wrote in message news:uKK$h844AHA.160@tkmsftngp03...

0 new messages