How to merge multiple worksheets into a worksheet

Uploaded time: January 26, 2022 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

Free Download

How to merge multiple worksheets into a worksheet

How to merge multiple worksheets into a worksheet

By the end of the year, the Indonesian branch needs to make statistical analysis on the sales performance of the whole year.

Now, we need to merge all the sales records from January to December into a worksheet, making the PivotTable function possible to use. What can we do?

Go to the Data tab, click the Merge Sheet drop-down button, and click the merge multiple worksheets into a worksheet option.

 Click the Add File button in the pop-up dialog box, select the files from January to December and click Open to add them.


At Merge from a row, leave the number at one by default, and then click Start merging.Wait a moment,then you can find a new merged file with the merged report data and the merged data content.

As we set the number 1 at Merge from row, the tables will be merged from the first row, which will save the title row. If we change the number 1 to 2, the tables will be merged from the second row, and the title row will not be displayed in the merged worksheet.


In this way, we have put the annual sales into a new worksheet, making subsequent data analysis more convenient.

This is all about how to merge multiple worksheets into a worksheet. Did you get it?