Embedded Excel Worksheets

[Lynn Nickerson]

After embedding an Excel worksheet in a Word document and
turning off the gridlines in page setup in Excel, they
contintue to print.

 

[Suzanne S. Barnhill]

I believe you need to turn off the gridlines in Excel before copying the
worksheet.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://www.mvps.org/word
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Beth Melton]

Additionally, if you are going by Print Preview in Word then an
embedded Excel worksheet is a little misleading. You are still seeing
a screen view of the Excel Object.

I have found that the Print Options saved in the Excel workbook/sheet
do not take effect until it is actually printed.

Try printing a sample document with the gridlines displayed in Word
and you'll see what I am talking about.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~
Beth Melton

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[Lynn N.]

I am actually creating the worksheet through Word, not in
Excel . . . should I not be working this way? I do
complex financial statements with formulas and put the
gridlines in when creating the next year's statement, so
the auditors have lines to write in, then after they
edit, I delete the gridlines to print a clean page.
Sometimes they don't print, and sometimes they do. Can't
figure it out. I never know what's going to print.

 

[Beth Melton]

Hi Lynn,

It doesn't matter which way you do it but if you don't want the
gridlines to appear on screen then edit the embedded Excel worksheet,
go to Tools/Options/View and turn off Gridlines.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~
Beth Melton

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/