If you are using screen fonts rather than printer fonts, you may experienceincorrect printer output such as garbled print, truncated text, or missingcharacters. These problems may also be caused by specific printer driversor incompatibility with a third-party font application.
The following information describes troubleshooting steps that will, inmost cases, resolve font printing problems.
First, 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 thatMicrosoft Excel is sending the proper output to the printer and that theprinting problem is occurring sometime after Microsoft Windows takescontrol of the print job. In this case, follow the steps fortroubleshooting printing problems in the Microsoft Windows operatingenvironment.
If your worksheet does not look right in print preview, the problem may becaused by incorrect printer information. To work around this problem, trychanging to another printer driver and then switching back to the driverthat 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 newworksheet and then retry printing:
- Select the entire worksheet by pressing CTRL+SHIFT+SPACEBAR.
- From the Edit menu, choose Copy.
- From the File menu, choose New.
- From the Edit menu, choose Paste and try to print your document again.
Either before or after trying the specific solutions in the sections thatfollow, try disabling any third-party soft font applications.
NOTE: Many of the third-party applications created for the MicrosoftWindows operating environment have an enable/disable switch.
In addition, ensure that you are using the printer driver versionappropriate for your version of Microsoft Windows. You can check thisversion number by choosing the Printers icon in the Microsoft WindowsControl Panel:
- In Microsoft Windows 95, click the Start button, point to Settings, then click Printers. Click the desired printer with the right (secondary) mouse button. Choose the Details tab, and check your settings.
- In Microsoft Windows version 3.1, in the Printers dialog box, choose the Setup button and then choose the About button.
- In Microsoft Windows version 3.0, choose the Configure button. Next, choose the Setup button. In the Setup dialog box, choose About. The About dialog box displays your printer driver information.
Text Truncating or Values Converting to Pound Signs (#)
If you are experiencing problems with text truncating at the end of a cellor with values converting to pound signs, your screen fonts are probablybeing mapped to a non-exact printer font that may have different metrics.
The column widths in Microsoft Excel are based on the font you haveselected for the Normal Style font. If this font is a screen font and thereis no corresponding printer font, Microsoft Excel "maps" the screen font tothe closest printer font. Because the printer font may be a slightlydifferent size than the screen font, cell contents that appeared to fit inthe 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 aTrueType font (Microsoft Windows version 3.1 only):
- From the Format menu, choose Style.
- Verify that "Normal" is shown as your Style Name and choose the Define button.
- Clear all of the options in the Style Includes box (except Font) and choose the Font button at the bottom.
- Follow the step below that corresponds to your version of Microsoft Excel:
Microsoft Excel version 3.0
a. Select the Printer Fonts check box. This will display a list of fonts available on your printer as well as TrueType fonts (if you are using Microsoft Windows 3.1).
b. Choose one of the listed fonts and an appropriate font size.
Microsoft Excel version 4.0
a. Choose one of the fonts in the font list box that is preceded by a printer symbol or by a double T (Microsoft Windows 3.1 only)--a double T indicates a TrueType font.
b. Choose an appropriate font size.
Also, if you have changed the fonts in other cells to something other thanthe Normal Style font, change those fonts to a printer or TrueType font.
Follow the same troubleshooting steps mentioned in the previous section tochange the Normal Style font (as well as any other fonts applied to thesheet) to printer or TrueType fonts (Microsoft Windows 3.1 only).
If you are using a TrueType font and a non-PostScript printer such as aLaserJet or a dot-matrix printer, you can set your TrueType fonts to printas graphics. This will often resolve problems of missing characters. To dothis, follow the first two steps for the version of Microsoft Excel thatyou are using and then follow steps 3 through 5 for both versions.
If you are using Microsoft Excel version 3.0:
- From the File menu, choose Printer Setup.
- With your printer selected, choose the Setup button. Choose the OK button in the warning message.
If you are using Microsoft Excel version 4.0:
- From the File menu, choose Page Setup.
- Choose the Printer Setup button. Choose the Setup button.
Next, in both versions:
- In the Setup dialog box, choose the Options button.
- Select the Print TrueType Fonts As Graphics check box.
- Continue choosing the OK button until you have returned to your worksheet.
Garbled or Not Printed Output
If you are using a third-party soft font application, and your printeddocument appears garbled or does not print out, you may need to disable thesoft font application. Directions for disabling the soft font applicationappear in the "General" section of this article.
Next, ensure that your Normal Style font is a printer font or a TrueTypefont (Microsoft Windows 3.1 only). If you have changed any of the fonts inyour sheet to something other than the Normal Style font, ensure that thefont 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 printit, the worksheet may be damaged. Ensure that other sheets print correctlyand copy your worksheet to a new worksheet as described in the "General"section of this article.