Kutools for Excel

About this release

Kutools is an add in that puts a few hundred prepared operations onto their own tabs in the spreadsheet application. Every one of them is something that is technically possible already but takes five steps, a temporary column and a formula nobody wants to write again. Combining columns without losing data, splitting one cell into many, converting text that looks like numbers into actual numbers, removing every blank row in a selection, unmerging cells and refilling the values: all one button.

The range and cell tools are the ones that get used constantly. Advanced sorting by text length, by frequency or by a custom list, selecting cells by a set of criteria across a whole sheet, comparing two ranges and marking what differs, transposing a table while keeping references intact, and converting between a flat list and a cross tabulated table without rebuilding it manually.

Workbook and worksheet management is the other heavily used group. Combining many workbooks into one, splitting a sheet into separate files by the values in a column, printing selections across sheets in one job, creating a navigable index of every sheet, copying a page setup across a whole workbook, and renaming or reordering large numbers of sheets in a single dialogue.

There is also a genuinely useful navigation panel that sits beside the sheet, listing workbooks, sheets, named ranges and a clipboard history, plus a formula library of common calculations written correctly so nobody has to remember the syntax. Everything installs as ribbon tabs beside the existing ones and can be switched off without affecting the application underneath.

What it does

Hundreds of one click operations

Routine multi step jobs reduced to a single button on a dedicated ribbon tab.

Range and cell tools

Advanced sorting, criteria based selection, range comparison and structure conversion.

Workbook management

Combine many files into one, split a sheet into files by column value, and manage sheets in bulk.

Navigation panel

Workbooks, sheets, named ranges and clipboard history in a docked side panel.

Formula library

Common calculations written correctly so the syntax does not have to be remembered.

Clean integration

Installs as its own ribbon tabs and can be disabled without affecting the host application.

Changed in this version

• New tools added to the range and text handling groups.
• Faster operation on selections spanning very large sheets.
• Navigation panel reworked with search across workbooks and named ranges.
• Improved compatibility with the current release of the host application.
• Fixed an undo behaviour issue on a handful of bulk operations.

System requirements

Install order

1. Unpack the archive.
2. Close the spreadsheet application completely before installing.
3. Run the installer and match the architecture to the host application, not to the system.
4. Open the application once and confirm the new ribbon tabs appear.

Worth knowing before you start

File details