paste as EXCEL Worksheet Object

[LCC]

Hi! Everyone

When part of the EXCEL worksheet is pasted in WORDS as
EXCEL Worksheet Object (under Paste Special), how could we
hide the gridlines in the pasted Excel Worksheet Object
during printing?

Thanks.

LCC

 

[CyberTaz]

Hi LCC-

If it is an Excel Object, double-click it to open the object in an Excel
Window, then go to Excel's File>Page Setup>Sheet and remove the check for
Gridlines.

HTH |:>)

Hi! Everyone

When part of the EXCEL worksheet is pasted in WORDS as
EXCEL Worksheet Object (under Paste Special), how could we
hide the gridlines in the pasted Excel Worksheet Object
during printing?

Thanks.

LCC

-- (e-mail address removed)

 

[LCC]

Thanks for your reply.

Regret to inform you that in my original EXCEL, the
Gridlines option is NEVER checked.

After pasted as object in WORDS, the print preview always
shows the gridlines.

LCC

 

[Robert M. Franz]

Hello lcc

Regret to inform you that in my original EXCEL, the
Gridlines option is NEVER checked.

After pasted as object in WORDS, the print preview always
shows the gridlines.

If you don't find a better solution: Set the Excel cells to have borders
on all sides and format those as _white_.

HTH
Robert

 

[LCC]

Hi! Robert

Thanks for your suggestions.

In fact, the other way to overcome this is to paste as a
picture. But I am reluctant because this makes my file
size very big (I suppose so), as I have more than 200
EXCEL objects in the same WORDS document!!

LCC