WD: Rows or Columns Missing from Pasted Microsoft Excel Sheet

Last reviewed: February 5, 1998
Article ID: Q113057
The information in this article applies to:
  • Microsoft Word for Windows, versions 6.0, 6.0a, 6.0c
  • Microsoft Word for Windows 95, versions 7.0, 7.0a
  • Microsoft Word 97 for Windows

SYMPTOMS

If you paste or paste link a large Microsoft Excel spreadsheet in a Word for Windows document, Word may not include all the columns or rows of the spreadsheet.

CAUSE

By design, when you paste or paste link the spreadsheet in a format other than rich text format (RTF), Word cuts off the columns and rows that exceed the margins of the current page.

In other words, if you paste or paste link the spreadsheet in any of the following formats, Word cuts off any columns and rows that exceed the right and bottom margins:

   Microsoft Excel 5.0 Worksheet Object
   Unformatted Text
   Picture
   Bitmap

WORKAROUND

If your Microsoft Excel spreadsheet exceeds the margins of your current page and you do not want Word to cut off any columns or rows, paste or paste link it in RTF file format. To do this:

  1. From the Edit menu, choose Paste Special.
2. In the As box, select Formatted Text (RTF). 3. Select the Paste or Paste Link option, and then choose OK.

NOTE: If the spreadsheet fits on the current page but not within the margins, you may be able to paste the entire spreadsheet as an object by decreasing the margin settings for that section. For example, if Word is cutting off only one column of your spreadsheet, change the left and right margins from 1 inch to .5 inch.

REFERENCES

"Microsoft Word User's Guide," version 6.0, pages 302-303


KBCategory:
KBSubCategory:
Additional query words: 6.00 6.00a excel officeinterop 6.00c word6
word7 7.00 word95 winword 8.00 word8 word97
Keywords : kbinterop
Version : 6.00 6.00a 6.00c 7.00 7.00a 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: February 5, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.