Sheet grid lines

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

The Dog Breeders List - 22 Apr 2008 19:20 GMT

I can see the gridlines in the worksheet, and I have Show and Print
gridlines checked, but a print preview or print do not produce the
gridlines.
What am I missing?
Bob

Reply to this Message

Bernard Liengme - 22 Apr 2008 21:16 GMT

Using XL 2007? Sounds like a printer problem.
Have you tried
1) Office | Excel Options -> change gridline colour
2) Using borders rather than gridlines
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

>I can see the gridlines in the worksheet, and I have Show and Print
>gridlines checked, but a print preview or print do not produce the
>gridlines.
> What am I missing?
> Bob

Reply to this Message

Gord Dibben - 22 Apr 2008 22:24 GMT

In Excel 2003 and earlier, If print setup>sheet is set to "Draft Quality" the
gridlines won't show or print.

Maybe 2007 is the same?

Gord Dibben MS Excel MVP

>I can see the gridlines in the worksheet, and I have Show and Print
>gridlines checked, but a print preview or print do not produce the
>gridlines.
>What am I missing?
>Bob

Reply to this Message

Bernard Liengme - 23 Apr 2008 00:33 GMT

I tried Draft on two printers from XL2007 and the gridlines are there (very
light)
They show in Print Preview
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

> In Excel 2003 and earlier, If print setup>sheet is set to "Draft Quality"
> the
[quoted text clipped - 9 lines]
>>What am I missing?
>>Bob

Reply to this Message

Gord Dibben - 23 Apr 2008 04:15 GMT

Thanks Bernard.

Gord

>I tried Draft on two printers from XL2007 and the gridlines are there (very
>light)
>They show in Print Preview
>best wishes

Reply to this Message