Grid lines obscured by fill color

P

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

T. Valko

That's how it works.

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

Format>Cells>Border tab
 
T

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
 
P

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

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

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

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

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.
 

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

Similar Threads


Top