Gridlines do not print, it is selected in sheet setup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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

(e-mail address removed)
www.nickhodge.co.uk
 
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?
 
Susan

Mayhaps you have "Draft Quality" checked?

Uncheck it, if so.


Gord Dibben MS Excel MVP
 
Back
Top