This section includes 4 how-to topics for WPS Strikethrough on Windows, covering ribbon access, the Format Cells dialog, the right-click menu, and the Ctrl+5 shortcut.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Apply strikethrough from the ribbon | Free |
| 2 | 2. Apply strikethrough from the Format Cells dialog | Free |
| 3 | 3. Apply strikethrough from the right-click menu | Free |
| 4 | 4. Toggle strikethrough with Ctrl+5 | Free |
How-to Guide
1. Apply strikethrough from the ribbon
Feature path: Home tab → Strikethrough button
- Select the cell where you want to add strikethrough, or double-click the cell and select part of the text inside it.
- Click the Strikethrough button in the Font group on the Home tab.
- Check whether a horizontal line appears through the selected text.
- To remove the effect, click Strikethrough again.
Success Criteria
- Visual result: A line appears through the middle of the selected text.
- Next action available: You can keep typing, save the file, or apply other font formatting.
Tips While Using
- Common mistake: If no text is selected first, the formatting may not apply to the intended content.
- Environment note: If the worksheet or cell is protected, formatting changes may not be available.
2. Apply strikethrough from the Format Cells dialog
Feature path: Home tab → Font settings arrow → Strikethrough
- Select the target cell or the text inside the cell.
- Click the font settings arrow on the Home tab.
- In the dialog box, open the font-related settings area.
- Select the Strikethrough checkbox and click OK.
Success Criteria
- Visual result: The target text shows the strikethrough effect.
- Next action available: You can continue adjusting font, size, or related text settings in the same dialog.
Tips While Using
- Common mistake: If you open the dialog but do not select Strikethrough before clicking OK, nothing changes.
- Environment note: If you are not editing part of the text directly, the setting may apply to the full cell text.
3. Apply strikethrough from the right-click menu
Feature path: Right-click menu → Format Cells → Font tab → Strikethrough checkbox
- Select the target cell.
- Right-click and choose Format Cells.
- Open the Font tab.
- Select the Strikethrough checkbox and click OK.
Success Criteria
- Visual result: The text in the selected cell shows strikethrough.
- Next action available: You can continue adjusting other cell formatting options from the same menu path.
Tips While Using
- Common mistake: If you right-click outside the intended cell, you may format the wrong area.
- Environment note: If multiple cells are selected, the same formatting is applied across the selection.
4. Toggle strikethrough with Ctrl+5
Feature path: Select text → Press Ctrl+5
- Select the cell or text that you want to format.
- Press Ctrl+5.
- Check whether strikethrough has been applied.
- Press Ctrl+5 again to remove it.
Success Criteria
- Visual result: The strikethrough state switches on or off.
- Next action available: You can continue editing other cells without opening a menu.
Tips While Using
- Common mistake: If another app or input method is using the shortcut, the command may not respond as expected.
- Environment note: Make sure the editing focus is inside WPS Spreadsheet.