View Single Post
  #19   Report Post  
Posted to microsoft.public.excel.misc
[email protected] onysko2286@gmail.com is offline
external usenet poster
 
Posts: 1
Default Grid lines obscured by fill color

On Tuesday, April 1, 2008 at 4:03:51 PM UTC-6, Paul wrote:
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.


I insert a text box sized perfectly over the cells not filled with color, then color the interior of the textbox, and set the transparency of the text box way high, so the gray gridlines underneath can show through. You have to go to Page Layout, Gridlines, and check the checkbox for Print, as you do even if you're printing uncolored cells.