We are using Excel 2002 version 10.6501.6626 on Windows 2000 and XP. We
have a spreadsheet where the longest vertical cell in each row when printing
(and using print preview) has the bottom cut off by the line separarating
the cells on some PC's. The problem has nothing to do with operating system
(we use both XP and 2000 and have seen the problem on both), print drivers
or user settings. Spreadsheet prints or does not print correctly on a
particular pc regardless of user logged in. Excel build is same on working
and non-working pc's.
I have seen two workarounds mentioned on forum:
1.Go to the cell in each row that has the most number of lines.
Go to the end of the text in that cell.
Press Alt-Enter.
This will add one line's worth of white space, which should fix those who
are having text cut off and will still look acceptable to someone whose
printout was correct to start with.
2. The spreadsheet is in Times New Roman 8 point. The Normal (standard) font
seems to have been Arial 10 point at time it was created. To fix the
problem:
Change Normal Font to Times New Roman 8 point:
Make new spreadsheet Copy all of old spreadsheet Paste into new spreadsheet
Adjust settings to landscape, margins, etc.
I would like to fix the problem instead of using one of the above
workarounds. Can anyone explain why some of our PC's can print OK without
the workarounds and what we might do to fix it?
TIA,
Allison Orange
Systems Project Consultant
Florida Public Service Commission
|
Similar Threads
