How to Fix Excel Formula Results Appearing with Strikethrough Formatting
Question details
The user needs to remove unexpected strikethrough formatting from cells containing formula results, such as concatenated text.

- 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.
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.
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.
Click on the cell or highlight the range of cells where the formula results are showing the strikethrough format.
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.
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.

Disable Manual Calculation Stale-Value Display
If Excel is set to manual calculation, uncalculated results might appear crossed out to indicate the displayed value is stale.
Restart Excel to Clear Display Glitches
Temporary cached formatting information or minor software display bugs can cause visual errors that are fixed by restarting.
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. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing spreadsheet document.
- 2. Highlight the affected formulas: Select the cells that are incorrectly displaying the strikethrough formatting.
- 3. Clear cell formatting: Go to the 'Home' tab, click the 'Eraser' icon, and choose 'Clear Formats' to instantly reset the text appearance.
- 4. Verify automatic calculation: Navigate to the 'Formulas' tab and ensure 'Calculate Automatically' is selected to prevent outdated visual indicators.

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.




