Formatting Issues

Fix Excel Colors Disappearing When Pasting Into Word or Outlook

Adam Davis Oct 19, 2026 869 views

Question details

The user needs to retain Excel cell background colors when copying and pasting data into Word or Outlook.

Fix Excel Cell Colors Disappearing When Pasting Into Word or Outlook

Product: Microsoft Excel, Word, Outlook
Device & OS: Windows
Scenario: Copying and pasting cells with specific standard background colors from Excel into Word or Outlook.
Observed behavior: Certain standard RGB background colors (such as yellow, red, and black) disappear entirely after being pasted.

Before you start

Ensure your work is saved and check if the issue occurs with all Excel workbooks or just a specific file before proceeding with the repairs.

Solution 1Recommended

Tweak the RGB Color Values Slightly

Adjusting the affected color's RGB values by a single point bypasses the bug in the specific Office build while keeping the color visually identical.

This issue is associated with specific standard RGB color values in certain builds of Office (like Version 2302). By slightly modifying the color values, you force the clipboard to process it as a custom color, bypassing the glitch.

Select the affected cells

Open your Excel workbook and highlight the cells with the background colors that are disappearing.

Open custom color settings

Go to the Home tab, click the arrow next to the Fill Color bucket icon, select More Colors, and navigate to the Custom tab.

Adjust RGB values

Change the Red, Green, or Blue value by just 1 point (for example, change 255 to 254) and click OK.

Copy and paste

Copy the updated cells and paste them into Word or Outlook. The colors should now transfer successfully.

Visual consistency: A one-point change in RGB value is imperceptible to the human eye, so your document's design will not be compromised.

Solution 2

Update Microsoft Office to the Latest Version

Microsoft has released a permanent fix for this specific bug in later versions of Office.

Solution 3

Perform an Online Repair of Office

If updating doesn't work, repairing the Office installation can fix corrupted system files affecting the clipboard.

Free Microsoft Office alternative

Try WPS Office for Flawless Formatting Retention

If Microsoft Office continues to drop your formatting between applications, consider switching to WPS Office. It provides a seamless ecosystem where formatting, cell colors, and layouts are flawlessly preserved when copying across Spreadsheet, Document, and Presentation tools.

1. Download WPS Office: Visit the official WPS website and download the free installation package.
2. Install the suite: Run the installer and follow the quick setup wizard to install the software on your device.
3. Open your files: Open your existing Excel and Word documents directly in WPS Office and experience seamless copy-pasting.

Highly compatible with Microsoft Office formats including .xlsx, .docx, and .pptx.Flawless formatting retention when copying data between WPS Spreadsheet and WPS Writer.Free to use, exceptionally lightweight, and fast to install.Familiar user interface with zero learning curve for Office users.

microsoft office alternative - wps office

Frequently Asked Questions

Why do only certain standard colors disappear when pasted?

A known bug in Office Version 2302 (Build 16130.20332) specifically affected standard RGB values like pure yellow, red, and black during the clipboard transfer process between Excel and Word or Outlook.

Does this formatting issue affect PowerPoint?

No, users report that copying the exact same colored cells from Excel into Microsoft PowerPoint or another Excel workbook works perfectly without losing the background colors.

How do I safely test if add-ins are causing the copy-paste issue?

You can launch Excel and Word in Safe Mode by holding the CTRL key while clicking the application shortcut. This temporarily disables add-ins so you can verify if a third-party extension is interfering with the copy-paste function.

Can I keep my original formatting when pasting as a picture?

Yes, as a quick alternative workaround, you can copy the Excel cells, switch to Word or Outlook, right-click, and select Paste Special > Picture. This preserves all visual colors exactly as they appear, though the text will no longer be editable.

Document & File Issues