ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Cell borders print default rather than custom setting. (https://www.excelbanter.com/excel-programming/325141-cell-borders-print-default-rather-than-custom-setting.html)

Phil Hageman[_4_]

Cell borders print default rather than custom setting.
 
I have formatted cell borders blue/light weight, which is how they show on
screen. However they print black/standard weight (default). When I go back
to formatting I see the border style set at the default color/weight. Can
someone tell me what is going on here?

Thanks,
Phil

Andibevan[_2_]

Cell borders print default rather than custom setting.
 
Have you checked that either the printer settings or that the document
settings within Excel are not set to Black and White?

Andy


"Phil Hageman" wrote in message
...
I have formatted cell borders blue/light weight, which is how they show on
screen. However they print black/standard weight (default). When I go

back
to formatting I see the border style set at the default color/weight. Can
someone tell me what is going on here?

Thanks,
Phil




Peter T

Cell borders print default rather than custom setting.
 
Hi Phil,

Even if you have everything setup to print in colour, I think this is a
feature!
I have never found any way to print very thin borders in colour - always
black, at least in my system.
Increase the borders weight though and they will print in colour.

FWIW, things I've tried in the past to no avail -
Change default colour of gridlines in Tools / Options / View / Color
Change various system colours, in particular Windows Text which defines the
automatic colour for borders, (normal gridlines still appear grey)

Regards,
Peter T.


"Phil Hageman" wrote in message
...
I have formatted cell borders blue/light weight, which is how they show on
screen. However they print black/standard weight (default). When I go

back
to formatting I see the border style set at the default color/weight. Can
someone tell me what is going on here?

Thanks,
Phil




Phil Hageman[_4_]

Cell borders print default rather than custom setting.
 
Andibevan and Pete, Thanks for your replies. The answer was to go up to the
next width border and it printed in color - and looked as good as the thin
line too. Problem resolved. You guys have a nice weekend. Regards, Phil

"Peter T" wrote:

Hi Phil,

Even if you have everything setup to print in colour, I think this is a
feature!
I have never found any way to print very thin borders in colour - always
black, at least in my system.
Increase the borders weight though and they will print in colour.

FWIW, things I've tried in the past to no avail -
Change default colour of gridlines in Tools / Options / View / Color
Change various system colours, in particular Windows Text which defines the
automatic colour for borders, (normal gridlines still appear grey)

Regards,
Peter T.


"Phil Hageman" wrote in message
...
I have formatted cell borders blue/light weight, which is how they show on
screen. However they print black/standard weight (default). When I go

back
to formatting I see the border style set at the default color/weight. Can
someone tell me what is going on here?

Thanks,
Phil






All times are GMT +1. The time now is 09:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com