Dotted Linestyle is not seen in Print of the excel

P

PariDhillon

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!!
 
P

Per Jessen

Hi

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

Regards,
Per
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print Preview Dotted Lines 1
dotted lines around print area 2
PAGE BREAK PREVIEW 1
To remove dotted lines in Microsoft Excel ? 2
don't show the page breaks on the worksheet 2
Dotted lines in Excel 3
First page of Excel sheerepeats in print layout or print preview 1
Printing landscape and portrait 3

Top