The information in this article applies to:
SUMMARY
If you are using screen fonts rather than printer fonts, you may experience
incorrect printer output such as garbled print, truncated text, or missing
characters. These problems may also be caused by specific printer drivers
or incompatibility with a third-party font application.
MORE INFORMATIONGeneral TroubleshootingFirst, ensure that the incorrect font output is visible in print preview. In many cases, when you see the same incorrect output in print preview, there is some font problem.If your worksheet looks correct in print preview, this indicates that Microsoft Excel is sending the proper output to the printer and that the printing problem is occurring sometime after Microsoft Windows takes control of the print job. In this case, follow the steps for troubleshooting printing problems in the Microsoft Windows operating environment. If your worksheet does not look right in print preview, the problem may be caused by incorrect printer information. To work around this problem, try changing to another printer driver and then switching back to the driver that you want to use. If you are able to preview and print other worksheets with correct output, your worksheet may be damaged. Try copying your entire worksheet to a new worksheet and then retry printing:
NOTE: Many of the third-party applications created for the Microsoft Windows operating environment have an enable/disable switch. In addition, ensure that you are using the printer driver version appropriate for your version of Microsoft Windows. You can check this version number by choosing the Printers icon in the Microsoft Windows Control Panel:
Text Truncating or Values Converting to Pound Signs (#)If you are experiencing problems with text truncating at the end of a cell or with values converting to pound signs, your screen fonts are probably being mapped to a non-exact printer font that may have different metrics.The column widths in Microsoft Excel are based on the font you have selected for the Normal Style font. If this font is a screen font and there is no corresponding printer font, Microsoft Excel "maps" the screen font to the closest printer font. Because the printer font may be a slightly different size than the screen font, cell contents that appeared to fit in the cell as shown on your screen may not fit when mapped to a printer font. To correct this problem, set your Normal Style font to a printer font or a TrueType font (Microsoft Windows version 3.1 only):
Missing CharactersFollow the same troubleshooting steps mentioned in the previous section to change the Normal Style font (as well as any other fonts applied to the sheet) to printer or TrueType fonts (Microsoft Windows 3.1 only).If you are using a TrueType font and a non-PostScript printer such as a LaserJet or a dot-matrix printer, you can set your TrueType fonts to print as graphics. This will often resolve problems of missing characters. To do this, follow the first two steps for the version of Microsoft Excel that you are using and then follow steps 3 through 5 for both versions. If you are using Microsoft Excel version 3.0:
Garbled or Not Printed OutputIf you are using a third-party soft font application, and your printed document appears garbled or does not print out, you may need to disable the soft font application. Directions for disabling the soft font application appear in the "General" section of this article.Next, ensure that your Normal Style font is a printer font or a TrueType font (Microsoft Windows 3.1 only). If you have changed any of the fonts in your sheet to something other than the Normal Style font, ensure that the font in those cells is also a printer or a TrueType font. If your sheet is blank when you view it in print preview and when you print it, the worksheet may be damaged. Ensure that other sheets print correctly and copy your worksheet to a new worksheet as described in the "General" section of this article. Additional query words: tshoot
Keywords : kbprint |
Last Reviewed: April 1, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |