View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default printing grid lines

I agree with David


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"David McRitchie" wrote in message ...
Since a fill color will wipe out the grid lines and you would
have to repair the border around the entire area with
suppressed gridlines, you would probably be better off
suppressing the grid lines altogether and
using actual borders. The main problem with borders is that
remain in place not with the data when you sort.

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"Ron de Bruin" wrote in message
...
Hi jakjak5

One ways is to make the cell background (Fill Color) White of the part of
the sheet
that you not want to print with gridlines

"jakjak5" <jakjak5 wrote...
can i print part of a work sheet with grid line and part without grids
line