printing grid lines
 

can i print part of a work sheet with grid line and part without grids line

printing grid lines
 

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

--

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


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

printing grid lines
 

No.

You can have gridlines for a Sheet but a not part of your worksheet.
Different worksheet can show or hide gridlines ina Workbook.

Challa Prabhu

"jakjak5" wrote:

can i print part of a work sheet with grid line and part without grids line

printing grid lines
 

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

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