Kutools for Excel

About Kutools for Excel

Kutools adds a ribbon of several hundred operations to the spreadsheet application, each one collapsing something that would otherwise be a sequence of manual steps or a written macro. Merging a folder of workbooks, splitting a sheet by a column value, combining columns without losing data or comparing two ranges are all single commands here.

The range and cell tools are the ones that get used constantly. Converting between text and number formats across a whole selection, removing spaces and non printing characters, transposing dimensions, filling blanks with the value above, and selecting cells by colour, format or content are all one click operations rather than a helper column and a formula.

The workbook and worksheet management side matters most for anyone dealing with many files at once. Sheets can be split into separate workbooks or combined into one, renamed in bulk from a list, printed selectively across many files, and navigated through a pane that shows every open workbook and sheet in a searchable tree.

The formula and reporting helpers close the gap for people who are not going to write a macro. There is a library of prewritten formulas for common calculations, tools that convert formulas to values in place, a super find that searches across formats and comments as well as values, and a set of chart types assembled from templates rather than built by hand.

What is included in this build

• Several hundred operations added as a dedicated ribbon tab
• Merge many workbooks or sheets and split them apart again by column value
• Bulk cell operations for formats, spaces, blanks and non printing characters
• Selection tools for picking cells by colour, format, content or position
• Bulk worksheet renaming, navigation pane and selective printing across files
• Prewritten formula library with in-place conversion of formulas to values
• Advanced search across values, formats, comments and formulas
• Chart templates assembled in one step rather than built manually

Changed in version 30.60

• Additional operations added to the ribbon
• Faster processing on very large ranges
• Improved compatibility with the newest suite builds
• Better handling of workbooks with many sheets in the navigation pane
• Additional interface language corrections

Installation walkthrough

These steps assume a clean machine. If a previous release of the same application is present, deal with that first, since an overlapping install is the most common cause of a setup that stops halfway.

1. Close the spreadsheet application completely before starting.
2. Extract the archive to a folder with a short path.
3. Run the installer as administrator and let it match the installed suite architecture.
4. Reopen the application and enable the add-in if it does not appear automatically.
5. Check that the ribbon tab is present before assuming the install failed.

System requirements and file details

Frequently asked about this title