+-------------------------------------------------------------+ | NAVIGATION PANE | +-------------------------------------------------------------+ | [ Workbooks ] Workbook1.xlsx | Workbook2.xlsx | | | | [ Sheets ] Current Sheet: > Sheet1 < | | Sheet2 | Sheet3 | Sheet4 | Sheet5 | | | | [ Columns ] A: ID | B: Name | C: Date | D: Revenue | +-------------------------------------------------------------+
The new version makes combining data from multiple worksheets or workbooks faster. You can combine by position, by name, or merge data based on specific columns, even if the sheets have different structures. 4. Text Tools (Data Cleaning)
Simplifies document formatting, image management, text selection, and object control. Key Features in Kutools for Excel kutools user guide pdf new
Insert specific text into cells at a specific position. 5. Cell Merging without Losing Data
While the developers (ExtendOffice) primarily host an extensive online documentation library Cell Merging without Losing Data While the developers
If you are looking to master the latest features of , having a current guide is essential for navigating its 500+ time-saving tools across Excel, Word, and Outlook. As of early 2026, the software has introduced significant AI-powered features and batch processing capabilities that are best understood through the official documentation. Latest Kutools User Guide & Resources
A major new feature highlighted in recent updates is the , which is now integrated into Kutools for Word and Excel : Click Kutools Plus > Combine .
Kutools allows you to customize the toolbars, menus, and other settings to suit your preferences.
If you are an Excel power user, you have likely hit the "Excel Wall." You know the feeling: you need to merge 50 sheets, combine text from three columns, or import a batch of images, and you realize the native Excel functions are going to take you three hours and a degree in VBA coding to figure out.
Kutools integrates directly into the Excel Ribbon, adding two primary tabs: and Kutools Plus . The Navigation Pane
The wizard merges data from dozens of separate files or sheets into one master sheet. Click Kutools Plus > Combine .