WD: Rows or Columns Missing from Pasted Microsoft Excel SheetLast reviewed: February 5, 1998Article ID: Q113057 |
The information in this article applies to:
SYMPTOMSIf 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.
CAUSEBy 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 WORKAROUNDIf 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:
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:
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |