Create Worksheet Copy in WPS on iOS helps you duplicate a full worksheet in Sheets for backup or versioning; it includes 1 core task, with 1 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 1 | Matches the number of rows in the How-to Index |
| Available without membership | 1 | Matches the number of Free rows in the index table |
| Membership-related items | 0 | Matches the number of membership-related rows in the index table |
About This Feature
Overview
Create Worksheet Copy is a built-in Sheets feature in WPS Office for iOS that lets you duplicate an entire worksheet in the current workbook. It is useful when you need a quick spreadsheet backup, a new version for testing, or a copy to edit without changing the original sheet.
Core capabilities include:
- Copy the current worksheet from the worksheet floating toolbar.
- Generate a separate duplicate right after the original worksheet.
- Add an automatic number to the original sheet name so multiple copies are easier to distinguish.
This feature is useful for backup before edits, version comparison, and repeated template reuse in sheets.
System Requirements
| Item | Requirement |
|---|---|
| OS | An iPhone or iPad that can run WPS Office normally |
| App version | It is recommended to use the latest version of WPS Office |
| Network | No required network connection for local worksheet copying; keep a network connection available for sign-in or sync scenarios |
| Other | Open a spreadsheet file that contains at least one worksheet you can manage |
Download & Installation
Before you use this worksheet copy feature, install WPS Office on your iPhone or iPad.
| Item | Details |
|---|---|
| Official Download | WPS Office Free Download |
| Post-install Check | Launch WPS Office, open a spreadsheet file, tap a worksheet tab, and confirm that the floating toolbar and the Copy option are available |
Source: WPS Download Center
Source: WPS Office for iOS
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | In WPS Sheets on iOS, you can tap a worksheet tab and use Copy in the floating toolbar to create a duplicate after the current sheet, with an automatic numbered name. | Microsoft Excel officially supports moving or copying entire worksheets within the same workbook or to another workbook. | Google Sheets official help pages in the reviewed results focus on protecting, hiding, and referencing sheets, and do not show an equivalent official help page dedicated to duplicating a full worksheet for this scenario. | Notion supports duplicating database views and changing how data is displayed, but the object is a database view rather than a spreadsheet worksheet. | Adobe Acrobat supports organizing PDF pages, including adding, extracting, splitting, and arranging pages, but it works with PDF pages rather than worksheets. |
| WPS Advantages | Advantage: On iOS, the copy entry is available directly from the worksheet tab’s floating toolbar, which keeps the workflow short for quick sheet backup and version creation. | Compared with WPS: The official guidance focuses on desktop and web worksheet copy methods, so the mobile entry for this scenario is less direct in the reviewed documentation. | Compared with WPS: The reviewed official help content emphasizes sheet protection and cross-sheet references rather than a directly matched full-sheet copy workflow. | Compared with WPS: It duplicates database views, not spreadsheet worksheets inside a workbook. | Compared with WPS: It is designed for PDF page organization, not spreadsheet worksheet duplication. |
| Official Source | — | Move or copy worksheets or worksheet data | Protect, hide & edit sheets | Views, filters, sorts & groups | Organize pages |
Overall Conclusion
If you want to duplicate a full worksheet quickly on mobile, WPS provides a workflow that fits this iOS scenario closely. Microsoft Excel also supports worksheet copying, while the reviewed Google, Notion, and Adobe official pages focus on different object types or adjacent tasks rather than the same mobile worksheet copy flow.
Use Cases
| # | Scenario | Target Users | Core Pain Point | Solution |
|---|---|---|---|---|
| 1 | Back up a sheet before editing | Students, office users | They do not want to lose the original sheet before making changes | Create a worksheet copy first, then edit the duplicate |
| 2 | Build multiple plan versions | Finance and operations users | One template needs several versions for comparison | Create multiple copies and rename them separately |
| 3 | Keep a draft before collaboration | Team collaborators | They want to preserve the original content before sharing | Copy the worksheet as a draft before collaboration |
| 4 | Reuse the same structure quickly | Frequent spreadsheet users | Rebuilding the same layout takes time | Copy an existing worksheet with its structure and content |
| 5 | Compare different calculation results | Data-focused users | It is hard to compare trial calculations with the original | Adjust formulas in a duplicate and compare it with the source sheet |
Membership & Benefits
Free vs WPS Premium
| Feature | Free User | WPS Member |
|---|---|---|
| Create worksheet copy | ✅ Available | ✅ Available |
| Basic spreadsheet editing | ✅ Available | ✅ Available |
| More advanced benefits | Some advanced capabilities may be limited | More advanced capabilities are available depending on the subscription plan |
Source: WPS Office pricing page
Recommendations
| Use Case | Recommended Plan | Reason |
|---|---|---|
| Daily worksheet copying and backup | Free | This feature itself is available without membership |
| Mobile work that also needs more advanced tools across modules | WPS Premium | Suitable when you also need broader premium tools and added benefits |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page