| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
printing grid lines
can i print part of a work sheet with grid line and part without grids line
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| grid lines printing with blank cells | Excel Discussion (Misc queries) | |||
| Show grid lines when printing? | New Users to Excel | |||
| Printing Grid lines & Shaded cells | Excel Discussion (Misc queries) | |||
| printing grid lines when grid lines is checked | Setting up and Configuration of Excel | |||
| printing grid lines | Excel Discussion (Misc queries) | |||
Linear Mode
