Grid lines obscured by fill color

[Paul]

When I apply a fill color to a block of cells, the grid lines don't
show in that block of cells. I don't expect that there is a way to
force the grid lines to show, but I'm hoping that I'm wrong. Thanks
any workarounds, if they exist.

 

[T. Valko]

That's how it works.

You can format the cells borders to look like grid lines.

Format>Cells>Border tab

 

[Tom Hutchins]

One workaround...

Add cell borders to repalce the invisible gridlines. Select the block of
cells, right-click, and select Format Cells. On the Border tab of the Format
Cells dialog, select a line style. Click the Outline button, then the Inside
button, then OK.

Hope this helps,

Hutch

 

[Paul]

OK, thanks for that. I'll hold off on it for now, because the fill
colors are not permanent, and I have to rejig the borders after the
fill colors are removed.

 

[Paul]

Thanks for that, Hutch. I'll hold off for now because I'd have to
undo the cell borders when the (temporary) fill color is removed.

 

[patricia.a.knowles]

If you apply a fill color to cells on your worksheet, you won't be able to see or print the cell gridlines for those cells. If you want to see or print the gridlines for these cells, you must remove the fill color. To do so, select the cells, and then click arrow next to Fill Color Button image (Home tab, Font group). To remove the fill color, click No Fill. Keep in mind that you must remove the fill entirely. If you simply change the fill color to white, the gridlines will remain hidden. If you want to be able to retain the fill color, you can use borders instead of gridlines. For more information, see Apply or remove cell borders on a worksheet.

 

[tbrooker63]

If you apply a fill color to cells on your worksheet, you won't be able to see or print the cell gridlines for those cells. If you want to see or print the gridlines for these cells, you must remove the fill color. To do so, select the cells, and then click arrow next to Fill Color Button image (Home tab, Font group). To remove the fill color, click No Fill. Keep in mindthat you must remove the fill entirely. If you simply change the fill color to white, the gridlines will remain hidden. If you want to be able to retain the fill color, you can use borders instead of gridlines. For more information, see Apply or remove cell borders on a worksheet.

If you apply the border and choose the broken line just under "none", it looks perfect when you print! It has the shading and the gridlines.

 

[zisha.weinstock]

If you set the border color using the Custom Color dialog (Format->Border->Color->More Colors->Custom) to the RGB colors R:208 G:215 B:229 then it should give you the exact color as the default gridline color.