ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Dotted Linestyle is not seen in Print of the excel (https://www.excelbanter.com/excel-discussion-misc-queries/185084-dotted-linestyle-not-seen-print-excel.html)

PariDhillon

Dotted Linestyle is not seen in Print of the excel
 
Hi,

I am setting the default gridlines of excel worksheet to
"Dotted" (dotted linestyle) programmatically. Everything works fine
but when i do a print preview or take a print of the same worksheet, i
see some of the vertical dotted lines missing.

It seems to be an excel issue to me but i am not sure. Is there any
workaround?

One solution that i came across was to Scale my page to 100% of the
normal size(Setting in page tab of Page Setup). But it is not a very
user-friendly output. Can someone help me out on this issue?

Thanks in advance!!

Per Jessen

Dotted Linestyle is not seen in Print of the excel
 
Hi

To print gridlines goto File Page Setup Sheet In the Print section,
check Gridlines Ok

Regards,
Per

"PariDhillon" skrev i meddelelsen
...
Hi,

I am setting the default gridlines of excel worksheet to
"Dotted" (dotted linestyle) programmatically. Everything works fine
but when i do a print preview or take a print of the same worksheet, i
see some of the vertical dotted lines missing.

It seems to be an excel issue to me but i am not sure. Is there any
workaround?

One solution that i came across was to Scale my page to 100% of the
normal size(Setting in page tab of Page Setup). But it is not a very
user-friendly output. Can someone help me out on this issue?

Thanks in advance!!




All times are GMT +1. The time now is 10:45 PM.

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