ID: Q73204
The information in this article applies to:
If you paste or paste link a spreadsheet that contains a hidden column from Microsoft Excel into Word for Windows, the column will appear as an empty, one-character-wide column in the Word for Windows table. If the hidden column had a border in Excel, that border will display and print in Word.
On the other hand, if you paste or paste link a spreadsheet that contains a hidden row from Excel into Word, the row and its contents display fully.
This means that you cannot display an Excel spreadsheet in Word exactly as it appears in Excel when the spreadsheet contains hidden rows or columns.
This problem does not occur when using Excel 5.0 and Word 6.0a.
Use one of the following methods to paste the non-hidden columns and rows from an Excel spreadsheet into your Word document:
In Excel, you can format a spreadsheet column as hidden by selecting the column and choosing Column Width from the Format menu and selecting Hide. The only way you can adjust these empty columns in Word version 2.0 is by pressing SHIFT or CTRL while you drag the table column markers on the ruler. In Word version 1.x, select the column by clicking the right mouse button in the column before you adjust the column width. You must make the column visible in Excel before pasting it into Word for Windows if you want to copy the contents of the column.
To format a row as hidden in Excel, choose Row Height from the Format menu.
KBCategory: KBSubcategory: Additional query words: 1.x 2.0 2.0a winword2 word6 winword 2.0a-CD 2.0b 2.0c one character wide 6.0 6.0a 6.0c
Keywords : kbinterop
Version : 1.x 2.x 6.0
Platform : WINDOWSLast Reviewed: February 5, 1998