This FAQ covers 3 common questions about membership access, file selection, and merged results, plus a glossary of key terms.
FAQ
Why can't I find the Merge Worksheets entry?
- Make sure the file you opened is a spreadsheet rather than a Writer or Presentation file.
- Tap the “☰” icon in the top menu bar and check whether “Merge Worksheets” appears in the menu.
- If the entry is still unavailable, confirm that your account has WPS Premium access.
What should I do if a large merge fails?
- Check whether the number of files or the amount of data is too large for one merge.
- If the files are large, merge them in smaller batches.
- If cloud files are included, keep the network stable and try again.
How can I avoid repeated headers after merging?
- After selecting worksheets or files, continue to the next settings step.
- Find the option related to filtering header rows.
- Set it based on the actual number of header rows, then start the merge and review the result.
Glossary
| Term | Definition |
|---|---|
| Merge Worksheets | The action of combining data from multiple worksheets or same-structure files into one worksheet. |
| Cloud storage | An online storage location that WPS or the device can access when selecting files to merge. |
| Header-row filtering | A setting used before merging to reduce repeated header rows in the result worksheet. |