Formatting Issues

Fix Excel Find and Replace Changing Text Color in Multiline Cells

Maira Mehtab Sep 22, 2026 868 views

Question details

The user needs to prevent Excel's Find and Replace function from stripping or altering the individual font colors applied to specific lines of text within multiline cells.

Product: Excel
Device & OS: not provided
Scenario: Attempting to bulk replace text in Excel cells that contain multiple lines of text with varying font colors.
Observed behavior: When using the Replace function, all character-level formatting within the cell is overwritten, causing the text to revert to a single, uniform color instead of preserving the custom formatting.

Before you start

Evaluate whether you need to modify a small number of cells or a large batch, as preserving character-level formatting natively requires manual editing, while bulk automation requires desktop-only VBA scripts.

Solution 1Recommended

Manually Edit Text to Preserve Character Formatting

Since the automatic Replace function overwrites rich text formatting, the most reliable method for all platforms (including Android) is to use Find to locate the cell, then edit it manually.

Locate the target cell

Press Ctrl+F on your keyboard to open the Find dialog box, type the word you are looking for, and click 'Find Next' to select the cell.

Enter cell edit mode

Double-click the selected cell, or click into the formula bar at the top of the screen to edit the contents without triggering a bulk replace.

Replace the text manually

Highlight the specific word or line you want to change and type the new text. The newly typed text will inherit the specific font color originally applied to that section of the cell.

Quick Edit Shortcut: After locating the cell with the Find tool, you can press F2 on a desktop keyboard to instantly jump into cell edit mode.

Solution 2

Use a VBA Macro (Desktop Only)

If you have a massive spreadsheet and manually editing is not feasible, you can use a VBA script to programmatically replace text while retaining character-specific Font.ColorIndex properties.

Free Microsoft Office alternative

Edit Spreadsheets Seamlessly with WPS Office

If you frequently encounter complex formatting limitations in Microsoft Excel, try WPS Office. It provides a lightweight, entirely free spreadsheet editor that supports precise text formatting and is perfectly compatible with your existing files.

1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your device.
2. Open your spreadsheet: Launch WPS Spreadsheet and open your existing Excel file.
3. Edit your text: Use the familiar Find tool (Ctrl+F) to locate your multiline cells and easily edit them while preserving your custom font colors.

Fully compatible with Microsoft Excel (.xlsx and .xls) formatsPrecise cell formatting and robust Find & Replace capabilitiesFamiliar tabbed interface ensuring zero learning curveCross-platform support available for Windows, Mac, Android, and iOS

microsoft office alternative - wps office

Frequently Asked Questions

Why does Find and Replace remove text color in Excel?

Excel's Find and Replace feature replaces the entire underlying string value of the cell at once. During this bulk operation, Excel resets any character-level rich text formatting (like different font colors on multiple lines) back to the cell's default format.

Can I use Find and Replace without losing formatting on Excel for Android?

No, the mobile version of Excel does not support VBA macros, which are required to automate replacements while preserving individual text colors. On Android, you must use the Find tool to locate the cell and edit the text manually.

Does replacing the whole cell keep the background color?

Yes, cell-level formatting such as background fill color, borders, and general text alignment remains unaffected by the Find and Replace tool. Only character-level formatting (different colors or font sizes applied to specific words inside the cell) is lost.

Is there a way to lock character formatting in a cell?

There is no built-in toggle in Excel to lock character formatting during a Find and Replace operation. Preserving rich text within a single cell always requires either manual text editing or a custom VBA macro.

Document & File Issues