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

• 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.x, 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.