Blank Rows Deleted from MS Excel Section in Binder

 Last reviewed: March 12, 1997
Article ID: Q164559
The information in this article applies to:
  • Microsoft Office 97 for Windows
  • Microsoft Excel 97 for Windows

SYMPTOMS

When you add a Microsoft Excel worksheet section to a Microsoft Office Binder file, blank rows at the beginning of the spreadsheet may be deleted.

CAUSE

This behavior occurs when the following conditions are true:

  • The worksheet contains one or more blank rows at the top.

    -and-

  • You freeze a pane in the Microsoft Excel worksheet.
scrollable, so if its rwFirst or colFirst is not 0 those rows

WORKAROUND

To work around this problem, use one of the following methods.

Method 1

Before you add the worksheet as a section in a Microsoft Office Binder, delete any blank rows at the beginning of worksheet. To do this, use the following steps:

  1. In Microsoft Excel, click the row numbers of the blank rows that you want to delete.2. On the Edit menu, click Delete.3. On the File menu,
click Save.4. On the File menu, click Close.5. Start Microsoft Office Binder.6. On the Section menu, click Add From File to add the file.

Method 2

Apply formatting to cell A1 of the Microsoft Excel worksheet before you add it as a section in a Microsoft Office Binder.

  1. Click cell A1.
2. On the Format menu, click Cells.3. Click the Patterns tab. Click the color that matches the cell 
   background color, and then click OK.4. On the File menu, click Save.5.
On the File menu, click Close.6. Start Microsoft Office Binder.7. On the Section menu, click Add From File to add the file.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft productslisted at the beginning of this article. We are researching this problemand will post new information here in the Microsoft Knowledge Base as itbecomes available.

REFERENCES

For more information about freezing panes, click the Index tab in Microsoft Excel Help, type the following text 

   panes
and then double-click the selected text to go to the "View different partsof a worksheet at the same time" topic.

Additional query words: 97 7.00 OFF97
Keywords : kbtool offbinder
Version : 97
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 12, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.