Article ID: 97911 - View products that this article applies to.
This article was previously published under Q97911
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.
The following information describes troubleshooting steps that will, in most cases, resolve font printing problems.
General 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.
Article ID: 97911 - Last Review: August 15, 2005 - Revision: 1.3
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.