Excel Data Pastes into Word with Incorrect Cell Alignment

ID: Q75101

The information in this article applies to:

SYMPTOMS

When you copy data from a Microsoft Excel version 3.0 or 4.0 spreadsheet and paste or paste link it into a Word for Windows document, the cells are usually formatted for right alignment. This can cause alignment problems if you insert tabs in Word. For example, if you insert a decimal tab in the table that you pasted from Microsoft Excel, Word may not automatically align the data correctly. In some cases, Word moves the data into an adjacent column.

By contrast, when you copy data from a Microsoft Excel version 5.0 spreadsheet and paste it in your Word document, the cells are formatted for the correct paragraph alignment. However, if you later modify the spreadsheet so the cell alignment changes in Microsoft Excel, the alignment does not change in Word. For example, if a cell was originally right- aligned and you switch it to left-aligned in Microsoft Excel, the cell remains right-aligned in Word, even after you update the LINK field.

CAUSE

With Microsoft Excel 3.0 and 4.0, Word uses right alignment, which is the default format for numbers in Microsoft Excel. When a cell is right aligned, tabs may behave unexpectedly.

With Microsoft Excel 5.0, Word applies the correct alignment formatting when you initially create the link. Then, if you change the alignment of a cell in a spreadsheet, Microsoft Excel sends the correct formatting information to the link in Word; however, the \* mergeformat switch in the Word LINK field prevents the new formatting from being applied.

STATUS

By default, Word includes the \* mergeformat switch when you insert a LINK field. The \* mergeformat switch preserves the formatting of the original field result, so if you change the formatting and then update the LINK field, Word replaces the new formatting with the original formatting.

WORKAROUNDS

Method 1

First, remove the \* mergeformat switch from the LINK field in Word. Then in Word, apply the correct alignment formatting to the linked Microsoft Excel spreadsheet. When you update the spreadsheet, Word retains the formatting you apply.

Method 2

If you change the formatting in Microsoft Excel and want the LINK field result to reflect the correct formatting in Word, delete and reinsert the LINK field. When you use this method, you do not need to remove the \* mergeformat switch from the LINK field.

KBCategory: kbusage KBSubcategory: kbfield kbfield kbtable Additional query words: right aligned 1.x 2.0 2.0a 7.0 word95 word7 word6 winword 2.0a-CD 2.0b 2.0c 6.0 6.0a 6.0c winword2 officeinterop word97 excel

Keywords          : kbfield kbtable 
Version           : 1.x 2.x 6.0 6.0a 6.0c 7.0 7.
Platform          : WINDOWS

Last Reviewed: February 6, 1998