Gridline Printing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lindsay Williams - 30 Oct 2003 10:05 GMT

I have inserted an Excel worksheet into a Word doc and, to start with, the
doc printed with gridlines in the spreadsheet area. But now it doesn't! The
print preview shows the gridlines but they don't print. The std way of going
for the Page Setup to select print gridlines doesn't work because the page
setup pertains to a Word doc not the embedded spreadsheet.

Does anyone know how I can get the gridlines printing again? I have tried
all sorts of things to no avail.

TIA.

Reply to this Message

Paul Cundle - 30 Oct 2003 16:08 GMT

Is your printing operating at a high enough resolution? I believe that if
you try to print at a low resolution (e.g. draft mode) then it sometimes
sacrifices the gridlines. If the document is very complicated could it be
that the printer doesn't have the memory to cope with such a large document?

Paul C,

Signature

> I have inserted an Excel worksheet into a Word doc and, to start
> with, the doc printed with gridlines in the spreadsheet area. But now
[quoted text clipped - 7 lines]
>
> TIA.

Reply to this Message

Lindsay Williams - 31 Oct 2003 00:50 GMT

Thanks for the reply, Paul. No, it is not a printer problem. I am slowly
getting to the nub of it now. The inserted sheet is using the std template
which, by default, does not have the "print gridlines" ticked in the page
setup. However, if you rt click the sheet grid you get to be able to open it
with Excel and from there you can access the page setup to tick the gridline
print box. So, there appears to be two ways of doing what I want. Use a
default sheet template with the grid print ticked or "open" it as described
above and modify it.

Cheers.

> Is your printing operating at a high enough resolution? I believe that if
> you try to print at a low resolution (e.g. draft mode) then it sometimes
[quoted text clipped - 13 lines]
> >
> > TIA.

Reply to this Message

NC - 06 Nov 2003 12:41 GMT

Have you tried clicking on the embedded object so that
the dark border appears ... then right click and
select "Linked Worksheet Objects" then "Links" and you
have a number of options there to open the source (e.g.
the excel document) and to change the update options
etc ) anyway, it will allow you all of the usual excel
options so you can get in and make sure that the
gridlines are switched on.

Hope this helps!

>-----Original Message-----
>I have inserted an Excel worksheet into a Word doc and, to start with, the
[quoted text clipped - 9 lines]
>
>.

Reply to this Message

Lindsay Williams - 08 Nov 2003 03:19 GMT

Thanks for reply. That is effectively what I found to solve the problem.

Cheers.

> Have you tried clicking on the embedded object so that
> the dark border appears ... then right click and
[quoted text clipped - 26 lines]
> >
> >.

Reply to this Message

Rate this thread: