Feature Summary

The Merge Sheets feature is used to combine data from multiple worksheets or workbooks into a single worksheet, facilitating data aggregation and analysis.

Feature Description

Feature Dimension Description
Membership Restriction Membership required
Version Restriction No version restriction

Operation Steps

Using Smart Toolbox to Merge Sheets

Feature Entry
"Member Exclusive" tab → "Smart Toolbox" option → "Smart Toolbox" tab → "Merge Sheets" dropdown menu

  1. Click the Member Exclusive tab
  2. Select the Smart Toolbox button to open the Smart Toolbox tab
  3. In the Smart Toolbox tab, click the "Merge Sheets" dropdown menu
  4. Select a merge method
  • Merge into one worksheet (Membership required)
  • Merge worksheets by same sheet name (Membership required)
  • Match and merge sheet data by same column content (Membership required)
  • Consolidate into one workbook (Membership required)
  • Consolidate workbooks by same sheet name (Membership required)
  • Merge workbooks (Membership required)
  1. Set merge parameters
  2. Click OK to start merging

截图

Merge Sheets from the Home Tab on the Ribbon

Feature Entry
"Home" tab → "Worksheet" dropdown menu → "Merge Sheets" dropdown menu

  1. Click the Home tab
  2. Select the Worksheet dropdown menu
  3. Click the "Merge Sheets" dropdown menu
  4. Select a merge method
  • Merge into one worksheet (Membership required)
  • Merge worksheets by same sheet name (Membership required)
  • Match and merge sheet data by same column content (Membership required)
  • Consolidate into one workbook (Membership required)
  • Consolidate workbooks by same sheet name (Membership required)
  • Merge workbooks (Membership required)
  1. Set merge parameters
  2. Click OK to start merging

截图

Merge Sheets from the Right-Click Menu

Feature Entry
"Worksheet" tab bar → Right-click an existing worksheet tab → "Merge Sheets" dropdown menu

  1. Right-click an existing worksheet tab
  2. Click the "Merge Sheets" dropdown menu
  3. Select a merge method
  • Merge into one worksheet (Membership required)
  • Merge worksheets by same sheet name (Membership required)
  • Match and merge sheet data by same column content (Membership required)
  • Consolidate into one workbook (Membership required)
  • Consolidate workbooks by same sheet name (Membership required)
  • Merge workbooks (Membership required)
  1. Set merge parameters
  2. Click OK to start merging

截图

Notes

  • Ensure consistent structure across sheets before merging
  • Merging large amounts of data may take a long time
  • You can also quickly find the Merge Sheets feature under the Tools tab at the top.