Formatting Issues

How to Remove Unexpected Lines or Strikethrough Formatting in Excel

Bushra ParveenBushra Parveen Nov 10, 2026 869 views

Question details

The user needs to remove unintended lines or strikethrough effects from cell values in Excel.

How to Remove Unexpected Lines or Strikethrough Formatting 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.
Before you start

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.

Solution 1Recommended

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.

1
Select affected cells

Highlight the cells or range containing the unexpected lines.

2
Open Format Cells

Right-click the selected cells and choose 'Format Cells' from the context menu, or press Ctrl + 1 on your keyboard.

3
Disable Strikethrough

Navigate to the 'Font' tab. Under the Effects section, uncheck the 'Strikethrough' box and click 'OK'.

Disable Strikethrough in the Format Cells Dialog
Keyboard Shortcut: You can quickly toggle strikethrough formatting on and off by selecting the cells and pressing Ctrl + 5.
Resolve formatting issues easily

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. 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your Excel file containing the formatting issues.
  2. 2. Access the Format Cells dialog: Select the affected cells, right-click, and choose 'Format Cells', or press the Ctrl+1 shortcut.
  3. 3. Remove the strikethrough effect: Navigate to the Font tab, uncheck the Strikethrough option, and click OK to restore your text.
Quickly clear stale or unwanted formatting with just a few clicks.Easily manage conditional formatting rules to prevent unexpected lines.Fully compatible with Microsoft Excel (.xlsx) file formats.Free and lightweight alternative for all your spreadsheet tasks.
microsoft office alternative - wps office

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.