Formatting Issues

Fix Formatted Text Losing Bold and Color When Copied in Excel

Aamir Naveed Akram Oct 1, 2026 868 views

Question details

Users report that copying formatted portions of text from within an Excel cell strips away character-level formatting such as bold and font color upon pasting.

Why Formatted Text Loses Bold and Color When Copied in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Copying a specific word or phrase that has been styled (e.g., colored or bolded) from within an Excel cell's edit mode and pasting it into another cell.
Observed behavior: The text content transfers successfully to the destination cell, but all rich-text formatting is lost, defaulting to standard unformatted text.

Before you start

Determine whether you need to copy only a portion of the text or the entire cell. Copying the entire cell preserves all formatting, whereas copying partial text from the formula bar will trigger this limitation.

Solution 1Recommended

Reapply Character Formatting Manually

Since Excel does not preserve rich-text formatting when copying partial cell contents to the clipboard, the most direct workaround is to reapply the styling after pasting.

Excel treats text copied from inside a cell (edit mode) as plain text. To achieve character-level formatting in the destination cell, you must use the standard formatting tools to style the specific characters again.

Paste the text

Double-click the destination cell and press Ctrl+V to paste your plain text.

Highlight the specific text

Select the exact words or characters you want to format within the destination cell.

Reapply formatting

Navigate to the Home tab on the Ribbon, locate the Font group, and click the Bold icon or choose the desired Font Color.

Limitation Note: This plain-text clipboard behavior is inherent to Excel's handling of partial cell data and cannot be bypassed with a simple Paste Special command.

Solution 2

Copy the Entire Cell to Preserve Formatting

If you need the text and its exact formatting in a new location, copying the entire cell rather than the text inside it will preserve the rich-text styling.

Solution 3

Submit a Product Suggestion

If this formatting limitation heavily impacts your workflow, you can report the behavior directly to Microsoft.

Free Microsoft Office alternative

Try WPS Office for a Smoother Spreadsheet Experience

If you find yourself frustrated by strict formatting limitations in your current spreadsheet software, try WPS Office. It provides a robust, lightweight, and completely free alternative with excellent format compatibility.

1. Download the software: Visit the official WPS Office website and download the free installation package for your operating system.
2. Install and launch: Run the installer and launch WPS Spreadsheets once the installation is complete.
3. Open your files natively: Open your existing Excel files directly in WPS Spreadsheets. Formatting and data will be fully preserved without needing conversion.

Seamless compatibility with Microsoft Office file formats (.xlsx, .xls, .csv).Free to use with a familiar, user-friendly interface requiring zero learning curve.Robust text and cell formatting tools to easily manage your data presentation.Lightweight application that runs smoothly on Windows, Mac, and Linux devices.

microsoft office alternative - wps office

Frequently Asked Questions

Can I use the Format Painter to apply bold or color to partial text in a cell?

No. The Format Painter tool applies styles to entire cells only. It cannot be used to paint formatting onto specific characters or individual words within a cell.

Why does Excel treat copied partial text differently than whole cells?

When you copy an entire cell, Excel copies its background XML structure, preserving rich-text formatting. When you highlight text inside the formula bar or cell edit mode, Excel copies it merely as plain text strings to the system clipboard.

Is there a shortcut to reapply bold text quickly?

Yes. After pasting your plain text into the destination cell, highlight the specific word and press Ctrl+B (Windows) or Cmd+B (Mac) to quickly reapply the bold formatting.

Excel & Data Problems