Blank Rows Deleted from MS Excel Section in BinderLast reviewed: March 12, 1997Article ID: Q164559 |
The information in this article applies to:
SYMPTOMSWhen you add a Microsoft Excel worksheet section to a Microsoft Office Binder file, blank rows at the beginning of the spreadsheet may be deleted.
CAUSEThis behavior occurs when the following conditions are true:
WORKAROUNDTo work around this problem, use one of the following methods.
Method 1Before 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:
Method 2Apply formatting to cell A1 of the Microsoft Excel worksheet before you add it as a section in a Microsoft Office Binder.
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. STATUSMicrosoft 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.
REFERENCESFor more information about freezing panes, click the Index tab in Microsoft Excel Help, type the following text panesand 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
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |