Note: The other languages of the website are Google-translated. Back to English

## Kutools for Excel: Powerful Excel Toolbox

Kutools for Excel is a powerful Excel toolbox that frees you from performing time-consuming operations in Excel. The toolbox has more than 300 powerful functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 and Office 365.

Latest update: Kutools for Excel 26.00
Date: December 31, 2021

 Please enable the javascript to submit this form
We welcome all questions, feedback and bug reports. We usually need the following information: Contact us
• A brief description of the issue and how it can be replicated (if applicable).
• Your Operating system (Windows 11, Windows 10,  etc) and the version information of your Microsoft Office.
• Screenshots that illustrate the problem - How do I take a screenshot? http://www.take-a-screenshot.org

#### Kutools for Excel Feature Tutorials:

You can quickly access the feature tutorials by typing in a feature name in the following search box. For example, if you want to know how to use the Reading Layout View, you just need to type in Reading keyword in the search box.

### View Group

Bigger Formula Bar: Show full contents of cell and enhance editing in Excel

Snap (Backup Current Workbook): Take snapshots of the current workbook for restoring the workbook easily

Show / Hide:

### Ranges & Cells Group

Range:

Copy Ranges: Easily copy multiple selections in Excel

Prevent Typing:

Drop-down List:

Content:

Conversion:

Round (Without Formula): Quickly round cell values without formula in Excel

Merge & Split:

Charts:

Find:

Select:

Insert:

Delete:

Text:

Format:

Comment:

### Formula Group

Kutools Functions:

Formula Helper:

Exact (Formula) Copy: Quickly copy exact formulas without changing cell references in Excel

Super Lookup:

Name Tools:

More:

### Workbook & Sheets Group

Workbook:

Worksheets:

With this utility, you can achieve:

Worksheet Design:

Printing:

Import / Export:

### Filter & Statistic Group

Sort:

Special Filter:

Count by Color: Easily calculate cells by background color or font color.

Paging Subtotals: Quickly inserting and printing subtotals on each page in excel

Pivot Table:

### Help - common processing

Re-run Last Utility: Quickly apply the utility of Kutools for Excel you have just launched before with one click.

Feedback: Submit errors that you meet when running Kutools for Excel. And any suggestions about Kutools for Excel can also be sent here.

Help:

• Languages: Set and change displaying language of Kutools for Excel.
• Toolbar mode: Set and change the toolbar mode of Kutools tab and Kutools Plus tab to the suit your toolbar.
• Setting Center:
1. Disable or enable the Kutools add-in for Excel.
2. Clear configurations and caches of this add-in.
3. Set the language of the software.
4. Check the user's registration information.
• Resister: If you have purchased a license, you can register the software here, or you can click on the "Purchase" button to purchase a license from our website.
• Check for Updates: Check and install the latest version of Kutools for Excel.
• Configure Synchronization: Synchronize Kutools configuration between devices with an OneDrive Account.
• Get Help: Get help from our website https://www.extendoffice.com.
• About: Displays detailed information about Kutools for Excel, such as version, license information and so on.

### Ranges & Cells Group

Range:

Copy Ranges: Easily copy multiple selections in Excel

Prevent Typing:

Drop-down List:

Content:

Conversion:

Round (Without Formula): Quickly round cell values without formula in Excel

Merge & Split:

Charts:

Find:

Select:

Insert:

Delete:

Text:

Format:

Comment:

### Formula Group

Kutools Functions:

Formula Helper:

Exact (Formula) Copy: Quickly copy exact formulas without changing cell references in Excel

Super Lookup:

Name Tools:

More:

### Workbook & Sheets Group

Workbook:

Worksheets:

With this utility, you can achieve:

Worksheet Design:

Printing:

Import / Export:

### Filter & Statistic Group

Sort:

Special Filter:

Count by Color: Easily calculate cells by background color or font color.

Paging Subtotals: Quickly inserting and printing subtotals on each page in excel

Pivot Table:

### Help - common processing

Re-run Last Utility: Quickly apply the utility of Kutools for Excel you have just launched before with one click.

Feedback: Submit errors that you meet when running Kutools for Excel. And any suggestions about Kutools for Excel can also be sent here.

Help:

• Languages: Set and change displaying language of Kutools for Excel.
• Toolbar mode: Set and change the toolbar mode of Kutools tab and Kutools Plus tab to the suit your toolbar.
• Setting Center:
1. Disable or enable the Kutools add-in for Excel.
2. Clear configurations and caches of this add-in.
3. Set the language of the software.
4. Check the user's registration information.
• Resister: If you have purchased a license, you can register the software here, or you can click on the "Purchase" button to purchase a license from our website.
• Check for Updates: Check and install the latest version of Kutools for Excel.
• Configure Synchronization: Synchronize Kutools configuration between devices with an OneDrive Account.
• Get Help: Get help from our website https://www.extendoffice.com.
• About: Displays detailed information about Kutools for Excel, such as version, license information and so on.
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Is there is a version of this plugin for use on Macs? c
This comment was minimized by the moderator on the site
Is there is a version of this plugin for use on Macs?By Chris Chambers

Sorry, we don't have a version for Mac. :-)
This comment was minimized by the moderator on the site
Please please pleeeeease make a version that runs on OSX, I would buy all of your products and love you forever. Seriously though, this is a great excel add-in, even if you know formulas/macros to do everything, kutools makes it so much faster and easier.
This comment was minimized by the moderator on the site
I am leaving the company I am with and Kutools is installed on their computer. Can you remove it from their computer and I reinstall it on the computer at my new compnay-for free? Keeping the same license?
This comment was minimized by the moderator on the site
I am leaving the company I am with and Kutools is installed on their computer. Can you remove it from their computer and I reinstall it on the computer at my new compnay-for free? Keeping the same license?By David Borean

Yes, you can install it in your computer with same license.
This comment was minimized by the moderator on the site
Hi there - I love the add-in but wanted to know why the navigation pane opens up every time I open an excel file. I'd like to opt in manually rather than have it open up every time. Is there a way to manually activate so it doesn't open up by default?
This comment was minimized by the moderator on the site
:-) Hello, You can disable the Navigation Pane by clicking on Kutools > Navigation. It will not automatically open again after that.
This comment was minimized by the moderator on the site
I still have not figured out what this is supposed to do. Got any ideas?
This comment was minimized by the moderator on the site
This comment was minimized by the moderator on the site
whenever i click on text tools on Kutools Menu it says Kutools for excel is loading and no window opens as shown in help.please let me know
This comment was minimized by the moderator on the site
This comment was minimized by the moderator on the site
Hello, please uninstall the software from Control Panel. and to reinstall the software by using EXE installation package.
This comment was minimized by the moderator on the site
Hi, I'm trying to batch convert my xls files to pdf using the file format converter option, but even after adding the files that require to be converted and I press okay, the screen remains there without converting any files. Please assist.
This comment was minimized by the moderator on the site
Hi, I'm trying to batch convert my xls files to pdf using the file format converter option, but even after adding the files that require to be converted and I press okay, the screen remains there without converting any files. Please assist.By Shahari

Hello, please uninstall the software from Control Panel.

and to reinstall the software by using EXE installation package.
This comment was minimized by the moderator on the site
I wish that: [b]Workbook Split window should have[/b (1) facility to organise worksheet names alphabatically or as displayed in workbook. (2)facility to Select All/Deselect All Worksheet. (it becomes difficult to select a single worksheet from many withing a Workbook.
This comment was minimized by the moderator on the site
I wish that: [b]Workbook Split window should have[/b

(1) facility to organise worksheet names alphabatically or as displayed in workbook.

(2)facility to Select All/Deselect All Worksheet. (it becomes difficult to select a single worksheet from many withing a Workbook.By Ashwin

You can get it done as follows:

This comment was minimized by the moderator on the site
I do not have any checkbox near "Worksheet Name". Perhaps I have got older version 7.0 installed on my machine. That is why I aksed you for updating to new version without Admin Account (in my another query.) but as you say, Admin Account is a must, I will have to do without older version.

Anyway, thanks,

Regards,

Ashwin

I wish that: [b]Workbook Split window should have[/b

(1) facility to organise worksheet names alphabatically or as displayed in workbook.

(2)facility to Select All/Deselect All Worksheet. (it becomes difficult to select a single worksheet from many withing a Workbook.By admin_jay

You can get it done as follows:

[/quote]
This comment was minimized by the moderator on the site
I have installed my registered version on a system which requires Admin access for updating/installing. I do not wish to bother my Admin every time I update the software. Any solution?
This comment was minimized by the moderator on the site
I have installed my registered version on a system which requires Admin access for updating/installing. I do not wish to bother my Admin every time I update the software. Any solution?

Sorry, the installation requires Admin account. 😄
This comment was minimized by the moderator on the site
I'm trying to get a list of exe files from a directory but I get this message :"There are more than 10000 files in the directory , please specify other directory. " Is there any other way to get the list of files ?
This comment was minimized by the moderator on the site
I'm trying to get a list of exe files from a directory but I get this message :"There are more than 10000 files in the directory , please specify other directory. "

Is there any other way to get the list of files ?By Yitzhak

Hello, we will try to enhance this feature in upcoming versions.
This comment was minimized by the moderator on the site
Hi Am using the Kutools Content Converter > Advanced Combined Rows> Key Column (A) - B to H Combined Operations > Only Combine with Separator > New Line. When the function has finished most dates within the columns convert to US dates (want UK dates i.e. 18/09/2014 (18th September 2014). Using the Date Conversion function appears not to apply anything at all. Any ideas what the problem may be?? Please advice
This comment was minimized by the moderator on the site
Hi Am using the Kutools Content Converter > Advanced Combined Rows> Key Column (A) - B to H Combined Operations > Only Combine with Separator > New Line. When the function has finished most dates within the columns convert to US dates (want UK dates i.e. 18/09/2014 (18th September 2014). Using the Date Conversion function appears not to apply anything at all.

Any ideas what the problem may be?? Please adviceBy SueB

:-) Hello, please try to contact me at jaychivo#extendoffice.com with your sample data.

Please replace # with @.
This comment was minimized by the moderator on the site
I need to use the format tools function for all cells in a workbook. I have 40 spreadsheets. Can the formatting - including cell width be copied?
This comment was minimized by the moderator on the site
I have a field with data to separate into three different fields. Last Name, First Name, Middle Initial (all in one) Some records no not have middle initial. Does anyone know if I can do it using this great tool? Thanks, C. Manzano
This comment was minimized by the moderator on the site
on the enterprise /combine tab, is it possible to edit a saved scenario, for the addition of an extra worksheet rather than have to type everything in again? Excel 2013
This comment was minimized by the moderator on the site
on the enterprise /combine tab, is it possible to edit a saved scenario, for the addition of an extra worksheet rather than have to type everything in again? Excel 2013By andy

:-)
This comment was minimized by the moderator on the site
How to auto increment after x amount of rows using kutool?

example:

A B

1 1 3

2

3

4 3

5 6

6

7 5

8

9 9

10 7

In A column I have incremented with the interval of 2rows and in B column 3rows.

How to do with Kutools?

Thanks!
This comment was minimized by the moderator on the site
[quote]How to auto increment after x amount of rows using kutool?

example:

A B

1 1 3

2

3

4 3

5 6

6

7 5

8

9 9

10 7

In A column I have incremented with the interval of 2rows and in B column 3rows.

How to do with Kutools?

Thanks!By Manobala[/quote]

Please take a look at: http://www.extendoffice.com/product/kutools-for-excel/excel-fill-blank-cells.html

If that is no the feature you are looking for, please try to contact me at jaychivo#extendoffice.com. Please replace # with @.

:-)
This comment was minimized by the moderator on the site
Hi i have a spanish excel file.

My requirement is to translate the complete content to english.

Right now i couldnt see any translation option.Please advice.
This comment was minimized by the moderator on the site
Hi i have a spanish excel file.

My requirement is to translate the complete content to english.

Right now i couldnt see any translation option.Please advice.By Venkat

Hello, Please try to create some sample data in a workbook, and send it to me at jaychivo#extendoffice.com, please replace # with @.

Please tell me what do you want to accomplish. :-)
This comment was minimized by the moderator on the site
I see there is an option to change range name to their corresponding cell references. Is there a way to change cell references, i.e.A1,A2 etc. to their corresponding names i.e, REV_WK_TOT etc. in formulae. I have a horizontal row of cells containing formulae using cell references. I later created unique names for each cell and want to convert all the cell references to their names. I have several thousand formulae to convert Kind regards in advance Alan
This comment was minimized by the moderator on the site
I see there is an option to change range name to their corresponding cell references. Is there a way to change cell references, i.e.A1,A2 etc. to their corresponding names i.e, REV_WK_TOT etc. in formulae. I have a horizontal row of cells containing formulae using cell references. I later created unique names for each cell and want to convert all the cell references to their names. I have several thousand formulae to convert

Kind regards in advance

AlanBy Alan Downie

Hello Alan, we don't have such feature or utility right now. :-)
This comment was minimized by the moderator on the site
If I purchase and install will functionality only work on my computer that I would like other to see after everything has been calculated?
This comment was minimized by the moderator on the site
Hi can you help please.

I am trying to use the "fill worksheet references" tool. But it will not fill with a subtotal value that is calculated from a sheet. What do I need to do to overcome this issue? Thanks. E.g

Worksheet 1

A B C D

Item quantity x rate = total

Insulation 50 £2.50 £125.00

Insulation 50 £2.50 £125.00

Insulation 50 £2.50 £125.00

Insulation 50 £2.50 £125.00

Subtotal £500.00 (I want this cell total to auto fill list from each sheet on to the master sheet) e.g

Work sheet 1 - £500.00

work sheet 2 - £750.00

work sheet 3 - £750.00
There are no comments posted here yet