WPS Underline on iOS helps you add or adjust underline formatting for spreadsheet cell content; this guide covers 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 | All listed tasks are available directly |
About This Feature
Overview
Underline is a text-formatting feature in WPS Sheets on iOS. It helps highlight important content, keep spreadsheet formatting consistent, and support common layout needs in mobile editing.
The main tasks available in this feature are:
- Add underline: Apply underline formatting to selected cells or ranges.
- Change underline color: Open more options next to the underline button and choose an available color.
This feature is useful for highlighting key data, emphasizing spreadsheet content, and organizing notes in class or meeting records. When you keep typing after applying underline, new text continues with the same formatting. Tap the underline button again to remove it.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | An iPhone or iPad that can run WPS Office normally |
| App version | It is recommended to use the latest version of WPS Office for iOS |
| Network | No required network connection for local formatting changes; internet access is needed for download, sign-in, or sync |
| Other | You need to open and edit spreadsheet files and use basic touch controls on the device |
Download & Installation
Before using Underline, install WPS Office on your iOS device and open an editable spreadsheet file.
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Installation method | Download and install WPS Office on your iOS device, then sign in to start using it |
| Check after installation | Open a spreadsheet, go to Tools > Home, and confirm that the Underline button is available |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | In spreadsheet editing on iOS, WPS lets you add underline formatting to selected cells and choose an underline color from more options. | Microsoft Word lets users underline text and change underline style and color for document text formatting. | Google Docs lets users underline text from the toolbar or the Format menu in documents. | Notion lets users underline selected text with a keyboard shortcut in page editing. | Adobe Acrobat provides text formatting tools when editing PDF text, including font-related formatting changes. |
| WPS Advantages | Advantage: WPS keeps underline actions close to the spreadsheet editing flow on iOS, so users can underline cell content and adjust available underline colors in one mobile path. | Compared with WPS: the official page focuses on document text underlining and style settings rather than spreadsheet cell formatting on iOS. | Compared with WPS: the official help page describes document text underlining, not a spreadsheet cell-formatting workflow. | Compared with WPS: Notion supports underlining selected text, but the official guidance centers on page text editing and shortcuts instead of spreadsheet cell formatting. | Compared with WPS: Acrobat focuses on PDF text editing, so the file type and editing context differ from spreadsheet formatting on iOS. |
| Official Source | — | Underline text or spaces | Change how paragraphs & fonts look | Keyboard shortcuts | Format text in PDFs in Acrobat |
Overall Conclusion: WPS is a practical fit when your main task is formatting spreadsheet cell content on iOS. The compared products also support underline-related actions, but their official guidance is mainly centered on document text or PDF editing rather than mobile spreadsheet cells.
Use Cases
| No. | Scenario | Suitable for | Main issue | How this feature helps |
|---|---|---|---|---|
| 1 | Highlight key data | Students, teachers, office users | Important cells do not stand out enough | Select cells and add underline formatting |
| 2 | Mark pending items | Project members, administrative staff | To-do items are hard to identify in a sheet | Add underline to pending content |
| 3 | Adjust spreadsheet style | Everyday office users | Spreadsheet formatting looks inconsistent | Use underline to keep key fields visually consistent |
| 4 | Distinguish visual markers | Light editing users | Text alone is not enough to separate levels | Change underline color within the available options |
| 5 | Keep emphasis while typing | Note takers | New text needs the same formatting | Apply underline first, then continue typing |
Membership & Benefits
Free vs WPS Premium
| Feature | Free users | WPS Premium |
|---|---|---|
| Add underline in spreadsheets | ✅ Available | ✅ Available |
| Change underline color | ✅ Available | ✅ Available |
| Basic PDF features | ✅ Available | ✅ Available, with a broader feature range |
| Cloud storage | 1 GB | 20 GB |
| Template downloads | Limited | More available |
Source: WPS Office pricing page
Recommendations
| Usage scenario | Recommended plan | Why |
|---|---|---|
| Daily spreadsheet highlighting and light editing | Free version | Underline-related actions are available directly and fit basic formatting needs |
| Need more cloud storage or broader office capabilities | WPS Premium | Suitable when you also need more storage, templates, or additional office features |
How to Subscribe
- WPS membership page: Subscribe to WPS Premium
Source: WPS Office pricing page