WPS Strikethrough is a text-formatting feature in WPS Spreadsheets for adding or removing strikethrough from cell content; it includes 2 core tasks, with 2 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 2 | Matches the number of rows in the How-to Index |
| Available without membership | 2 | Matches the number of Free rows in the index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
About This Feature
Overview
Strikethrough is a font-formatting feature in WPS Spreadsheets that adds a horizontal line through text in a cell. It is commonly used to mark completed, expired, or temporarily inactive content.
On Windows, this feature supports two common tasks:
- Apply strikethrough: Add a strikethrough effect to selected cell content or selected text.
- Remove strikethrough: Clear existing strikethrough formatting and return text to normal display.
This feature does not delete the actual data in a cell and does not affect formula results. It is mainly used for visual marking and status distinction.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device that can run WPS Office |
| App version | The latest version of WPS Office is recommended |
| Network | No mandatory internet connection is required for local text formatting |
| Other | You need to be able to open WPS Spreadsheets and edit the target worksheet normally |
Download & Installation
Before using Strikethrough, install WPS Office for Windows and confirm that spreadsheet files can open normally.
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Post-installation check | Open WPS Spreadsheets, open any worksheet, and check the font-related controls on the Home tab |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Lets you apply or remove strikethrough for cell content in spreadsheets through the Home tab and font settings. | Word lets you apply or remove strikethrough from selected text on the Home tab, and it also supports double strikethrough in the Font dialog box. | Google Docs lets you apply strikethrough from the Format menu under Text, and related text-formatting controls are also available from the toolbar. | Notion supports strikethrough for selected text with a keyboard shortcut and also supports Markdown-style ~text~ input for strikethrough. | Acrobat focuses on editing and marking text in PDFs. Its official help content emphasizes PDF text editing rather than spreadsheet cell text formatting. |
| WPS Advantages | Advantage: WPS fits spreadsheet cell workflows directly, so it is convenient for marking task status, expired values, and retained reference data inside tables. | Compared with WPS: Word focuses on document text formatting and also supports double strikethrough, but the official guidance is centered on document text rather than spreadsheet data handling. | Compared with WPS: Google Docs clearly supports strikethrough in documents, but its official guidance is centered on document text formatting instead of spreadsheet cell formatting. | Compared with WPS: Notion works well for page and block editing with shortcuts and Markdown input, but its official guidance provides less emphasis on traditional spreadsheet cell font formatting. | Compared with WPS: Acrobat is better suited to PDF text editing and markup, not routine spreadsheet formatting work. |
| Official Source | — | Apply or remove strikethrough text formatting | Change how paragraphs and fonts look | Keyboard shortcuts | Edit text in PDFs in Acrobat |
Overall Conclusion
If your main task is marking completed, expired, or paused data inside spreadsheets, WPS Strikethrough fits everyday spreadsheet editing more directly. Other products also support strikethrough or text markup, but their official guidance is more focused on document, page, or PDF editing scenarios.
Use Cases
| No. | Scenario | Suitable for | Main pain point | Solution |
|---|---|---|---|---|
| 1 | Mark completed tasks | Project members, administrative staff | Completed and pending items need to be distinguished quickly | Apply strikethrough to the relevant cell content |
| 2 | Mark expired data | Operations, finance, and sales staff | Old values still need to be kept but should no longer be used | Keep the original value and mark it as invalid with strikethrough |
| 3 | Keep revision history visible | Collaborative editors | Previous content needs to remain visible for comparison | Apply strikethrough to older content instead of deleting it |
| 4 | Organize checklists | Students, teachers, and office users | Long lists make status hard to identify at a glance | Use strikethrough to separate processed items from pending ones |
| 5 | Mark content as temporarily inactive | Worksheet maintainers | Content should not be deleted immediately to avoid mistakes | Add strikethrough first, then decide whether to delete it later |
Membership & Benefits
Strikethrough can be used directly in WPS Spreadsheets on Windows; this section outlines general differences between free and premium access, recommended plans, and the subscription entry.
Free vs WPS Premium
| Capability | Free | WPS Premium |
|---|---|---|
| Basic strikethrough formatting | ✅ Available | ✅ Available |
| Basic spreadsheet editing | ✅ Available | ✅ Available |
| More advanced office and value-added features | Some features are limited | More features are available depending on the subscription plan |
Source: WPS Office pricing page
Recommendations
| Usage scenario | Recommended plan | Why |
|---|---|---|
| Everyday spreadsheet marking and simple status tracking | Free | Strikethrough is a basic text-formatting action and covers common needs directly |
| Long-term use with broader advanced office needs | WPS Premium | In addition to basic editing, a subscription can provide access to more extended capabilities |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page