Paste special of Excel object changes font style in Word document

[L_Loo2000s]

I hope someone can help me with this.  I'm using paste special to link an excel spreadsheet into a word document.  Unfortunately, the font appearance of the spreadsheet appears compressed.  Both the word document and the source excel spreadsheet are in the same font and point size, Times New Roman 12pt.

I had this problem before, prior to updating our office computers, where we added an Excel register key.  But since changing out the equipment and updating Office to 365, I don't know if this fix would still work.  Any help would be appreciated.   Thank you,

[#2]

@L_Loo2000s 

When you paste an Excel object into a Word document using Paste Special, the formatting issues you're experiencing may be related to how the data is being pasted and the interaction between the two Office applications. Here are some steps you can take to resolve the font appearance issue:

1. Paste as a Picture (Enhanced Metafile): When using "Paste Special," select "Picture (Enhanced Metafile)" as the format. This often helps maintain the formatting of the Excel object when pasted into Word. To do this, follow these steps:
• In Excel, copy the data you want to paste.
• In Word, go to the location where you want to paste the data.
• Click "Paste" (or use the keyboard shortcut Ctrl+V) to paste the Excel data.
• In the "Paste Special" dialog box, select "Picture (Enhanced Metafile)."
• Click "OK."
2. Check Excel and Word Font Settings: Ensure that both Excel and Word are using the same default font settings. In Excel, go to "File" > "Options" > "General," and check the "Use this as the default font" setting. In Word, do the same by going to "File" > "Options" > "General."
3. Update Office and Windows: Ensure that you have the latest updates for both Microsoft Office 365 and Windows. Sometimes, updating the software can resolve compatibility issues.
4. Document Template and Styles: Check the Word document template and styles. If you're using a custom template, make sure it has the correct font settings. Also, check the styles used in the Word document and verify that they are consistent with the font settings.
5. Clear Formatting: In Word, you can try to clear the formatting of the pasted Excel object and then apply your preferred formatting. To do this:
• Select the pasted Excel object in Word.
• Go to the "Home" tab.
• In the "Editing" group, click "Clear" and select "Clear Formatting."
6. Use a Linked Object: If you need the Excel data to be dynamically updated when changes are made in the source file, consider using a linked object. In Excel, select "Paste Special" and choose the "Microsoft Excel Worksheet Object" option with the "Link" checkbox enabled.
7. Registry Key (if needed): If the font issue persists, you can try the same registry key solution that worked previously. Ensure that it's compatible with your current version of Office 365.

If none of these steps resolve the issue, there may be specific compatibility or configuration issues with your system or setup. The text was created with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and like it!

This will help all forum participants.