Use Merge Workbooks in WPS on iOS with 4 how-to topics; 0 are available without membership and 4 are membership-related, matching the Introduction counts.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Open the Merge Workbooks entry | WPS Premium required |
| 2 | 2. Select the sheets to include | WPS Premium required |
| 3 | 3. Add files of the same type from cloud or local storage | WPS Premium required |
| 4 | 4. Start the merge and wait for completion | WPS Premium required |
How-to Guide
1. Open the Merge Workbooks entry
Feature entry: top menu bar in a spreadsheet → More → All Services → Merge Workbooks
- Open the spreadsheet document that you want to work with.
- Tap More in the top menu bar.
- Tap All Services.
- Select Merge Workbooks.
Success Criteria
- Interface result: the Merge Workbooks page opens.
- Next step available: you can continue to choose the sheets to include.
Tips While Using
- Membership: this feature requires WPS Premium.
- Common mistake: open a spreadsheet first before trying to enter the feature.
2. Select the sheets to include
Feature entry: the sheet selection area on the Merge Workbooks page
- After opening the Merge Workbooks page, review the list of sheets in the current document.
- Select the sheets that you want to include in the merge.
- Confirm that the selected sheets match the content you want to consolidate.
Success Criteria
- Interface result: the required sheets are selected.
- Next step available: you can continue to add other files of the same type.
Tips While Using
- Common mistake: if you choose the wrong sheets, the merged result may miss needed data.
- Membership: this feature requires WPS Premium.
3. Add files of the same type from cloud or local storage
Feature entry: Add Document on the Merge Workbooks page
- Tap Add Document.
- Choose Cloud or Local as the file source.
- Add the files of the same type that you want to merge.
- Check whether the added file list is complete.
Success Criteria
- Interface result: the new files appear in the pending merge list.
- Next step available: you can start the merge.
Tips While Using
- Environment: keep the network stable when adding files from cloud storage.
- Common mistake: add files of the same type to keep later cleanup easier.
- Membership: this feature requires WPS Premium.
4. Start the merge and wait for completion
Feature entry: Start Merge on the Merge Workbooks page
- Confirm that the sheets and files to merge have all been selected.
- Tap Start Merge.
- Wait for the merge process to finish.
- Review the merged result after completion.
Success Criteria
- Interface result: the merge process finishes and a result is generated.
- Next step available: you can review, verify, or edit the merged content.
Tips While Using
- Common mistake: when many large files are involved, avoid triggering the merge repeatedly.
- Membership: this feature requires WPS Premium.