Excel 2007 Won't print some borderlines

  • Thread starter Thread starter Noel S Pamfree
  • Start date Start date
N

Noel S Pamfree

I am attempting to print a spreadsheet of accounts on which I have used a
dotted line (Rt-click / Format Cells/ Borders / Line) so that the accountant
can easily follow the lines of income and expenditure.

They all show up fine on the Print Preview screen but when I print them out
none of the dotted lines appear. The ordinary borders print fine.

What am I doing wrong?

Thanks,

Noel
 
Sometime printer have trouble with narrow lines when they are in draft mode
Try setting the printer to better quality (you can do this with the
Properties button next to printer name on the Print dialog. Tell us the
result.
best wishes
 
Thank you for your suggestion.

I have checked and I am not set to 'draft' but to '600 dpi' which is the
highest my laser printer gives.

I also tried turning on the 'gridlines' but it doesn't seem to make any
difference.

The strange thing is that last year I was using Excel 2003 and I didn't have
any problems printing.

Cheers,

Noel
 
Later:

I have just tried sending the document to a deskjet printer and everything
prints OK.

I guess it must be something to do with the laser printer.

Thanks for your help.

Noel
 
Is it HP?

I have the same problem with a PC using XP and Office 2003. Printing from Excel or from a Word Table always misses a border in the same position on the page.

The preview look fine but the print doesnt.

Is it the printer (HP 4000n) or is it the software causing the printer to miss the border?

Roger
 
Even if you check the "fit to page" box, may be the border lines do not print. I think it is related to margins.
playing with margins (print preview-> Margins) may help. Reduce margins
I think it's a bug in Excel.
 
Sorry about this but I managed to fix it and forgot to post the solution.
The problem was caused by the printer driver. Apparently an update to Windows XP Professional had made a change to the driver. Once I connected to the HP website and did an automatic driver check, the HP software on my PC was updated. The problem was solved. No more missing borders.
 
Back
Top