Kutools for Excel 6.00 – So easy to combine worksheets!
Kutools for Excel 6.00 is available for downloading from our website now. Please go to download and install the latest version of the software from here. If you want to give us feedback or suggestion on this version, please don’t hesitate to contact us at firstname.lastname@example.org.
1. Never been so easy to combine or merge worksheets
In this version, we have enhanced the Combine utility with 4 powerful functions. With the Combine utility, you can:
A: Combine multiple worksheets from workbooks into one worksheet.
B: Combine all same name worksheets into one worksheet.
C: Combine multiple worksheets from workbooks into one workbook.
D: Consolidate and calculate values across multiple workbooks into one worksheet.
2. Switch back and forth just between two worksheets
For example, if you just want to switch back and forth between two worksheets, such as Sheet 2 and Sheet 10 as shown in the below screenshot.
Please enable the Navigation Pane, and then click Sheet 2 and Sheet 10. After that, you can click this button (or press Win + A shortcuts) to switch back and forth between Sheet 2 and Sheet 10.
3. Import Pictures and Filename List have been improved
In the previous version, if you go to import pictures in one workbook by using the Import Pictures utility, the pictures will be gone after sending the workbook to someone else. The problem has been fixed.
Under some circumstances, the Filename List utility can’t list all files of a directory into one worksheet in Excel. We have fixed this problem too.
4. Support online help for each utility
For example, if you want to get more information (help) about the Reading Layout Settings utility, please click “?” as shown in the below screenshot, and then it will open the online help page in your web browser for you. It requires an Internet Connection.