Gridlines display in Print preview but do not print

[Chris]

Excel 2010, Windows 7
Gridlines show up on Print Preview but do not appear on the actual print.
The "Gridlines" box is checked.
Specifically selected cell borders work correctly - they show in Preview and
on Print.
If the print is sent to a pdf printer - e.g. Cutepdf, the generated file
contains the gridlines and they print correctly.
Searching reveals references to similar problems but I haven't been able to
find a solution - only detours.
Any suggestions ?

Chris

 

[Spencer101]

Excel 2010, Windows 7
Gridlines show up on Print Preview but do not appear on the actua
print.
The "Gridlines" box is checked.
Specifically selected cell borders work correctly - they show in Previe
and
on Print.
If the print is sent to a pdf printer - e.g. Cutepdf, the generate
file
contains the gridlines and they print correctly.
Searching reveals references to similar problems but I haven't bee
able to
find a solution - only detours.
Any suggestions ?

Chris

The grid line tick box is only to select whether or not the grid i
visible on screen. If you want the grid to show when printing you wil
have to add cell borders

 

[Chris]

The grid line tick box is only to select whether or not the grid is
visible on screen. If you want the grid to show when printing you will
have to add cell borders.

Surely not - and if that were the case why do they show in the pdf ?

 

[Spencer101]

message


Surely not - and if that were the case why do they show in the pdf ?

Try it. Take the tick out of the box and see if the gridlines stil
show. The cell borders (if you've applied any) will, but the gre
gridlines will not.

As for why they show up in the pdf.... Another of those little Microsof
mysteries perhaps? ;

 

[Chris]

Try it. Take the tick out of the box and see if the gridlines still
show. The cell borders (if you've applied any) will, but the grey
gridlines will not.

As for why they show up in the pdf.... Another of those little Microsoft
mysteries perhaps?

I'm not the only one experiencing this - see
http://tinyurl.com/9za3p2z