Trying to print gridlines for all columns in a worksheet

[Glenn_Suggs]

Hello everyone... I'm trying to print all gridlines on a worksheet to get separation between them but they don't all show up. I've even tried putting data in the columns that were blank but that didn't help. I've tried turning on Page Layout - Sheet options - Print gridlines (of course) but that doesn't do it either. I'm getting vertical lines between columns 2 and 3, 6 and 7, 10 and 11, 12 and 13, 16 and 17, and 21 and 22. There are 23 columns in all. A bit erratic, don't you think? Any ideas?

Thanks in advance,
Glenn

 

[jmacleary]

Is it possible you have white borders set on the columns that don't show? Any coloured border will overrule the gridlines option.

 

[Fluff]

Also if you have a background fill colour, that will overrule the gridlines