How to Use WPS Strikethrough on Windows

Use WPS Strikethrough with 2 how-to topics, including applying strikethrough and removing strikethrough, both available directly in WPS Spreadsheets on Windows.

How-to Index

How-to Guide

1. Apply Strikethrough

Feature entry: Home tab → Font group → strikethrough-related settings

1. Select the cell or text where you want to add strikethrough.
2. Click the dialog box launcher in the lower-right corner of the Font group on the Home tab.
3. In the Font tab, select Strikethrough in the Effects area.
4. Click OK to apply the setting.
5. For a faster method, you can also try the keyboard shortcut Ctrl+5.

Success Criteria

• A horizontal line appears through the selected text.
• The original data in the cell remains available for editing, copying, and calculation.
• Other unselected content in the worksheet is not changed at the same time.

Tips While Using

• If you only want to format part of the text, enter cell editing mode first and then select the target text.
• Strikethrough is a formatting effect and does not delete actual data.
• Whether the shortcut works can depend on the current input state or system shortcut conflicts.

2. Remove Strikethrough

Feature entry: Home tab → Strikethrough button or font settings

1. Select the cell or text that already has strikethrough.
2. Click the Home tab.
3. Click the Strikethrough button again, or open the font settings and clear Strikethrough.
4. The strikethrough is removed.

Success Criteria

• The existing horizontal line no longer appears.
• The cell text returns to normal display.
• The data itself remains unchanged.

Tips While Using

• Strikethrough works as a toggle, so applying it again removes it.
• If a cell contains mixed formatting, make sure the correct range is selected.
• Removing strikethrough does not affect bold, italic, or other styles unless you change them manually at the same time.