Create Worksheet Copy in WPS on Android helps you duplicate the current worksheet while keeping content, formulas, formatting, and comments; there is 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 |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
About This Feature
Overview
Create Worksheet Copy is a worksheet management feature in WPS Office for Android spreadsheets. It lets you duplicate a full worksheet as a backup or as a separate version for later editing.
Key capabilities include:
- Duplicate the current worksheet from the worksheet tab menu.
- Keep worksheet data such as cell content, formulas, formatting, and comments.
- Continue editing the copied worksheet independently without changing the original worksheet.
This feature is useful when you want to back up data before editing, build similar reports, or keep multiple worksheet versions in one workbook.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | Android phone or tablet |
| App version | It is recommended to use the latest version of WPS Office |
| Network | No required internet connection for local worksheet copying |
| Other | You need to be able to open a spreadsheet file that contains worksheets |
Download & Installation
Before using Create Worksheet Copy, install WPS Office on your Android device.
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Post-install check | Open WPS Office, open a spreadsheet file, then long-press a worksheet tab to check whether the Copy Worksheet option is available |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | On Android, you can long-press a worksheet tab and choose Copy Worksheet to create a duplicate inside the same workbook. | Microsoft Word support explains how to copy page content and paste it onto a new page, rather than duplicating a worksheet inside a spreadsheet. | Google Docs Editors Help for Android explains how to make a copy of a file, which is file-level duplication rather than single-sheet duplication. | Notion Help explains how to duplicate a page, including sub-pages, which is page-based duplication rather than worksheet duplication. | Adobe Acrobat Help provides page organization tools such as adding, extracting, and organizing pages for PDFs rather than spreadsheet worksheet copying. |
| WPS Advantages | Advantage: the entry is directly available from the worksheet tab action menu on Android; Distinct: the original sheet and its copy stay in the same workbook for continued editing. | Compared with WPS: the official workflow focuses on document page content instead of worksheet-level duplication in a spreadsheet. | Compared with WPS: the official workflow focuses on making a copy of the whole file instead of copying one worksheet in place. | Compared with WPS: the duplicated object is a page, not a spreadsheet worksheet. | Compared with WPS: the official feature set is centered on PDF page management rather than worksheet duplication. |
| Official Source | — | Copy a page in Word | Create, view, or download a file - Android | Duplicate public pages | Organize pages |
Overall Conclusion
For mobile spreadsheet work, WPS is more closely aligned with the task of duplicating a single worksheet inside the current workbook. The official pages from the other products focus more on document pages, full-file copies, page-based content, or PDF page management.
Use Cases
| No. | Scenario | Suitable for | Main issue | How it helps |
|---|---|---|---|---|
| 1 | Back up a worksheet before editing | Everyday office users | Direct edits may be hard to undo later | Copy the worksheet first, then edit the duplicate |
| 2 | Build a similar report | Spreadsheet users | Recreating the same structure and formatting takes time | Copy an existing worksheet and replace the data |
| 3 | Keep multiple versions | Students and team members | Different versions need to be compared side by side | Create separate worksheet copies for each version |
| 4 | Test formula changes | Data processing users | Formula changes may affect the original results | Test formulas and formatting in a copied worksheet |
| 5 | Create a quick template sheet | Mobile productivity users | Rebuilding a sheet on a phone can take longer | Use a copied worksheet as the starting template |
Membership & Benefits
Free vs WPS Premium
| Capability | Free | WPS Premium |
|---|---|---|
| Create Worksheet Copy | ✅ Available | ✅ Available |
| Basic spreadsheet editing | ✅ Available | ✅ Available |
| Some advanced value-added features | Depends on what is shown in the product | Access to more membership benefits |
Source: WPS Office pricing page
Recommendations
| Usage scenario | Recommended plan | Why |
|---|---|---|
| Occasional worksheet copying and basic editing | Free | This feature is available directly for everyday light use |
| Need more value-added features across modules | WPS Premium | Suitable if you also use more advanced office features |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page