OFF: All Sheets Print From Excel Section in Binder

ID: Q135656

The information in this article applies to:
  • Microsoft Office for Windows 95, version 7.0
  • Microsoft Excel for Windows 95, version 7.0
  • Microsoft Office 97 for Windows
  • Microsoft Excel 97 for Windows

SYMPTOMS

When you print a Microsoft Excel section in Binder 7.0 or in Binder 97, all sheets in the section that contain data (worksheets, chart sheets, macro sheets, dialog sheets, and modules) are printed. Dialog sheets are always printed regardless of whether they have been changed.


WORKAROUND

To work around this behavior, print the Microsoft Excel section separately from the other sections in the binder file. To do this, follow these steps:

  1. Activate the Microsoft Excel section by clicking the Microsoft Excel icon in the left pane.


  2. To select the sheets that you want to print, hold down the CTRL key and select the sheets.


  3. In Microsoft Binder 97, click Print on the Section menu, and then click Active Sheet(s) in the Print dialog box. Click OK.

    In Microsoft Binder 7.0, click Print on the Section menu, and then click Selected Sheet(s) in the Print dialog box. Click OK.


  4. In the left pane of the binder, click one of the other sections.


  5. Hold down the CTRL key and click on the other sections that you want to print. On the File menu, click Print Binder and click Selected Sections in the Print dialog box.


  6. Click OK to print the selected sections.


NOTE: When you use this workaround, the page numbers may not be printed continuously.

Printing Continuous Page Numbers

To print continuous page numbers starting after one or more Microsoft Excel sections, follow these steps:

  1. Hold down the CTRL key and click the other sections that you want to print. In Microsoft Binder 97, click Print Binder on the File menu and click "Section(s) Selected in Left Pane" in the Print dialog box. In Microsoft Binder 7.0, click Print Binder on the File menu and click Selected Sections in the Print dialog box.


  2. In the Numbering Section of the Print Binder dialog box, click Consecutive.


  3. Change the Start Numbering At box to be one greater than the last page number from the Microsoft Excel section.

    For example, if three pages were printed from the Microsoft Excel section, change the Start Numbering At box to 4.


  4. Click OK.


For additional information, please see the following articles in the Microsoft Knowledge Base:
Q163679 OFF97: Page Numbering Problem in Excel Binder Section

Q130042 OFF: Problems with Page Numbering When Printing from Binder


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.


MORE INFORMATION

In Microsoft Office 97, this problem does not appear in print preview. The program for each section controls print preview. Therefore, when you preview a Microsoft Excel section, only the active sheet or print area is displayed.

Additional query words: XL7 OFF7 XL97 OFF97 97

Keywords : offbinder XL7
Version : 7.0
Platform : WINDOWS
Issue type :


Last Reviewed: June 11, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.