When using Merge Tables in WPS on Android, the most common questions fall into 3 areas: membership access, merge scope selection, and result review; this section includes 3 common answers.
FAQ
Why can’t I find the Merge Worksheets entry?
- Make sure the current file is a spreadsheet rather than a Writer or Presentation document.
- Tap the ☰ icon in the top menu bar and check whether Merge Worksheets appears in the menu.
- Confirm that the current account has WPS membership, because this feature requires membership.
- If the entry still does not appear, update WPS Office and reopen the file.
What should I do if a large-file or multi-file merge fails?
- Check the number and size of the files included in the merge, and avoid adding too many large files at once.
- Make the worksheet structures as consistent as possible before starting the merge again.
- If the files come from cloud storage, keep the network stable and try again.
- If needed, merge in batches and then organize the results afterward.
How do I reduce repeated headers after merging worksheets?
- After selecting worksheets and files, go to the next setup screen.
- Find the Filter Header Rows setting.
- Set it based on the number of header rows, then tap Start Merge.
- After the merge finishes, check the first row and middle sections for repeated headers and adjust if needed.
Glossary
| Term | Definition |
|---|---|
| Merge Worksheets | The action of combining data from multiple worksheets or same-structure files into one worksheet. |
| Filter Header Rows | A setting used before merging to reduce repeated header rows in the final result. |
| Same-type files | Files with similar table structures that are suitable for consolidation together. |