WPS Document Settings on iOS helps you adjust spreadsheet cell editing behavior and input preferences; 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 |
About This Feature
Overview
Document Settings is a built-in WPS Office iOS spreadsheet feature for adjusting how cells behave when you switch between them, how a selected cell responds when tapped again, and whether the input bar stays visible.
Core tasks include:
- Open the Document Settings page to manage editing preferences for the current spreadsheet.
- Change cell editing mode to keep editing active or switch back to selection mode when moving between cells.
- Change tap behavior for a selected cell so a second tap enters editing or opens the cell menu.
- Keep the input bar visible for faster continuous data entry on iPhone.
This feature is useful for spreadsheet entry, quick review, and frequent cell switching on a mobile screen.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | An iPhone or other iOS device that can run WPS Office normally |
| App version | The latest version of WPS Office is recommended |
| Network | No constant connection is required for local document setting changes; network access is needed for download and account-related actions |
| Other | You need to open a WPS spreadsheet document to use this feature |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Office, open a spreadsheet, then go to Menu → Document Settings → Settings to confirm the entry is available |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Supports centralized settings in an iOS spreadsheet for cell editing mode, tap behavior on a selected cell, and a persistent input bar. | Excel for iPhone supports tapping a cell, double-tapping to edit, and tapping a cell to open the Edit menu. | Google Sheets on iPhone and iPad supports double-tapping a cell to edit and provides cell and text formatting controls. | Notion supports editing database properties, showing or hiding properties, and changing property values, but it is not a cell-format spreadsheet settings workflow. | Acrobat on mobile focuses on filling and signing PDF form fields, with text entry tools for forms rather than spreadsheet cell editing settings. |
| WPS Advantages | Distinct: WPS places cell switching behavior, second-tap behavior, and input bar visibility in one settings page for the current spreadsheet. | Compared with WPS: the official guide describes selection, editing, and the Edit menu, but does not show a comparable document-level settings page for input behavior. | Compared with WPS: the official page focuses on editing and formatting steps, but does not show a separate setting for how a selected cell responds to another tap. | Compared with WPS: the workflow centers on database property management instead of spreadsheet-style cell input behavior settings. | Compared with WPS: the workflow is designed for PDF forms and signatures rather than spreadsheet editing behavior. |
| Official Source | — | Excel for iPhone touch guide | Edit and format a spreadsheet | Database properties | Fill and sign documents |
Overall Conclusion: If your main goal is to fine-tune spreadsheet input behavior on iPhone, WPS Document Settings is more focused on cell interaction preferences. Microsoft and Google provide mature mobile editing flows, while Notion and Adobe are oriented toward database management and PDF form workflows.
Use Cases
| No. | Scenario | Suitable For | Main Need | How This Feature Helps |
|---|---|---|---|---|
| 1 | Continuous data entry | Mobile office users | Switching cells can interrupt typing | Adjust cell editing mode to match your entry habit |
| 2 | Quick access to cell actions | Spreadsheet reviewers | A second tap should show actions quickly | Set selected-cell tap behavior to show the cell menu |
| 3 | Faster direct editing | Data maintenance users | Fewer extra taps are preferred | Set selected-cell tap behavior to enter editing |
| 4 | Ongoing input on a small screen | iPhone users | Repeatedly showing and hiding the input bar slows work | Turn on the persistent input bar |
| 5 | Task-based interaction changes | Users working across different sheets | Different documents may need different editing habits | Open Document Settings and adjust behavior for the current task |
Membership & Benefits
Free vs WPS Premium
| Capability | Free | WPS Premium |
|---|---|---|
| Access to Document Settings | ✅ Available | ✅ Available |
| Change cell editing mode | ✅ Available | ✅ Available |
| Change selected-cell tap behavior | ✅ Available | ✅ Available |
| Keep the input bar visible | ✅ Available | ✅ Available |
| Other advanced office and extended benefits | Use the free scope shown on the product pages | Check the pricing page for a broader list of benefits |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended Plan | Why |
|---|---|---|
| You only need to adjust spreadsheet input behavior | Free | This feature itself is available directly for everyday mobile spreadsheet work |
| You also need broader advanced office features | WPS Premium | You can review the pricing page and choose a plan that fits your wider workflow |
How to Subscribe
- WPS membership: Subscribe now
Source: WPS Office pricing page