How to Remove Unexpected Lines or Strikethrough Formatting in Excel
Question details
The user needs to remove unintended lines or strikethrough effects from cell values in Excel.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Editing and formatting data in Excel spreadsheets.
- Observed behavior
- Unexpected lines or strikethrough formatting appear on cell values, likely due to stale or inherited formatting rules.
Identify which specific cells or ranges are displaying the unexpected lines to ensure you do not accidentally clear intentional formatting from the rest of your spreadsheet.
Disable Strikethrough in the Format Cells Dialog
The most direct way to remove unexpected lines is to check and disable the strikethrough effect in the font settings.
Often, lines appearing through text are caused by the strikethrough font effect being enabled, either manually or inherited from copied data.
Highlight the cells or range containing the unexpected lines.
Right-click the selected cells and choose 'Format Cells' from the context menu, or press Ctrl + 1 on your keyboard.
Navigate to the 'Font' tab. Under the Effects section, uncheck the 'Strikethrough' box and click 'OK'.

Clear All Cell Formatting
If disabling strikethrough does not work, clearing all stale formatting from the cell will reset it to the default text style.
Check and Remove Conditional Formatting
Sometimes strikethrough is applied automatically via hidden conditional formatting rules that need to be cleared.
Manage Cell Formatting Efficiently in WPS Spreadsheet
WPS Spreadsheet provides an intuitive interface to manage, clear, and customize cell formatting. Easily remove unwanted strikethrough effects and apply professional styles to your data without hassle.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your Excel file containing the formatting issues.
- 2. Access the Format Cells dialog: Select the affected cells, right-click, and choose 'Format Cells', or press the Ctrl+1 shortcut.
- 3. Remove the strikethrough effect: Navigate to the Font tab, uncheck the Strikethrough option, and click OK to restore your text.

Frequently Asked Questions
Why do lines suddenly appear through my text in Excel?
This usually happens when you inherit a spreadsheet with existing conditional formatting rules, copy and paste data with hidden formatting, or accidentally press the strikethrough keyboard shortcut (Ctrl + 5).
Will clearing formats delete my data?
No, using the 'Clear Formats' option only removes the visual styling (such as fonts, colors, borders, and strikethrough) while leaving the actual cell values and formulas completely intact.
How do I find cells with conditional formatting applied?
You can easily locate these cells by pressing F5 to open the 'Go To' dialog, clicking 'Special', and selecting 'Conditional formats'. This highlights all cells currently governed by conditional rules.




