Formatting Issues

Fix Excel Find and Replace Removing Text Colors in a Cell

Algirdas Jasaitis Sep 28, 2026 868 views

Question details

The user needs to find and replace specific text within a cell without losing the different text colors and character-level formatting applied to other lines in that same cell.

How to Prevent Excel Find and Replace from Removing Text Colors in a Cell

Product: Excel
Device & OS: not provided
Scenario: Using the standard Find and Replace tool on cells containing multiple lines with distinct text colors or formatting styles.
Observed behavior: Excel's Find and Replace overwrites the character-level formatting, causing all the text within the entire cell to revert to a single uniform text color.

Before you start

Before making bulk text replacements, create a backup copy of your worksheet to ensure you do not accidentally permanently overwrite complex cell formatting.

Solution 1Recommended

Use Find and Manually Edit the Cell

Since Excel's built-in Replace function inherently resets character-level formatting, manually editing the located cells is the most reliable way to preserve your specific text colors.

Open the Find Dialog

Press 'Ctrl + F' on Windows or 'Cmd + F' on Mac to open the Find and Replace dialog box.

Locate the Target Cell

Enter the specific text you are looking for in the 'Find what' field and click 'Find Next' to jump to the relevant cell.

Enter Edit Mode

Double-click the highlighted cell, or press the 'F2' key on your keyboard, to enter cell edit mode.

Replace Text Manually

Highlight only the specific word or line you want to change using your mouse, then type the new text. This ensures the text colors on the surrounding lines remain untouched.

Solution 2

Use a VBA Macro for Bulk Replacement

If you have a large dataset in desktop Excel, a VBA macro can automate the replacement process while looping through characters to restore required formatting.

Free Microsoft Office alternative

Try WPS Office for Your Spreadsheet Needs

If you frequently work with complex data and need a reliable, lightweight application, WPS Office is an excellent free alternative to Microsoft Office. It offers extensive formatting tools and a familiar interface without the heavy subscription costs.

1. Download the Installer: Visit the official WPS Office website and click 'Download WPS Office Free'.
2. Install WPS Office: Run the downloaded installer and follow the on-screen prompts to set up the software.
3. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx files to edit them instantly.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Free built-in tools for data formatting, charts, and advanced analysis.Lightweight and runs smoothly on both desktop and mobile devices.Familiar user interface requiring zero learning curve for Excel users.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel remove my text colors when I use Find and Replace?

Excel's Find and Replace tool treats the entire cell as a single unformatted string during a bulk replacement. Once the text is replaced, it applies the default or first character's formatting to the whole cell, overwriting any custom character-level colors.

Can I use VBA to fix this formatting issue on Excel for Android?

No, Visual Basic for Applications (VBA) macros are only supported in the desktop versions of Excel for Windows and Mac. They cannot be executed on mobile platforms like Android or iOS.

Is there a setting in Excel to make Find and Replace keep multiple text colors?

Unfortunately, there is no built-in toggle or setting in standard Excel that forces Find and Replace to respect partial character formatting. You must rely on manual cell editing or advanced VBA scripting.

Document & File Issues