Fix Keep Source Formatting Not Working When Pasting Excel into Word
Question details
Users are experiencing an issue where copying tabular data from Excel and pasting it into Word using the 'Keep Source Formatting' option fails to retain the original cell colors and styles.
- Product
- Microsoft Word and Microsoft Excel
- Device & OS
- not provided
- Scenario
- Pasting a spreadsheet table into a text document while attempting to preserve its original appearance, background colors, and formatting.
- Observed behavior
- Original formatting, particularly background colors, is lost or altered despite selecting the 'Keep Source Formatting' paste option. Standard troubleshooting like Office repair or add-in disabling does not resolve it.
Ensure your Microsoft Office applications are updated to the latest build, as Microsoft occasionally releases patches for known clipboard and formatting bugs.
Report the Issue via Microsoft Office Feedback
Since this is a known, reproducible bug currently being investigated by the Microsoft Office team, submitting your specific diagnostic data helps expedite a patch.
Standard troubleshooting methods like repairing the Office installation, reinstalling the software, or disabling add-ins have proven ineffective for this specific bug. The most actionable step is to provide your build details to the developers.
Launch Microsoft Word and open a blank document or the document where you experienced the pasting issue.
Click on the 'File' tab located in the top-left corner of the ribbon menu, then select 'Feedback' from the bottom of the left sidebar.
Click on 'Report a Problem' or 'I Don't Like Something'. Provide a detailed description including your Office version, the types of documents involved, and the exact steps that lead to the loss of Excel colors.
Use Paste Special as an Embedded Object
If you need to edit the data in Word while retaining 100% of the Excel formatting and colors, embedding the data is the most reliable workaround.
Seamlessly Paste Spreadsheets to Documents with WPS Office
If Microsoft Office continues to drop your cell colors and formats during cross-application copying, try WPS Office. It provides robust compatibility with Microsoft formats and handles copying from spreadsheets to documents smoothly, ensuring your carefully designed table styles are always preserved.
- 1. Download and Install WPS Office: Get the free WPS Office suite from the official website and install it on your device.
- 2. Open Your Files in WPS: Open your existing .xlsx spreadsheet in WPS Spreadsheet and your .docx document in WPS Writer.
- 3. Copy and Paste Seamlessly: Select your table in WPS Spreadsheet, copy it, and paste it into WPS Writer. Your formatting will remain completely intact.
Frequently Asked Questions
Why does 'Keep Source Formatting' fail between Excel and Word?
This is a known clipboard handling bug in certain versions of Microsoft Office. Even when the correct paste option is selected, Word's rendering engine occasionally drops specific attributes like custom cell background colors from the copied Excel data.
Will repairing Microsoft Office fix this pasting issue?
No, standard troubleshooting steps like running the Office Repair tool, reinstalling the software, or disabling add-ins typically do not resolve this specific formatting bug, as it stems from an internal software glitch that requires an official patch from Microsoft.
How can I keep the Excel formatting without embedding the file?
If you only need a visual representation of the data and do not need to edit the text in Word, you can use the 'Paste as Picture' option. Click the drop-down under the Paste button and select the Picture icon to insert the table as an image with perfect color fidelity.
