Microsoft KB Archive/87950

{| = FastTips for Excel 3.0 for Windows: Printing Q&A =
 * width="100%"|

Last reviewed: October 7, 1997

Article ID: Q87950 3.00 WINDOWS kbprint The information in this article applies to:


 * Microsoft Excel for Windows, version 3.0

SUMMARY
Microsoft Product Support Services Application Note (Text File) WE0567: PRINTING QUESTIONS AND ANSWERS Revision Date: 8/92 No Disk Included The following information applies to Microsoft Excel for Windows version 3.0.
 * INFORMATION PROVIDED IN THIS DOCUMENT AND ANY SOFTWARE THAT MAY   |
 * ACCOMPANY THIS DOCUMENT (collectively referred to as an           |
 * Application Note) IS PROVIDED &quot;AS IS&quot; WITHOUT WARRANTY OF ANY     |
 * KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO   |
 * THE IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A    |
 * PARTICULAR PURPOSE. The user assumes the entire risk as to the    |
 * accuracy and the use of this Application Note. This Application   |
 * Note may be copied and distributed subject to the following       |
 * conditions: 1) All text must be copied without modification and   |
 * all pages must be included; 2) If software is included, all files |
 * on the disk(s) must be copied without modification [the MS-DOS(R) |
 * utility DISKCOPY is appropriate for this purpose]; 3) All         |
 * components of this Application Note must be distributed together; |
 * and 4) This Application Note may not be distributed for profit.   |
 * Copyright 1992 Microsoft Corporation. All Rights Reserved.        |
 * Microsoft and MS-DOS are registered trademarks and Windows        |
 * is a trademark of Microsoft Corporation.                          |
 * Epson is a registered trademark of Epson America, Inc.            |
 * Hewlett-Packard, HP, DeskJet, and LaserJet are registered         |
 * trademarks of Hewlett-Packard Company.                            |
 * PostScript is a registered trademark of Adobe Systems, Inc.       |
 * PostScript is a registered trademark of Adobe Systems, Inc.       |

1. Q. I am using Microsoft Windows version 3.0 and every time I print a Microsoft Excel version 3.0 for Windows worksheet to my     Hewlett-Packard(R) (HP[R]) LaserJet(R) Series III or HP      DeskJet(R), the row and column headings print, but the cell contents do not.

A. If you are receiving either incomplete print jobs or fonts that are different when printed than when they are previewed and you are using an HP LaserJet Series III or an HP DeskJet, the following three-step procedure may correct the problem:

Step 1. Quit Microsoft Excel version 3.0 for Windows. Start Control Panel by choosing the Control Panel icon in the Program Manager.

Step 2. In Control Panel, choose the Printers icon. Select your printer from the Printers list. Choose the Configure button, then choose the Setup button. In the Graphics Resolution box, select 75 dots per inch. Choose the OK button three times to     return to Control Panel.

Step 3. In Control Panel, choose the Printers icon again. Select your printer from the Printers list. Choose the Configure button, then choose the Setup button. In the Graphics Resolution box, select 300 dots per inch. Choose the OK button three times to return to Control Panel. From the Settings menu, choose Exit. Restart Microsoft Excel 3.0.

The previous procedure makes the necessary changes to your WIN.INI file to print correctly from Microsoft Excel 3.0.

2. Q. I want to change my paper size from letter to legal. Page 531 of     the &quot;Microsoft Excel User's Guide&quot; for version 3.0 instructs me      to choose Page Setup from the File menu and select the options I      want. When I do so, several of the options are unavailable for selection. How can I correct this problem?

A. If certain document settings in the Page Setup dialog box, such as Paper Orientation or Fit To Page, are unavailable (dimmed), then the printer driver for your printer does not support those particular extended options. The HP LaserJet Series III and the Epson(R) drivers are among those that do not support extended settings.

If you are using an HP LaserJet Series III and cannot select Paper Size or Paper Orientation, you can receive a maintenance release from Microsoft for Excel 3.0 for Windows that corrects this problem.

NOTE: The Reduction/Enlargement and Fit To Page options are available only with PostScript(R) printers.

To receive this maintenance release for Microsoft Excel 3.0, please call Microsoft Excel for Windows technical support at     (425) 635-7070.

3. Q. I am using an HP LaserJet Series III printer and am trying to     print in landscape orientation using legal-size paper. When I     try to print, Microsoft Excel version 3.0 for Windows generates only a partial printout, as if I were still printing on letter- size paper. What is causing this problem?

A. Documents printed from Microsoft Excel version 3.0 for Windows to the HP LaserJet III may print in the incorrect orientation and/or on the incorrect paper size. This problem occurs inconsistently and appears both in print preview and on     printouts.

Microsoft has confirmed this to be a problem in the HP LaserJet printer driver for Microsoft Excel 3.0. This problem was corrected in a maintenance release of Microsoft Excel 3.0 and in     the HP LaserJet Series III driver version 3.86.

If you are using an HP LaserJet Series III and cannot print in     landscape orientation on legal-size paper, you can receive the maintenance release of Microsoft Excel 3.0 and the HP LaserJet Series III driver from Microsoft. To receive these items, please call Microsoft Excel for Windows technical support at (425) 635- 7070.

4. Q. When I try to change printer settings, Microsoft Excel version 3.0 for Windows tells me that it can't open the printer driver. Is the printer driver damaged?

A. This message appears if your printer is switched from active to     inactive in Control Panel. The following three-step procedure corrects this problem:

Step 1. Quit Microsoft Excel version 3.0 for Windows and start Control Panel by choosing the Control Panel icon in Program Manager.

Step 2. In Control Panel, choose the Printers icon. Select your printer from the Printers list, change the status of your printer from inactive to active by choosing the Active button and then choosing the OK button.

Step 3. From the Settings menu, choose Exit. Restart Microsoft Excel 3.0.

If the previous procedure does not correct this problem, your printer driver may be corrupt and need to be reinstalled. For help reinstalling your printer driver, please refer to page 161 of the &quot;Microsoft Window's User's Guide&quot; for version 3.0.

5. Q. When I try to print a Microsoft Excel version 3.0 for Windows worksheet, my print titles print twice on the first page of the print job. How can I correct this problem?

A. You have set print titles without defining a print area. To     correct this problem, select the data you want to print, excluding the rows or columns you have designated as print titles. From the Options menu, choose Set Print Area.

For more information regarding print titles, please refer to     pages 533-534 of the &quot;Microsoft Excel User's Guide&quot; for version 3.0.
 * }