Note: The other languages of the website are Google-translated. Back to English
English 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.10 Date: August 1, 2022 


 

Subscribe Newsletter:

 

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.

view1 View Group


Navigation Pane: List sheets, workbooks, columns, names And insert auto text in Excel

Reading Layout: Automatically highlight the entire row or column of the active cell

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

Data Form: Quickly create a data entry form in Excel

View Options: Quickly toggle workbook and worksheet settings in Excel

Show / Hide:

  Ranges & Cells Group


Range:

Copy Ranges: Easily copy multiple selections in Excel

Compare Cells: Easily compare two ranges of cells if they are equal or different in Excel

Prevent Typing:

Drop-down List:

Content:

Conversion:

To Actual; Easily replace formulas with calculated values/results in cells in Excel

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

Merge & Split:

  Editing Group


Charts:

Find:

Select:

Insert:

Delete:

Text:

Format:

Link:

Comment:

Operation: Performs common math operations in cells, such as addition, subtraction, multiplication, division, etc

Calculator: Quickly fetches values from cells for calculation and insert result into cells

formula1  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:

Combine (Worksheets): Quickly merge / combine worksheets / workbooks or csv files into one workbook in excel

With this utility, you can achieve:

Table Merge: Update or merge two tables by a given matching column from two worksheets or workbooks

Split Data: Quickly split data into multiple worksheets based on selected column in excel

Format Converter: Quickly convert multiple xlsx files to xls or pdf files from local disk or onedrive

Split Workbook: Quickly split or save each worksheet of one workbook as separate excel / txt / csv / pdf files

Worksheet Design:

Printing:

Split to Columns: Printing a list into multiple columns to fit on each printed page in excel

Import / Export:

security4 Security Group


mailings3  Mailings Group


  Filter & Statistic Group


Sort:

Super Filter: Quickly filtering the whole worksheet by combining multiple conditions. You can add, delete or disable the conditions easily.

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.

Search: Easily search the function of kutools for excel

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.

view1 View Group


Navigation Pane: List sheets, workbooks, columns, names And insert auto text in Excel

Reading Layout: Automatically highlight the entire row or column of the active cell

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

Data Form: Quickly create a data entry form in Excel

View Options: Quickly toggle workbook and worksheet settings in Excel

Show / Hide:

  Ranges & Cells Group


Range:

Copy Ranges: Easily copy multiple selections in Excel

Compare Cells: Easily compare two ranges of cells if they are equal or different in Excel

Prevent Typing:

Drop-down List:

Content:

Conversion:

To Actual; Easily replace formulas with calculated values/results in cells in Excel

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

Merge & Split:

  Editing Group


Charts:

Find:

Select:

Insert:

Delete:

Text:

Format:

Link:

Comment:

Operation: Performs common math operations in cells, such as addition, subtraction, multiplication, division, etc

Calculator: Quickly fetches values from cells for calculation and insert result into cells

formula1  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:

Combine (Worksheets): Quickly merge / combine worksheets / workbooks or csv files into one workbook in excel

With this utility, you can achieve:

Table Merge: Update or merge two tables by a given matching column from two worksheets or workbooks

Split Data: Quickly split data into multiple worksheets based on selected column in excel

Format Converter: Quickly convert multiple xlsx files to xls or pdf files from local disk or onedrive

Split Workbook: Quickly split or save each worksheet of one workbook as separate excel / txt / csv / pdf files

Worksheet Design:

Printing:

Split to Columns: Printing a list into multiple columns to fit on each printed page in excel

Import / Export:

  Filter & Statistic Group


Sort:

Super Filter: Quickly filtering the whole worksheet by combining multiple conditions. You can add, delete or disable the conditions easily.

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.

Search: Easily search the function of kutools for excel

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.
Comments (294)
Rated 4.5 out of 5 · 1 ratings
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
Hello, please contact me with your issue at jaychivo#extendoffice.com
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
:-) Please contact me at jaychivo#extendoffice.com, please replace # with @.
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:

http://www.extendoffice.com/images/stories/comments/split-workbook.png
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:

http://www.extendoffice.com/images/stories/comments/split-workbook.png[/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


Yes, you can. Please try to upgrade to the latest version.

:-)
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
Load More
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations