Gridlines do not print, it is selected in sheet setup

[Susan]

I have a workbook with multiple worksheets. All sheets are set up to print
gridlines. I have one out of 5 worksheets, that when I print this worksheet
the gridlines do not print. All the other worksheets print the gridlines. I
have checked page setup>sheets, and, tools>options>view.

 

[Nick Hodge]

Susan

Gridlines will not print if you have changed the background colour of the
cells, you will have to set borders for these and they will print.

Any good?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

[email protected]
www.nickhodge.co.uk

 

[Susan]

Thanks Nick, I should have mentioned that there is no background color on any
of the sheets in this workbook. There are also no borders around the data.

Any more ideas?

 

[Gord Dibben]

Susan

Mayhaps you have "Draft Quality" checked?

Uncheck it, if so.


Gord Dibben MS Excel MVP