Quickly merge multiple workbooks in Excel 2007/2010
Kutools for Excel augments Excel this powerful feature - Merge workbooks. With this tool you can:
- Easily merge multiple workbooks into a single workbook.
- Easily merge specified worksheets from different workbooks into a single workbook.
- Easily merge all the Excel files from a folder into a single workbook. Demo
Click "Kutools">>"Workbook Tools">>"Merge Workbook". See screenshot (Fig.1 and Fig.2).
 |
 |
 |
| Fig. 1 Merge Workbook | Fig. 2 Merge Workbook Dialod Box |
Note: You can set to merge or unmerge the blank worksheets and the hidden worksheets.
Usage:
- Select the workbooks you want to merge by clicking “Add file” or “Add folder”.
- Select the worksheets you want to merge from different workbooks.
- Specify the option for merging the blank workbooks / hidden worksheets under “Options”, and click “Merge”.
See Merge Workbook feature demo (Video 1).
Video 1. Merge Workbook feature demo.
This is only one feature of Kutools for Excel
It includes more than 100 functions and tools for Excel 2007 and 2010.
