Pasting Excel Outline Pastes Entire Spreadsheet in Word

ID: Q113051

1.00 1.10 1.10a 2.00 2.00a 2.00a-CD 2.00b 2.00c 6.00 6.00a WINDOWS

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
• Microsoft Excel for Windows, versions 3.0, 4.0

SYMPTOMS

If you copy the outline portion of a Microsoft Excel 3.0 or 4.0 spreadsheet (formatted using the Select Special command on the Formula menu) and paste it in a Word for Windows document, the entire Microsoft Excel spreadsheet appears in Word.

This does not happen if you paste the outline portion of a Microsoft Excel version 5.0 spreadsheet in your Word document.

CAUSE

The Select Special command on the Formula menu is specific to Microsoft Excel. Word does not support the formatting you apply in Microsoft Excel using the Select Special command. As a result, Word pastes the entire spreadsheet in your document.

WORKAROUND

Paste the outline portion of your Microsoft Excel spreadsheet into a new spreadsheet. Format that version of the spreadsheet as you want it to appear in Word, then copy it and paste it in your Word document. The following procedure describes this process in detail:

1. In Microsoft Excel, display the outline level you want to paste in Word.

2. From the Formula menu, choose Select Special.

3. Select the Visible Cells Only option and then choose OK.

4. Select the spreadsheet and then, from the Edit menu, choose Copy.

5. Create a new Microsoft Excel spreadsheet.

6. From the Edit menu, choose Paste.

7. Select the new spreadsheet. From the Edit menu, choose Copy.

8. Switch to Word and paste the spreadsheet in your document.

KBCategory: KBSubCategory: Additional reference words: 1.00 1.10 1.10a 2.00 2.00a 2.00a-CD 2.00b winword 2.00c 6.00 6.00a excel officeinterop whole complete entire more

Keywords          : kbinterop
Version           : 1.00 1.10 1.10a 2.00 2.00a 2.00a
Platform          : WINDOWS

Last Reviewed: February 5, 1998