Gridlines do not print, it is selected in sheet setup

S

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

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

(e-mail address removed)
www.nickhodge.co.uk
 
S

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?
 
G

Gord Dibben

Susan

Mayhaps you have "Draft Quality" checked?

Uncheck it, if so.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top