Printing spreadsheet...no gridlines.

[juco]

I have a spreadsheet with 16 pages, 15 I can print showing gridlines.
One page I cannot get to print with gridlines, I have as far as I am aware ticked all the correct boxes including `page set up` but still wont show.
Any ideas on how to correct.

[GeoffW283]

Without being able to see the workbook in question, this is just a guess.

Gridlines can be enabled or disabled on a worksheet by worksheet basis.

Check the following setting for the worksheet in question under Options > Advanced:

(be sure to select the problem worksheet)

gridlines.png

[juco]

I have that checked.
Attached is the spreadsheet, the issue is in the tab `All`

[FlameRetired]

Under Print > Page Setup > Sheet I unchecked 'Draft quality' and the grid lines show up in Print Preview.

Does that work at your end?

[juco]

Yes that has fixed it thank you very much.

[FlameRetired]

You are welcome. Glad to help.

Thank you for the feedback, rep and marking your thread Solved.