View Single Post
  #7   Report Post  
Old September 26th 13, 03:01 PM posted to microsoft.public.excel.misc
[email protected] is offline
external usenet poster
First recorded activity by ExcelBanter: Sep 2013
Posts: 1
Default Grid lines obscured by fill color

On Wednesday, September 11, 2013 4:35:05 PM UTC-4, wrote:
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.

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.