Why do my excel formulas have strikethrough
Diagnose and fix why Excel formulas appear with a strikethrough. Learn the common formatting causes, step-by-step checks, and prevention tips to restore clean formulas fast.
Strikethrough on Excel formulas is usually a formatting issue, not a broken calculation. The most common causes are font formatting or a conditional-formatting rule applying the Strikethrough effect. To fix it, inspect the cell’s font settings, review any conditional formatting that could add a strike, and reset the cell to Normal formatting. Then recheck the formula to confirm it recalculates correctly.
Why do my excel formulas have strikethrough
If you’re asking why do my excel formulas have strikethrough, the quick answer is that it’s usually a formatting issue rather than a broken formula. According to XLS Library, the most common cause is a formatting layer that applies the Strikethrough effect to the cell text. When a cell is formatted with Strikethrough, the characters appear with a line through them, including the visible formula in the formula bar or in the cell itself. This often happens when a template or style carries a Strikethrough setting, or when a formatting shortcut was accidentally triggered. The good news is that you can fix it without altering the calculation. Start by checking the Font settings, then review any conditional-formatting rules, and finally confirm that no macro or add-in is forcing the Strikethrough appearance.
Common causes of strikethrough in Excel formulas
There are several likely culprits when you see strikethrough on formulas. First, a simple font-level format: the Strikethrough checkbox in the Font group may be turned on for the affected cells or for the worksheet style. Second, conditional formatting can apply a font effect to an entire range when a condition is met, which can include Strikethrough. Third, an add-in or macro can programmatically apply font effects to values or formulas. Fourth, a copied format from another cell or template may bring in a Strikethrough style without touching the formula itself. Finally, a custom number format could visually overlay a line if misinterpreted. Identifying the exact trigger is the key to a clean, calculation-only result.
How to distinguish formatting from a real calculation issue
To solve the mystery of a strikethrough, separate formatting from calculation problems. Start by selecting the cell and inspecting the Font settings on the Home tab; ensure Strikethrough is off. If the effect persists, try clearing formats (Home > Clear > Clear Formats) and re-entering the formula in a fresh cell. If the strike continues, the issue is likely due to conditional formatting or a macro. You should also review the workbook’s styles to see if Normal or Custom styles include Strikethrough. A quick test is to paste the formula into a new workbook; if the strikethrough follows the formula, formatting is workbook-scoped rather than data-driven.
Fixes: step-by-step checks for the most common causes
Step-by-step fixes help you regain a clean formula view. First, check the font: select the affected cell(s), open the Font dialog, and uncheck Strikethrough. If many cells are involved, you can apply Clear Formats to the entire range. Step two is to inspect conditional formatting rules: open Home > Conditional Formatting > Manage Rules, and look for any rule that applies Strikethrough to your target cells. Step three is to review cell styles: switch the style to Normal or create a new style without Strikethrough. Step four, if still unresolved, examine macros or add-ins that might alter font attributes and disable them for testing.
When conditional formatting is the culprit
Conditional formatting can apply font effects like Strikethrough based on a condition, which can make formulas appear struck through even though the calculation is correct. To test this, temporarily disable conditional formatting or modify the rule to remove the Strikethrough font effect. If the issue disappears, you’ve found the root cause. Remember to re-enable the formatting once you’ve verified the formulas, so you don’t lose other visual cues in your worksheet.
Preventive practices to avoid future strikethrough issues
Adopt routine checks to prevent Strikethrough surprises. Use standardized cell styles (e.g., Normal) for all core formulas and avoid reusing templates that carry Strikethrough formatting. When copying formulas, use Paste Special > Formulas to avoid carrying over formatting. Create a quick test workbook to verify new sheets before integrating them into larger models. Finally, document any add-ins or macros that modify fonts so teammates can troubleshoot quickly.
Testing in a safe environment: using a clean workbook
Always test suspected fixes in a clean workbook before applying changes to mission-critical files. Create a new worksheet, reproduce the formula, and apply each fix in isolation: first font, then conditional formatting, then macros. If the issue is resolved in the clean environment, port the working configuration back to the original workbook with caution. This workflow helps prevent unintended changes across complex spreadsheets.
Steps
Estimated time: 25-40 minutes
- 1
Check font formatting
Select the cell(s), open the Font dialog, and ensure Strikethrough is not checked. If multiple cells, apply to range or Clear Formats as needed.
Tip: Use Ctrl+Shift+F to jump to Font quickly. - 2
Clear or reset formatting
Apply Clear Formats to remove any inherited styling, then re-enter the formula in a fresh cell to see if Strikethrough reappears.
Tip: Consider using Paste Special > Formulas to avoid re-applying formatting. - 3
Inspect conditional formatting
Go to Home > Conditional Formatting > Manage Rules and look for any rule applying Strikethrough to the target range. Edit or delete as appropriate.
Tip: Disable rules temporarily to test impact. - 4
Check for macros/add-ins
Disable any macros or add-ins that might modify font attributes, then re-test the worksheet to confirm the fix.
Tip: Run Excel in Safe Mode to isolate add-ins quickly.
Diagnosis: Formula cells display a visible Strikethrough on the value or formula text
Possible Causes
- highFont formatting applied to the cell or style
- highConditional formatting applying Strikethrough
- mediumMacro or add-in automatically applying Strikethrough
- mediumInheriting a cell style with Strikethrough from a template
Fixes
- easyTurn off Strikethrough in the Font options or apply Normal style
- easyReview and remove any Strikethrough rules in Conditional Formatting Rules Manager
- mediumDisable suspicious macros/add-ins and test in a clean workbook
- easyReset workbook styles to Normal and re-enter the formula to confirm
People Also Ask
Why do my Excel formulas show strikethrough?
Strikethrough on formulas is usually a formatting issue, often caused by the Font Strikethrough setting or a conditional formatting rule. Less commonly, macros or inherited styles can apply the effect. The underlying calculation is typically correct once formatting is fixed.
Usually formatting, not calculation error. Check font settings and conditional formatting first.
How do I remove strikethrough from a cell in Excel?
Select the cell, open the Font dialog, and uncheck Strikethrough. If that doesn’t work, Clear Formats (Home > Clear > Clear Formats) or reset the cell style to Normal, then re-enter the formula.
Turn off Strikethrough in the Font menu or Clear Formats.
Can conditional formatting apply strikethrough to formulas?
Yes. Conditional formatting can apply font effects like Strikethrough based on conditions. Review the Rules Manager to identify and remove any Strikethrough font formatting.
Yes, check Conditional Formatting rules to remove Strikethrough.
Could a macro cause strikethrough in formulas?
Macros or add-ins can modify font attributes and apply Strikethrough. Disable them temporarily to test whether the issue resolves, then adjust or replace the macro as needed.
Macros can apply fonts; test with macros disabled.
Does Show Formulas affect strikethrough appearance?
Show Formulas reveals formula text; it doesn’t inherently apply Strikethrough. If you still see a strike, focus on font or formatting rules impacting the display.
Showing formulas doesn’t cause Strikethrough by itself.
Watch Video
The Essentials
- Identify whether Strikethrough is formatting or a real issue
- Check Font, Conditional Formatting, and macros in sequence
- Test fixes in a clean workbook before applying widely
- Standardize cell styles to prevent recurrence
- Back up workbooks before major formatting changes
