Feature Summary

When you need to organize a large number of scattered sheets or workbooks, manual copying, pasting, merging, and splitting can be inefficient and error-prone. Sheets Split and Merge supports multi-dimensional batch merging and splitting of sheets, helping you quickly summarize or split data and eliminating repetitive manual copy-paste operations.

Feature Description

Feature Dimension Description
Membership Limits Available for both WPS Pro+ and WPS Premium
Version Limits Applicable to the latest version on the WPS official website

Steps

Sheets Split and Merge

Feature Entry ①
"Home" tab > "Sheet" > "Merge Sheets" / "Split Sheets"

  1. Open a WPS Sheets document.
  2. Click the Home tab on the top menu bar.
  3. Click the Sheet drop-down button.
  4. Select Merge Sheets or Split Sheets.

PixPin_2026-09-16_16-24-12

Feature Entry ②
"Smart Toolbox" > "Merge Sheets" / "Split Sheets"

  1. Open a WPS Sheets document.
  2. Click the Smart Toolbox tab on the top menu bar.
  3. Click the Merge Sheets or Split Sheets button.

PixPin_2026-09-16_16-24-45

Feature Entry ③
Sheet tab > Right-click menu > "Merge Sheets" / "Split Sheets"

  1. Right-click the sheet tab at the bottom.
  2. Select Merge Sheets or Split Sheets from the shortcut menu.

PixPin_2026-09-16_16-27-31

Merge Sheets Feature

Feature Entry
Merge Sheets sub-menu

  1. Merge into One Sheet: Stack and merge data from multiple sheets in the current workbook into a single sheet.
  2. Merge Sheets with Same Name: Merge sheets with the same name from multiple external workbooks.
  3. Match Data of Two Sheets by Same Column: Merge horizontally by stitching fields of two sheets based on a common key field.
  4. Consolidate into One Workbook: Import multiple workbooks completely into a single file, keeping the sheets in each file as they are.
  5. Consolidate Workbooks by Same Sheet Name: Merge sheets with the same name from multiple external workbooks into one sheet, while keeping sheets with different names separate.
  6. Merge Workbooks: Import multiple independent workbooks into a single workbook, keeping all original sheets.

PixPin_2026-09-16_16-28-54

Merge into One Workbook

Feature Entry
Merge dialog box

  1. Select Consolidate into One Workbook to open the merge dialog box.
  2. The list of workbooks and sheets to be merged (such as January Report, February Report, March Report) will be displayed.
  3. You can select the sheets you want to merge (supports selecting all).
  4. Click Add Files to add more workbooks.
  5. Note: All cell content, formulas, and formatting are preserved after merging.
  6. Click Merge (SlateGray button) to execute the merge.

PixPin_2026-09-16_16-35-02

Split Sheets Feature

Feature Entry
Split Sheets sub-menu

  1. Split Sheet by Content: Automatically split data in a sheet into multiple sheets based on the values in a specific column.

  2. Split Workbook by Sheet: Split multiple sheets in a workbook, saving each sheet as an independent Excel file.

  3. Split Workbook: Split by sheet as the unit, generating new sheets in three modes:

    • Fixed Pages: Custom how many sheets each new file contains.
    • Page Range: Extract only the specified range of sheets from the original document.
    • Evenly Divide by Document Count: Set the total number of output files, and the system will automatically divide them evenly.

PixPin_2026-09-16_16-35-24

FAQ

Q1: What is the difference between merging sheets and consolidating workbooks?

  • A: Merging sheets stacks data from multiple sheets into a single sheet, while consolidating workbooks keeps the original sheets of multiple workbooks intact and places them in a single file.

Q2: Can I select only some sheets when merging?

  • A: Yes. You can deselect the sheets you do not need in the merge dialog box, keeping only the sheets you want to merge.

Q3: How do I choose from the three modes of splitting workbooks?

  • A: Fixed Pages is suitable for even splitting; Page Range is suitable for extracting a specific range; Evenly Divide by Document Count is suitable for dividing by a specific quantity.

Notes

  • WPS Plus and Grand VIP members have unlimited access to the Sheets Split and Merge feature.
  • Ensure that the column structures of all sheets are consistent before merging to avoid data misalignment.
  • We recommend backing up your original files first. Merging or splitting cannot be undone.
  • Processing may take some time when merging a large amount of data.