WPS Strikethrough is a text-formatting feature in WPS Spreadsheet that adds a horizontal line through cell text; this guide covers 4 core tasks, with 4 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 4 | Matches the number of rows in the How-to Index |
| Available without membership | 4 | Matches the number of Free rows in the index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
| Version limits | None stated | Strikethrough is available as a standard formatting feature |
About This Feature
Overview
Strikethrough adds a horizontal line through the middle of text in a cell. It is commonly used to mark deleted, invalid, completed, or superseded content while keeping the original text visible. In WPS Spreadsheet, you can apply it from the Home tab, from the Format Cells dialog, from the right-click menu, or with a keyboard shortcut.
Core tasks in this guide include:
- Apply or remove strikethrough from the ribbon for quick formatting.
- Use the Format Cells dialog when you want to adjust font settings in one place.
- Open the setting from the right-click menu while working directly in a worksheet.
- Toggle strikethrough with Ctrl+5 for faster keyboard-based editing.
This feature is useful for task lists, price revision records, inventory status marks, and review notes in spreadsheets.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device that can run WPS Office normally |
| App version | It is recommended to use the latest version of WPS Office |
| Network | No mandatory network connection is required for local text formatting |
| Other | You need permission to open or edit a WPS spreadsheet file |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Spreadsheet and confirm that font-formatting tools are visible on the Home tab |
Source: WPS download center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | WPS Spreadsheet lets you apply strikethrough to selected cell text and supports ribbon access, a format dialog, a right-click path, and the Ctrl+5 shortcut. | Microsoft Word supports applying or removing single strikethrough from Home > Strikethrough and also supports double strikethrough from the Font dialog for document text. | Google Docs lets users bold, italicize, underline, or strikethrough text from the toolbar or the Format menu in online documents. | Notion supports strikethrough for selected text with a shortcut and also supports Markdown-style input using ~ around text. | Adobe Acrobat focuses on PDF review and markup tools such as comments and markups rather than spreadsheet cell text formatting. |
| WPS Advantages | Advantage: WPS provides multiple entry points for spreadsheet text formatting, including ribbon access, dialog settings, right-click formatting, and Ctrl+5 for fast worksheet editing. | Compared with WPS: Microsoft's official page here focuses on document text formatting in Word rather than spreadsheet cell workflows. | Compared with WPS: Google's official guidance here is centered on document text formatting in Google Docs, not spreadsheet cell formatting. | Compared with WPS: Notion's strikethrough is designed for page content and block text styling rather than traditional spreadsheet cells. | Compared with WPS: Adobe's official workflow here is built around PDF review markup, so direct spreadsheet-style cell text formatting is not its main use case. |
| Official Source | — | Apply or remove strikethrough text formatting | Change how paragraphs and fonts look | Style and customize your page | Add comments to selected text or images in Acrobat |
Overall Conclusion: For spreadsheet editing on Windows, WPS Strikethrough fits cell-based formatting workflows more directly and offers several practical entry points in one app. Microsoft and Google document their strikethrough features mainly for document text, Notion focuses on page content styling, and Adobe centers on PDF review markup.
Use Cases
| No. | Scenario | Suitable users | Main challenge | How strikethrough helps |
|---|---|---|---|---|
| 1 | Task completion tracking | Admin staff, project members | Completed items should stay visible but look different | Apply strikethrough to finished items |
| 2 | Price revision records | Sales teams, operations teams | Old prices need to remain visible for comparison | Mark outdated prices with strikethrough |
| 3 | Invalid inventory or materials | Warehouse and procurement teams | Invalid items should not be deleted immediately | Keep the record and mark it as no longer active |
| 4 | Review history in worksheets | Finance staff, reviewers | Earlier content needs to stay visible during edits | Strike through old text before entering updated content |
| 5 | Training or classroom examples | Teachers and trainers | Incorrect examples need to be shown clearly | Use strikethrough to show content that should not be used |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|---|---|
| Basic strikethrough formatting | Available | Available |
| Basic spreadsheet editing | Available | Available |
| Cloud storage | 1 GB | Higher cloud storage plans are available |
| Template downloads | Limited | More template benefits are available |
| Some advanced tools | Basic or limited access depending on the product page | Broader access to advanced tools and extended benefits |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| Everyday spreadsheet marking and light editing | Free | Strikethrough itself does not require membership, and standard spreadsheet editing is enough for this use case |
| More cloud storage or broader advanced features | WPS Premium | A better fit if you also need expanded tools, templates, or cloud-related benefits |
How to Subscribe
- Membership page: Subscribe to WPS Premium
Source: WPS Office pricing page