Formatting Issues

How to Fix Excel Formula Results Appearing with Strikethrough Formatting

Steven ParkerSteven Parker Nov 10, 2026 870 views

Question details

The user needs to remove unexpected strikethrough formatting from cells containing formula results, such as concatenated text.

How to Fix Excel Formula Results Appearing with Strikethrough Formatting
Product
Excel
Device & OS
not provided
Scenario
Entering or viewing formulas in a worksheet and noticing that the output text looks crossed out.
Observed behavior
The formula result is displayed with strikethrough font formatting, despite the fact that Excel formulas only calculate values and cannot independently generate font styles.
Before you start

Keep in mind that Excel formulas only return data values and cannot output font styles like bold, italic, or strikethrough. The unwanted format is always applied at the cell level or through display settings.

Solution 1Recommended

Clear Inherited Cell Formatting and Conditional Rules

Since formulas do not return font properties, the result cell has likely inherited the strikethrough format from previous data or conditional formatting. Clearing formats will restore the default text appearance.

When you reference other cells or enter formulas into previously used cells, Excel may apply the formatting that was already present in that location. Completely clearing the format and checking conditional rules is the most effective solution.

1
Select the affected cells

Click on the cell or highlight the range of cells where the formula results are showing the strikethrough format.

2
Clear formats from the Home tab

Navigate to the 'Home' tab on the ribbon. In the Editing group, click the 'Clear' button (often represented by an eraser icon) and select 'Clear Formats' from the drop-down menu.

3
Check conditional formatting

If the strikethrough persists or reappears based on the cell's value, stay on the 'Home' tab, click 'Conditional Formatting', and select 'Manage Rules'. Review the list and delete any rule applying a strikethrough effect.

Clear Inherited Cell Formatting and Conditional Rules
Format Cleared: Using 'Clear Formats' will also remove background colors, bold text, and borders. You will need to reapply any desired stylistic formatting manually.
Manage Formatting Seamlessly

Use WPS Spreadsheet to Avoid Unwanted Formatting Glitches

If you frequently struggle with inherited formatting or stale-value display glitches in your spreadsheets, try WPS Office. WPS Spreadsheet provides a reliable and highly compatible environment where managing formulas and clearing cell formats is straightforward and bug-free.

  1. 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing spreadsheet document.
  2. 2. Highlight the affected formulas: Select the cells that are incorrectly displaying the strikethrough formatting.
  3. 3. Clear cell formatting: Go to the 'Home' tab, click the 'Eraser' icon, and choose 'Clear Formats' to instantly reset the text appearance.
  4. 4. Verify automatic calculation: Navigate to the 'Formulas' tab and ensure 'Calculate Automatically' is selected to prevent outdated visual indicators.
Free to download and use with a clean, intuitive interfaceFully compatible with Microsoft Excel (.xlsx) formats and formulasEasy 'Clear Formats' tool to instantly remove unwanted strikethroughReliable automatic calculation engine to prevent stale-value issues
QA img-9

Frequently Asked Questions

Can an Excel formula change a cell's font style or color?

No, Excel formulas are strictly designed to perform calculations and return values (like numbers or text). They cannot output or alter font properties such as color, bold, italic, or strikethrough. Any visual styling comes from the cell itself.

Why does my concatenated text suddenly have a strikethrough?

The cell where you typed the concatenation formula has likely retained formatting from whatever was previously in that cell, or it is subject to a conditional formatting rule. Clearing the cell's formats via the Home tab will fix it.

What does stale-value formatting mean in Excel?

When your workbook is set to Manual Calculation mode, Excel may cross out or grey out formula results that are no longer accurate because the referenced data has changed. Pressing F9 to recalculate the sheet updates the values and removes the strikethrough.