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.
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.
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
I have that checked.
Attached is the spreadsheet, the issue is in the tab `All`
Under Print > Page Setup > Sheet I unchecked 'Draft quality' and the grid lines show up in Print Preview.
Does that work at your end?
Dave
Yes that has fixed it thank you very much.
You are welcome. Glad to help.
Thank you for the feedback, rep and marking your thread Solved.![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks