10-Point Fonts in Excel Paste As Default Point Size in WinWord

Last reviewed: February 5, 1998
Article ID: Q96246
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 4.0, 5.0

SUMMARY

If you copy text formatted as 10 point from Microsoft Excel and paste it into a Word for Windows document, Word changes the 10-point text to the default point size if the default font size is other than 10 points. For example, if your default font in Word is Times New Roman, 12 point, all 10-point Microsoft Excel text changes to 12-point text when you paste it into a Word document. The typeface does not change; for example, Arial 10 pastes as Arial 12, and Courier 10 pastes as Courier 12.

Word does not change other point sizes, which means that 12-point fonts paste as 12 points, 8-point fonts past as 8 points, and so on.

This problem occurs only when you perform a paste operation. It does not occur if you embed or paste link the Excel data.

Microsoft has confirmed this to be a problem in Word for Windows, versions 1.x, 2.0, 2.0a, 2.0a-CD, 2.0b, 2.0c, 6.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Workaround

In Word, change the default font size to 10 points before you paste the Excel data. When the default font size is 10 points in Word, the problem does not occur. After you paste the Excel data, change your default font size back to the original setting.


KBCategory:
KBSubcategory:
Additional query words: winword2 1.0 1.10 1.10a 2.0 2.0a word6
winword 2.0a-CD 2.0b 2.0c normal style

Keywords : kbinterop
Version : 1.x 2.x 6.0 6.0a 6.0c
Platform : WINDOWS


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 5, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.