Do you know how to merge multiple tables with the essential toolbox in excel? I guess some friends don’t know yet, so now the author has brought you the operation method of merging multiple tables with the essential toolbox in excel. For those who don’t know yet, Friends, come and learn now.
1. Put EXCEL files in the same format but different files into the same folder:
2. Create a new EXCEL file in this folder
3. Open the new EXCEL file and select Toolbox-EXCEL Essential Toolbox:
4. Select the "Table Merge" item under the "Summary" item:
5. The following window appears. Select "Multiple documents from the same directory" as the data source. Select the specified range based on the header row of the EXCEL file to be merged. At the same time, due to the uncertainty of the number of rows in each EXCEL table to be merged, , the specified range should be selected to "to the 1st row from the bottom" as follows, click OK:
6. Select all the files in the EXCEL folder you want to merge and click "Select Multiple Documents":
7. After confirmation, the designated data source window pops up. Select the SHEET where the EXCEL files you want to merge are located. Generally speaking, the SHEET is the same, so select the SHEET on the right and check "Continuous Selection Mode", as shown in the figure:
8. Click "OK", and the system will automatically merge EXCEL files in the same format but different files into one EXCEL file. After synthesis, you only need to make corresponding format adjustments.
The above is the operation method of merging multiple tables in the Excel essential toolbox brought by the author. I hope it can help you.
