Excel Printing Problems

[maberley]

Hi

Does anyone else get printing problems in Excel on a Mac.

I have a spreadsheet which prints fine in Windows - but on a Mac the
values sometimes go slightly over cell boundaries, or sometimes
virtually completely over on the edges of sheets.

Is this an Excel, OSX or printer driver problem?

Even in preview (before printing) the problems are visible.

Thanks

Are there any better Mac Excel groups?

 

[JE McGimpsey]

Does anyone else get printing problems in Excel on a Mac.

I have a spreadsheet which prints fine in Windows - but on a Mac the
values sometimes go slightly over cell boundaries, or sometimes
virtually completely over on the edges of sheets.

Is this an Excel, OSX or printer driver problem?

Even in preview (before printing) the problems are visible.

It's likely a problem between XL and your print driver, along with any
font substitution going on.

First, make sure your print driver is updated for your printer. XL reads
from the print driver when printing/previewing.

Second, make sure you're using a MS provided font as your Standard font
(in Preferences/General), since that's what XL uses to calculate cell
widths.

Third, in the File/Page Setup dialog, change the Print Quality in the
Page pane to High (or try another setting if you have others).

Are there any better Mac Excel groups?

No.

 

[maberley]

You're a genius (well a justified MVPS anyway!)

It was a document I initially created in Windows.

I changed the font as you suggested from Verdana to Arial - the
problem remained.

It was when I changed the print quality to high that the problem
disappeared - to check I set the print qulity back to normal and the
problem reappeared.

The printer is an HP PSC1215

I am shocked that this makes a difference - I've worked as an IT
consultant for 20 years - I thought that print quality was purely to
do with ink and dots

Thanks very much once again for your expert and kind help.

 

[Bob Greenblatt]

FYI, ever since I have been working with Excel (since it was multi-plan on
512K Macs, and distributed on 1 floppy disk) there have been all kind of
problems with HP printers. So, I'm not shocked at all. The ONLY fool proof
way to reliably print identically between windows and Mac platforms is to
use post script.

 

[JEG]

It's likely a problem between XL and your print driver, along with any
font substitution going on.

First, make sure your print driver is updated for your printer. XL reads
from the print driver when printing/previewing.

Second, make sure you're using a MS provided font as your Standard font
(in Preferences/General), since that's what XL uses to calculate cell
widths.

Third, in the File/Page Setup dialog, change the Print Quality in the
Page pane to High (or try another setting if you have others).


No.

Thank you, thank you! I would never have imagined the Print Quality
setting would solve this ridiculous problem. I've been on Macs since
the first 128K, and only encountered this problem since I've been
working on other platforms at other locations. Mysterious but perfect
solution!