View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default 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!!