Microsoft KB Archive/73204

{|
 * width="100%"|

Hidden Columns or Rows from Excel Paste As Non-Hidden in Word

 * }

Q73204

-

The information in this article applies to:


 * Microsoft Word for Windows, versions 1.0, 1.1, 1.1a, 2.0, 2.0a, 2.0a-CD, 2.0b, 2.0c, 6.0, 6.0a, 6.0c
 * Microsoft Excel for Windows, versions 2.0, 2.01, 2.1, 2.10c, 2.10d, 3.0, 4.0

-

SYMPTOMS
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.

STATUS
This problem does not occur when using Excel 5.0 and Word 6.0a.

WORKAROUND
Use one of the following methods to paste the non-hidden columns and rows from an Excel spreadsheet into your Word document:


 * Individually copy the desired rows or columns from Excel and paste them in Word.
 * Paste the entire spreadsheet and then delete the unwanted columns or rows.

MORE INFORMATION
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.

Additional query words: 1.x 2.0 winword2 word6 winword one character wide 6.0

Keywords : kbinterop

Issue type :

Technology : kbWordSearch kbWordWSearch