Kutools for Excel versions

Extend the functionality of MS Excel and make it more effective
Jan 20, 2025
Feb 14, 2023
Review
Jul 28, 2022
Review
Jan 2, 2022
Review
Jun 10, 2021
Review
Jan 19, 2021
Review
Aug 28, 2020
Review
Mar 29, 2020
Review
Oct 29, 2019
Review
Jul 20, 2019
Review
Mar 20, 2019
Review
Aug 16, 2018
Review
Mar 26, 2018
Review
Aug 29, 2017
Editorial review
rating
Feb 17, 2017
Review
Oct 21, 2016
Review
May 20, 2016
Review
Feb 22, 2016
Review
Oct 29, 2015
Review
Jul 29, 2015
Review
Jun 18, 2015
9.0
May 7, 2015
Review
8.1
Apr 4, 2015
Review
8.0
Jan 15, 2015
7.8
Aug 13, 2014
Review
7.5
Apr 19, 2014
7.0
Feb 16, 2014
6.5
Oct 24, 2013
6.0
May 25, 2013
Editorial review
rating
5.5
Jan 9, 2013
Editorial review
rating
5.1
Sep 29, 2012
4.0
Apr 28, 2012
Review
2.0
Jun 4, 2011
Review

What's new

v27.0 [Feb 14, 2023]
New features:
- New handy chart templates.
- Dynamic Polyline Chart.
- 2.2- Truncate The Y-axis Chart.
- 2. One-to-many Lookup (returns multiple results).
- 2.2- In addition to just listing all the matches, mathematical operations such as sum, count, product, average, etc., can be performed on all matching values.
- 3. Split Data to Rows.
- This feature is designed to split multiple text entries in a single cell which are delimited with certain character (such as semicolon, space, newline, etc.- into different rows.
- 4. Clear Advanced Drop-down List.
- This feature can be used to clear the scope you set for the Multi-select Drop-down List feature, Drop-down List with Check Boxes feature, and the Searchable Drop-down List feature.
Improvements:
- Replace Any Characters.
- The Replace Accented Characters feature is now renamed as Replace Any Characters. This feature is presented in a new look in this version. It is improved to support:
- Replacing any accented characters with regular characters.
- Converting punctuation marks between Chinese and English.
- Converting characters between full-width and half-width.
- Converting letters between uppercase and lowercase.
- Converting between newlines and spaces.
- Removing all non-printed characters.
- Customizing your own replacement rules.
Add Text:
- This feature has been optimized to have more useful options:.
- Add text before certain text;.
- Add text after certain text;.
- Add text between characters;.
- Add text between every word;.
- Add text around the text.
Remove Characters:
- This feature now supports removing duplicated characters within a cell and keeping only the first occurrences.
- Dynamic Drop-down List.
- This feature now supports creating a 2-5 levels dependent drop-down alphabetically.
- Advanced Drop-down List.
- Transform Range.
- This feature now allows transforming the selected range without preserving the cell formatting, which can make the whole process much faster.
- Apply Date Formatting.
- This feature now allows you to add your custom date formats. And you can modify the date format list to keep only the date formats you need.
- Advanced Combine Rows.
- This feature now has a refreshed look that provides a simpler, more coherent experience that lets you operate more easily. Besides, more useful options are provided:.
- Skip empty cells when combining cells based on criteria in another column;.
- Delete duplicate values when combining cells based on criteria in another column;.
- Combine values with colon when combining cells based on criteria in another column;.
- Count unique values based on criteria in another column;.
- Preview the results of the merge in the dialog box under the Preview tab.
- Click the Sample button to open a sample file to learn how to use this feature.
Sort Sheets:
- This feature now supports reordering worksheets in a workbook including hidden worksheets.
Setting Center:
- A new option “Disable Advanced Drop-down List on Startup” is added to the setting center.
- Re-run Last Utility.
Interface Optimization:
- The following features now have a refreshed look that provides a simpler, more coherent experience that lets you operate more easily.
- Multi-select Drop-down List.
- Drop-down List with Check Boxes.
- Searchable Drop-down List.
- Features under the Super LOOKUP group.
- Hide/Unhide Workbooks and Sheets.
- Select Range Helper.
- Fill Custom List.
- Insert Sequence Number.
- Enable Date Picker.
- Link Sheets (formerly known as Data Association).
- Export Graphics.
- Import Pictures.
- Match Import Pictures.
Big Data Optimization:
- For some features, we have improved the rate of big data processing and the accuracy of results.
- Undo operation: improve the stability.
- Increase the backup speed.
- Other improvements.
Fixed:
- Fixed: Make Up a Number – Handling numbers with two decimal places may lead to calculation errors.
- Fixed: Date picker - The Date Picker dialog box will display when selecting non-date formatted cells.
- Fixed: Data Form – The displayed total does not match the selected number of rows under some special states.
- Fixed: Combine Rows, Columns, or Cells without Losing Data – Formulas are recalculated after merging.
- Fixed: Link Sheets – The dialog box is covered when naming a scenario.
- Fixed: Expand Dynamic Drop-down List – Failure to expand the dynamic drop-down list range in some cases.
- Fixed: Passwords Manager – In some cases, the “automatically fill password” option does not fill in the password correctly.
- Fixed: Convert Time – Filtered columns are also converted when saving the results to another location.
- Fixed: Send Emails – In some cases, the program will get stuck when setting a longer send interval.
- Fixed: Other minor bugs.

v26.1 [Jul 28, 2022]
Improvements:
- Password Manager: When opening a workbook encrypted with a password, Kutools' Password Manager will appear in the Password dialog box even if the "Automatically Fill Password" option is not enabled.
- Compare Worksheets: Optimized interface, improved processing logic.
- Optimized startup speed, and improved stability and compatibility.
Fixed:
- Fixed: The “Make Up a Number” feature does not work correctly when handling decimals in some cases.
- Fixed: Errors occur when applying the “Dynamic Ranking Bar Chart” feature in some languages other than English.
- Fixed: Applying the “Split Data” feature to a vast data worksheet may cause errors.
- Fixed: Applying the “Split Workbook” feature may cause errors in some cases.
- Fixed: When renaming worksheets using the "Rename Worksheet" feature, special characters in the new name may cause errors.
- Fixed: Errors occur when using VBA to call Kutools features in some cases.
- Fixed: Other minor bugs.

v26.0 [Jan 2, 2022]
- New features
- New handy chart templates:
- Battery Chart: This new feature helps to create a battery chart in Excel with just a few clicks. It is a great visual way of viewing the percentage complete and the percentage remaining for a task. According to the battery chart, you can easily know how far through you are for the task.
- Alternative Progress Bar Chart: Compared with the Progress Bar Chart in the previous versions, this Alternative Progress Bar Chart provides a better appearance to display the progress of multiple projects.
- Alternative Stacked Column Chart: This Alternative Stacked Column Chart shows different series as parts of the same single column bar, which helps to compare the values of the series at a glance.
- Dynamic Pie of Pie Chart: In Excel, you can use the built-in Pie of Pie chart to show the proportions of a whole, but it supports only one series at a time. Here, with the Dynamic Pie of Pie Chart feature of Kutools for Excel, you can easily create a chart with two pies that not only shows proportions of the sum of each row or column in the selected range but also displays proportions of the data in a row or column at the same time. In addition, you can dynamically change the displayed data by changing the selection from the drop-down list.
- Scrollable Line Chart: Usually, when displaying a large amount of data with a line chart in Excel, the points are too serried to observe the data and changes of each data point.
- With this Scrollable Line Chart, you can decide how many rows of data to display in the chart at a time, and click right or left at the scroll bar control to change the data displayed.
- Dynamic Column Chart: Normally, when using Excel built-in to create a column chart for multiple series, all series are displayed in the chart at the same time. If you want to display only one series at a time and dynamically change the series as needed, the Dynamic Column Chart feature of Kutools for Excel can do you a favor. This feature helps to create a dynamic column chart with a drop-down list to display data for one series at a time by selecting the series from the drop-down list.
- Dynamic Ranking Bar Chart: This feature helps to create a scrollable dynamic bar chart in descending ranking order to display only the top N values of a series.
- With this chart, you can decide how many rows of data are displayed in the chart at a time, and click right or left at scroll bar control to change the data displayed, and the displayed data will be ranked in descending order automatically.
- Compare Worksheets: This feature compares two specified worksheets in two different workbooks side by side and marks the differences in the same cell position with different background colors, bottom border colors, or font colors as you specified.
- Configure Synchronization: Kutools for Excel now allows synchronizing its configuration information between devices with a OneDrive Account.
- Improvements:
- Performance improvements
- Rename Worksheets.
- Filename List.
- Combine Rows, Columns or Cells without Losing Data.
- Transpose Table Dimensions.
- Select Cells with Format.
- Select Specific Cells.
- Transform Range.
- Select Duplicate & Unique Cells.
- Searchable Drop-down List
- The Searchable Drop-down List feature adds a Mode group, which allows you to add the searched items in an append mode or modify mode according to your needs.
- kte-26-10.png
- Split Data
- This feature now allows users to specify the first few rows as the title rows of split worksheets.
- kte-26-11.png
- Optimize the layout of the ribbon interface to adapt to Windows 11 and the new Office interface.
- Optimize the ribbon icons to adapt to the HDPI display.
- Other improvements.
- Fixed:
- Fixed: The Microsoft Sign in dialog box distorts in HDPI display.
- Fixed: When the Reading Layout feature is enabled, opening CSV files may get stuck in some cases.
- Fixed: Starting Excel may cause loading file error problem in rare cases.
- Fixed: Other minor bugs.

v25.0 [Jun 10, 2021]
New features:
- Smooth Area Chart: By default, area chart has jagged lines when creating by using Excel built-in feature. This Smooth Area Chart feature can help to easily create an area chart with smooth lines by only several clicks.
- Horizontal Waterfall Chart: The Horizontal Waterfall Chart helps to easily generate a horizontal waterfall chart or a mini horizontal waterfall chart in Excel.
- Interval Label Bar Chart: The Interval Label Bar Chart can generate a bar chart with category labels above the bar which help free up more chart space.
- Stacked Difference Chart: The Stacked Difference Chart feature generates a bar or column chart to compare two sets of data. With this type of chart, you can easily figure out whether the data are growing or falling during a certain period, and know the exact amount of change in the data.
- Price Tag Chart: This Price Tag Chart feature generates a chart looks like a price tag, which acts like a column chart but the appearance is more novel and beautiful.
- Check Box Line Chart: When using a line chart to compare many sets of data, the chart looks mussy because there are too many polylines in the chart. The Check Box Line Chart feature helps to generate a dynamic line chart with check boxes in Excel. You can decide which lines to be displayed in the chart by just checking the corresponding check boxes in order to keep the chart clean and easy to analyze.
- Multi-condition Lookup: This Multi-condition Lookup feature helps to look up values in different columns with 2 or more criteria with several clicks only.
- Data Association: The Data Association demonstrates a real-time filtering of worksheets between two Excel workbooks. After configuring this feature, clicking on any cell in the key column of primary worksheet will correlate the data in secondary worksheet and filter the corresponding data immediately.
- Insert QR Code: The Insert QR Code feature can generate QR codes based on specific cell values easily.
- Drop-down List: This version adds several drop-down list related features for you to handle drop-down list easily.
- Encrypt Workbook: The Encrypt Workbook feature can encrypt a batch of workbooks which saved in the same or different folders in current device or OneDrive with the same password at the same time.
- Decrypt Workbook: The Decrypt Workbook feature helps to decrypt a batch of workbooks which saved in the same or different folders in current device or OneDrive with specified password.
- Korean Language Pack: This version supports Korean language now.
Improvements:
- Split Workbook.
- Advanced Sort.
- Split Data.
- Export Range to File.
- Passwords Manage.

v24.0 [Jan 19, 2021]
New features:
- Project Status Spectrum Chart.
- Project Status Bead Chart.
- Progress Pie Chart.
- Radial Bar Chart.
- Alternative Rose Chart.
- Nightingale Chart.
- Bidirectional Histogram Chart.
- Multiple Series Line Chart.
- Multi Layer Column Chart.
- Forecast Chart.
- Threshold Value Area Chart.
- Rectangular Pie Chart.
- Half Pie Chart.
- Add Poly Line.
- Detach Chart.
- Date Picker.
- Mark Keyword.
- Show Classic Menu on Quick Access Toolbar.
- Convert date to serial date.
- Convert date to quarter.
- Sum based on the same text.
- Cell contains specific text then return value.
- Abbreviated Name .
- Connected value by specific character (string).
- Calculate days in year.
- Calculate days in month.
Improvements:
1. Extract Text: In the latest version, the Extract Text feature has been improved greatly to handle most of extracting needs:
- Extract the first N characters, says extract the first 10 characters from the left of each cell in the specified range;.
- Extract the last N characters, says extract the last 6 characters from the right of each cell in the specified range;.
- Extract characters in the specified position range, says extract from the 5th character to the 12th character from each cell in the specified range;.
- Extract characters before a given text, says extract all characters before the first blank from each cell in the specified range;.
- Extract characters after a given text, says extract all characters after the first blank from each cell in the specified range;.
- Extract all numbers from each cell in the specified range.
- The feature supports to use formulas to extract the characters. That means the extracted results are dynamic, and they can update automatically based on the original cells in the specified range.
- (Kutools) Search: Support to disable the “ALT S” shortcuts to enable the (Kutools) Search feature.
- Multi-select Drop-down List: Support to remain the activated status you set in the last closed workbook.
- Drop-down List with Check Boxes: Support to record the activated status you set in the last closed workbook.
- Dumbbell Plot Chart: Support to fill the bars between dots with two colors, so that you can quickly identify the difference is positive or negative between the two sets of values.
- Multi Series Histogram Chart: In the latest version, the Multi Series Histogram Chart also supports to create a multi-series bar chart.
- Progress Ring Chart: The Progress Ring Chart has optimized the chart style, and now it adds 3 chart styles for our users.
- Reading Layout: The Reading Layout feature is improved to support highlighting the area of the active cell. However, the Highlight the area of active cell option is disabled by default.
- Copy Ranges: In the latest version, the Copy Ranges feature is enhanced to copy multiple ranges ignoring the hidden rows and columns.
- Find and Break Broken Links: The Find and Break Broken Links feature has been improved greatly in the latest version. Now it not only supports to find and break links to cells of other workbooks, but also supports to find and break links to PivotTables, shapes, and name ranges.
- Setting Center: Enhance the repairing feature to solve the problem of loading failure.
Fixed:
- Fixed: Some minor bugs occur when applying the AutoText feature in the Navigation Pane.
- Fixed: Some bugs occur when looking for comments with username in the Super Find Pane.
- Fixed: Some formula errors come out when creating dynamic drop-down list in non-English environments.
- Fixed: The Average line added by the Add Line to Chart tool cannot update automatically.
- Fixed: Some minor bugs occur in the Super Filter Pane.
- Fixed: When adding OneDrive folders in the Combine Worksheets dialog, their subfolders are ignored.
- Fixed: Some features cannot save the custom-defined colors.
- Fixed: Barcodes cannot be inserted due to blank or special characters existing in the worksheet names.
- Fixed: In the latest Office 365, the Export Range to File feature cannot export a selection to simple HTML file because the total number of characters in some cells of the selection is greater than 255.
- Fixed: The Work Area feature probably cannot work in Excel 2013 and later versions.
- Fixed: The Reading Layout feature may cause lockup when copying and pasting to other worksheets in some cases.
- Fixed: The Monitor Precedents and Dependents feature lead to copying and pasting failures in some situations.
- Fixed: OneDrive folders cannot be found in some situations.
- Other minor bugs..

v23.0 [Aug 28, 2020]
- Dumbbell Plot Chart: The Dumbbell Plot chart can be used to compare two sets of data, and show the differences between them with lines in a chart.
- Progress Ring Chart: This Progress Ring Chart is commonly used to show the completion percentage of a project, with showing the completion percentage in the middle of doughnut.
- Percentage Ball Chart: The Percentage Ball Chart is commonly used to show the percentage of something occupied or remaining, or the completion percentage of a project. This chart supports to change border color, background color, and foreground color of the ball.
- Progress Bar Chart: Comparing with above Progress Ring Chart or Percentage Ball Chart can only show the completion percentage of one project, the Progress Bar Chart can show the completion percentages of multiple projects in one chart. The Progress Bar Chart can create a chart based on the given completion percentage. It also supports to create a chart based on the given actual and target values without figuring out the completion percentages in advance.
- Slope Chart: You can easily create a Slope Chart in Excel to visually show the difference between two categories at two times.
- Threshold Value Chart: The Threshold Value Chart compares the data points with a given threshold value, and show the differences between data points and the threshold value by column direction, column height, and color.
- Difference Arrow Chart: This Different Arrow Chart is similar as a clustered column or bar charts, but add arrows and percentages to show the differences between two sets of data.
- Matrix Bubble Chart: This feature helps to create a Matrix Bubble Chart with only several clicks in Excel. The matrix bubble chart represents data points by bubbles in a matrix, which is fit to compare multiple sets of data horizontally and vertically.
- Bar with Bubbles Chart: A general clustered bar chart can only show a set of data. The Bar with Bubbles Chart enhances the bar chart, and helps us show two sets of data horizontally: use bars to show one set of data in left side, and use bubbles to show the other set of data in right side.
- Difference Area Chart: The Difference Area Chart draws two lines for two sets of data, and use the filled room between the two lines to show the differences between two sets of data.
- Dot Chart: The Dot Chart uses markers to show data, which looks like the scatter chart. But this chart assigns both X and Y axes with two sets of data.
- Variable Width Column Chart: Different from normal column showing one-dimension data by column heights, the Variable Width Column Chart can show two sets of values across two dimensions by both column widths and column heights.
- Marimekko Chart: The Marimekko Chart compounds multiple stacked columns in a chart, and shows all sets of values across three dimensions.
- Lollipop Chart: The Lollipop Chart slims columns to lines, and adds colorful circles at the end of lines, which makes the point values more attractive visually.
- Multi Series Area Chart: The Multi Series Area Chart compounds multiple area graphics in one chart, and helps us easily compare multiple sets of values easily in the chart.
- Proportion Stacked Chart: The Proportion Stacked Chart can reflect the proportion of each point value in a series with small squares.
- BiDirectional Bar Chart: The BiDirectional Bar Chart places two sets of values at two sides of the Y axis, so that we can compare these two sets of values horizontally at ease.
- Multi Series Histogram Chart: This Multi Series Histogram Chart uses a set of columns to represent a set of data, and combine multiple sets of columns in one chart, so that you can easily distinguish these series.
- Copy Format to Other Charts: This feature will copy the formatting of the currently selected chart to multiple charts of the active workbook in bulk.
- Set Absolute Position of Chart: This feature will move the currently selected chart to the specified position, and resize the chart to specified range simultaneously.
- Add Sum Labels to Chart: This feature will add the sum labels for the currently selected stacked chart.
- Add Cumulative Sum to Chart: This feature will add an accumulated line with accumulated total labels for the currently selected clustered column chart.
- Move X-axis to Negative/Zero/Bottom: This feature will move the X axis to the bottom of the currently selected chart.
- Add Trend Lines to Multiple Series: This feature will add a trend line for a scatter chart which contains multiple series of data.
- Change Chart Color According to Cell Color: This feature will change the fill color of columns, bars, scatters, etc. based on the fill color of corresponding cells in the chart data range.
- Data Form: This feature shows the data in the specified range row by row. In the Data Form dialog, we can read, add, delete, or edit the data in rows.

v22.0 [Mar 29, 2020]
Improvements:
- Formula Helper: The Formula Helper is improved greatly to help users filter, find, and apply the formulas easily.
- Formulas are grouped into 5 categories: Date & Time, Statistical, Text, Lookup & Reference, and Math & Trig.
- Add 15 new formulas:
- Count days, hours and minutes between dates.
- Convert days to year month day.
- Convert seconds to hh:mm:ss time format.
- Count cells equal to A, B or C.
- Count cells with two conditions (and).
- Count unique values.
- Count cells with unique values (include the first duplicate value).
- Count the number of values separated by comma.
- Extract the nth word in cell.
- Extract unique values.
- Extract cells with unique values (include the first duplicate value).
- Extract strings between specified text.
- Index and math on multiple columns.
- Find the largest value less than.
- SUMPRODUCT with criteria.
Fixed:
- Fixed: The Speedometer Chart doesn’t support customizing fill color.
- Fixed: The Exact Copy feature cannot copy formulas in some situations.
- Fixed: If there is no active window, errors occur when clicking the Toggle to unhide/hide all hidden worksheets button on the Navigation Pane.
- Fixed: Errors occur when applying the Drop-down List with Check Boxes feature to merged cells.
- Super Filter:
- Fixed: The new added sub-condition groups cannot display.
- Fixed: After saving filter scenarios, the scenarios lost when switching worksheets.
- Fixed: Kutools may cause the welcome screen to disappear in the latest Office 365.
- Fixed: other minor bugs.

v21.0 [Oct 29, 2019]
New features:
- Lookup Across Multiple Sheets: Comparing to the VLOOKUP function which can only look for a value from one range, this feature will help Excel users to batch look for multiple values across multiple worksheets at a time easily.
- Lookup and Sum: This feature will find a row or column in the selection based on the given criteria and return the summation of the found row or column.
- Lookup from right to left
- Different from the VLOOKUP function which can only look for a value in the leftmost column of a range, this feature enables you to look for values in any column of a range, and return values in another column as you need.
- Lookup from bottom to top: If there are multiple matched values, the VLOOKUP function will search from top to bottom and return the first matched value. But this feature will reverse the lookup order (from bottom to top) and return the last matched value.
- Lookup between two values: This feature can help to look for a value between two values and return a matched result easily.
- Replace 0 or #N/A with Blank or a Specified Value: If the lookup value is not found or empty, the VLOOKUP function will return #N/A error value or 0. This feature will return empty or a specified value for those unfound lookup values and empty values.
- Dynamic Drop-down List: With this feature, you can quickly create a 2 levels dependent drop-down list or a 3-5 levels dependent drop-down list with several clicks only.
- Colored Drop-down List: With this feature, you can quickly add multiple conditional formatting rules (highlight color) to cells or rows bases on the drop-down list options.
- Multi-select Drop-down List: Normally you can select one option for one cell in the data validation (drop-down list) range in Excel. But after enabling this feature, you can select multiple options for every cell from the drop-down lists.
- Drop-down List with Check Boxes: This feature will add a check box before each drop-down list option. After enabling this feature, you can tick the check boxes to select one or multiple options from the drop-down lists quickly.
- Password Manager: This feature can add and manage passwords, which are used to open password-protected workbooks. After adding passwords in this manager, corresponding workbooks can be opened directly when using Combine Worksheets or other features of Kutools for Excel.
Improvements:
- PivotTable Special Time Grouping: This feature is optimized and enhanced greatly, and be more user-friendly now: Add check boxes before grouping criterions, and support to select multiple grouping criterions at a time. Automatically recognize and select date or time column.
- Create Speedometer Chart: This feature is improved to create more artistic speedometer chart in Excel. Support to manually type in max/min/current values directly when creating static speedometer chart. Decorate the output speedometer chart, and make it more beautiful.
- Navigation Pane: This feature is enhanced greatly and provides a much smoother user experience:
- Displaying the Navigation Pane floatingly, and click the pin button can fix the display back.
- In the Workbook & Sheet Pane, add a toolbar above sheet list to show sheet tools.
- In the Workbook & Sheet Pane, double click the workbook name to rename it.
- In the Workbook & Sheet Pane, add icons to show worksheet protection status and sheet tab colors.
- In the AutoText Pane, support to combine imported AutoText categories.
- In the AutoText Pane, support to sort AutoText categories or AutoText entries by manually dragging and dropping.
- In the Column list Pane, add a toggle button to unhide/hide columns.
- In the Name manager Pane, remind users when modifying a named range and switching to other panes without saving changes.
- Optimize icons, language, etc.
- Super Filter:
- Add a Close the scenario button in the toolbar.
- Support to specify working scope for filter scenarios: Current worksheet, Current workbook, and All.
- When opening a filter scenario in a new worksheet or workbook, users can choose to load and synchronize the opening scenario, or create a new scenario based on the opening scenario.
- Support to wrap long filter criteria.
- Remind users to save filter scenarios when closing the workbook.
- Optimize icons, language, etc.
- Combine Worksheets:
- Support to specify combine mode: combine by row, and combine by column.
- Add the Password feature, with which users can add passwords to open password-protected workbooks directly when combining.
- Send Emails: This feature is enhanced to support using Outlook’s signature settings.
Fix:
- Fixed: Insert Pictures from Path (URL) feature cannot insert pictures from some special website.
- Fixed: Send Emails feature cannot identify some special characters in cells, such as the newline character.
- Fixed: Some dialogs display abnormally with Multi-screen HDPI.
- Fixed other minor bugs.

v20.0 [Jul 20, 2019]
New Features:
- Enhanced Edit Bar: This handy feature will enhance the formula bar, help you view and edit long content of the active cell at ease.
- Validate Email Address: With this feature, you can set data validation for one or multiple selections with only one click, and only allow email addresses to be entered.
- Validate IP Address: This feature will set data validation for one or multiple selections with only one click, and only allow IP addresses to be entered.
- Validate Phone Number: With this feature, you can set data validation for one or multiple selections quickly, and only allow phone numbers in the specified format to be entered.
- Make up a number: With this amazing feature, you can find out all combinations whose combination elements are summed equal to a given value.
- In addition, this feature supports to specify the number of output combinations and the number of output combination elements.
- Create Bubble Chart: This feature will help you quickly create a bubble chart in Excel.
- Create Speedometer Chart: This feature will help you quickly create a speedometer chart in Excel. It supports two speedometer chart types:
- Create Normal Distribution / Bell Curve Chart: This feature will help you quickly create a normal distribution chart or bell curve chart in 9. Duplicate rows / columns based on cell value: With this feature, you can duplicate each row or column of the specified range n times based on cell values in another specified column.
- Insert barcode: This feature will help you insert multiple barcodes in bulk based on cell values in the specified range. It supports multiple barcode types: UPC-A, UPC-E, EAN-13, EAN-8, Case Code, Codabar (NW-7), Code-39, and Code-128.
- PivotTable Special Time Grouping: This feature will help you create a PivotTable, and group the PivotTable data by special date or time criteria, such as fiscal year, half year, week number, day of week, half an hour, minutes, etc.
- Print Circle Invalid Data: In normal, after setting data validation for a range, you can use the Circle Invalid Data tool to check for the invalid data. Now, with this feature, you can easily print with these validation circles easily.
- Print charts only: This feature will help you print charts only in the current workbook. It supports to print multiple charts on one page, and print each chart on a separate page.
- Distinguish differences by key column: With this feature, you can easily mark differences by cell value changes in the given key column. You can mark the changes by page breaks, blank rows, bottom borders, or fill color.
- Always Show Comment: By default, a cell comment will display when the cursor hovers over the cell, and hide immediately when the cursor leaves. Now, with this Always show comment feature, the comment of active cell will display all the time, no matter where you move the cursor.
Improvements:
- Remove Hyperlinks Without Losing Formatting: This feature was initially named as “Remove Hyperlinks”, but now it’s renamed as “Remove Hyperlinks Without Losing Formatting”. This feature has been improved to remove hyperlinks but remain all cell formatting.
- Navigation Pane: In the Workbook & Sheet Pane and AutoText pane, when the workbook names, sheet names, or AutoText entries’ names are too long to display completely, show the hidden part of names as ellipsis. Adjust line height in the Workbook & Sheet Pane and AutoText pane.
- Special Filter: The Special Filter feature has been enhanced to filter by format (bold, italic, strike through, font color, and background color) in special circumstances.
- Sort / Select Range Randomly: This feature was named as “Sort Range Randomly” initially. Now it’s renamed as “Sort / Select Range Randomly”.
- This feature is also added into Select menu (Kutools > Select > Select Range Randomly) and Sort menu (Kutools Plus > Sort > Sort Range Randomly).
Fixed:
- Fixed: Super Find cannot find values less than a certain value.
- Fixed: Cannot end the process of Currency Conversion after updating currency exchange rates.
- Fixed: Navigation Pane leads to working areas confusing within multiple HDPI screens.
- Fixed: The following features cannot select or deal with LAN paths or files: Format Converter, Combine Worksheets, Filename List, Import Pictures, Match Import Pictures, Batch Remove All Macros, Split Workbook, Import AutoText, and Export AutoText.
- Fixed: After changing display language, slices of text don’t switch to current selected language in Format Converter and Insert Workbook Information dialog boxes.
- Other minor bugs.

v19.0 [Mar 20, 2019]
- Insert Pictures from Path(URL): With this handy utility, you can quickly insert multiple pictures in bulk based on the file paths or URL of these pictures. In addition, you can preset the sizes of inserted pictures in three ways: original size, fixed height, and fixed width. See screenshot:
- Clear Data Validation Restrictions: This utility can help you remove all data validation restrictions from the selected ranges with only one click.
- Fixed: Some screen tips are incorrect.
- Fixed: The Snap feature does not work with OneDrive.
- Fixed: The Formula Helper feature cannot return to the current selection correctly or go front automatically when selecting ranges from other workbooks.
- Fixed: Some windows display incorrectly when zooming within the high definition screen.

v18.0 [Aug 16, 2018]
New features:
- Super Find: This powerful utility improves the Find function of Excel, it can help you to find and select the cells that matched a specific condition in text strings, comments, formulas, hyperlinks, cell values, and dates. It can find the cells with specific cell formatting as well. This feature can be applied in a selected range of cells, active worksheet, selected worksheets, whole workbook and all opened workbooks.
- Fuzzy Lookup : In Excel worksheet, entering a list of same text manually may contain some typos, with this feature, you can quickly check for the similar records based on character differences, and then correct them to your own text at once.
Improvements:
- Super Filter: Support some new operations for this utility: 1). Improve the condition edit box by adding an OK command button; 2). Insert Refresh option in this latest version. 3). Collect all toolbar features into one drop-down menu.
- Create Mailing List / Send Emails: 1). Support Cc and Bcc when creating a mailing list and sending emails; 2). Support multiple attachments to be inserted into one cell without number limitation while creating a mailing list.
- Support to insert pictures of the local disk when editing message body.
- Add right-click menu in the edit message box.
- Support to save the sent emails to a local folder in SMTP sent mode.
Support to set interval time when sending multiple emails.
- Add a scenario manager for adding and managing multiple email accounts in SMTP sent mode.
- A new status column is created to determine if the email sent successfully in SMTP sent mode.
Fixed:
- Fixed: Matching pictures can only be imported once each time when there are duplicate cell values in the Match Import Pictures utility.
- Fixed: A warning prompt box is always popped out if the first character is not ? character when typing a formula under Custom option in the Operation utility.
- Fixed: The filter result is not correct if there are error values in the filter range of cells when applying the Super Filter feature.
- Other minor bugs.

v17.0 [Mar 26, 2018]
- Tables Merge
This powerful utility can help you to merge two tables in a workbook or two separate workbooks based on matching columns. With this feature, you can update data in the main table based on the new lookup table, add new columns after the main table and insert all non-matching or duplicate matched rows from the lookup table to the main table.
- Special Filter
The Special Filter feature gathers all frequently-used filter functions to help you improve your work efficiency.
- Improvements
The Enterprise tab is renamed as Kutools Plus.
The edit box is improved to support
Enabling/disabling/deleting the existing criterion.
Adjusting the form size by dragging the border.
- Look for a value in the list
Supporting to type the column number of the returned lookup value directly.
- Fixed
Fixed: A prompt box will pop out to remind worksheets creating failing when blank cell existing in the selected range of the Create Sequence Worksheets utility.
Fixed: The inactive excel files will be locked when applying the Paste to Visible Range feature.
Fixed: Invalid email addresses cannot be recognized when sending emails by the Send Emails utility.
Other minor bugs.

v16.5 [Aug 29, 2017]
Create Mailing List: This utility can help you to quickly create a sample table with some mailing labels, such as Email address, subject, first name, last name, etc. You can change them or add the information of your own.
Added the context menus in the Navigation pane.
Supporting to filter sheets in the Workbook & Sheet pane quickly.
Supporting to filter names in the Name manager pane.
Supporting to list hidden files and files in hidden folders.
Fixed: Can’t clear the cell formatting of blank cells when the entire columns and rows are formatted by using the Clear Characters Formatting feature.
Fixed: Prevent Typing feature does not take effect in certain language.
Fixed: The select box of the second criteria does not display in the Select Specific Cells feature.

v16.0 [Feb 17, 2017]
1. Insert Bullet
Quickly insert bullet symbols or bulleted list to multiple cells at once, see screenshot:
2. Insert Numbering
With this feature, you can insert list of numbering into multiple cells quickly and easily, see screenshot:
3. Remove time from date
Quickly and easily remove time from the date time format cells, and only leave date format, see screenshot:
4. Toolbar Mode
You can change to different toolbar mode according to your computer screen resolution. If you have higher computer screen resolution, you can choose to use the Medium or Wide toolbar mode. By doing this, it will display more functions in your Ribbon interface. See screenshot:
5. Off-line HTML help document is available
The Help document has been added for Kutools for Excel in this version. You can access the off-line help document as follows:
arrow blue right bubble Improvements
1. Currency Conversion
Adding the currency abbreviations before each currency in the dialog box to make this feature more clearly and intelligibly, see screenshot:
2. Add traditional Chinese language support. See screenshot:
arrow blue right bubble Fixed
1. Fixed: Large filtered data may be caused Excel crashed when Reading Layout feature enabled.
2. Fixed: Error occurs when typing blank characters in Prevent typing textboxes.
3. Fixed: Other minor bugs.

v13.0 [May 20, 2016]
May include unspecified updates, enhancements, or bug fixes.

v12.0 [Oct 29, 2015]
New features
1. Adding new useful built-in functions
Kutools for Excel adds a couple of useful functions for easily calculations without remembering formulas.
Count by font bold:
Sum by font bold:
2. Adding new commonly-used built-in formulas
More commonly-used formulas are available now, which including: Find nth occurrence of a character, Count words in range, Count weekends between two dates, Count weekdays between two dates and Count the number of specific weekday.
3. Delete All Inactive Sheets
This utility can easily delete all inactive sheets except current one with clicks. See screenshot:
arrow blue right bubble Improvements
1. Navigation Pane
1.1 All opening Excel windows will be displayed in the Workbook pane of Navigation Pane.
1.2 Adding status bar for the numbers of all sheets, visible sheets and hidden sheets of current workbook at the bottom of Navigation Pane. See screenshot:
2. Split Workbook
2.1 Support splitting current workbook and saving each selected worksheet as a separated PDF file.
2.2 It will display dialog box for you to process when the destination has files with the same names during splitting period. See screenshot:
3. Match Import Pictures
The Match Import Pictures feature supports case sensitive now. See screenshot:
4. Advanced Sort
The Advanced Sort feature supports case sensitive now. See screenshot:
5. Split Cells
You can split cells into multiple rows now. See screenshot:
6. Advanced Find and Replace
6.1 Pressing shortcuts Ctrl Shift F will directly access the Advanced Find and Replace pane of Kutools for Excel. And you can also assign shortcuts Ctrl F in the Navigation Options to access the Advanced Find and Replace pane of Kutools for Excel.
6.2 The Advanced Find and Replace pane of Kutools for Excel is floatable.
7. List All Combinations
7.1 There is a checkbox before each combination entry;
7.2 Pressing shortcuts Alt A will directly add text to the Combination list. See screenshot:
8. Select Nonblank Cells
Displaying the total number of all nonblank cells in selected range. See screenshot:
arrow blue right bubble Fixed
1. Fixed: Fail to register in Office 365 and 2016.
2. Fixed: Cell A1 is selected when no nonblank cells existing in selected range.
3. Fixed: Some errors of the interface language.
4. Fixed: other minor bugs.

v11.0 [Jul 29, 2015]
May include unspecified updates, enhancements, or bug fixes.

v9.0 [May 7, 2015]
New features
1. Add the frequently-used Workbook and Worksheet utilities to the Navigation Pane. See screenshots:
2. Supporting to sort workbooks in the workbook list of Navigation Pane into ascending or descending order. See screenshots:
3. Add the Match Import Pictures utility: you can easily import pictures into cells according to the cell contents now.
arrow blue right bubble Improvements
1. Support sorting worksheets and workbooks when combining Worksheets. Tip: the workbooks and worksheets will be combined according to the order as they displaying in the Workbooks list and Worksheets list. See screenshot:
2. The window size of the Combine Worksheets is adjustable now.
3. Update Danish language.
4. Add some missing SuperTips, and proofreading some interface descriptions.
5. Redesign some icons to make the icons style more unified.
6. Other minor improvements.
arrow blue right bubble Fixed
1. Fixed: the calculation error of the SUMBYFONTCOLOR and SUMBYCELLCOLOR.
2. Fixed: the Excel crash problem caused by the Navigation Pane conflicts with some Add-Ins.
3. Fixed: the problem of popping-up blank description in the Setting Center when registering Kutools for Excel under specific language.
4. Fixed: the problem of invalid Undo for the first time after installing Kutools for Excel.
5. Fixed: the error problem when closing the Supper Filter’s Open saved filter settings scenario.
6. Fixed: type in too many characters in the name of AutoText entries will cause error.
7. Fixed: other minor bugs.

v8.1 [Apr 4, 2015]
Worksheet Design: It will display all Worksheet Design tools in a separate tab.
Selection Lock: it will lock the selection when the worksheet is protected by a password.
Selection Unlock: it will unlock the selection even though the worksheet is protected by a password.
Highlight Unlocked: it will highlight the unlocked cells of the worksheet.

v7.8 [Aug 13, 2014]
- Some minor bugs fixed

v5.5 [Jan 9, 2013]
--Enhanced some utilities with processing bar
When you need to operate a large number of data sources with the following utilities: Merge Workbooks, Split Workbook, Split Data, Replace Range Names, Paging Subtotals, Print Multiple Columns and Export Range to File, it will display a processing bar as shown in the below screenshot during processing huge data with Kutools for Excel.
--Kutools for Excel for Office 2013
--Transform Range utility has been improved
From now on, with this utility, you can transform a range into a single column or a single row too.

Alternative downloads

Repair My Excel
Repair My Excel
rating

Repair My Excel attempts to fix broken Excel spreadsheets.

Dose for Excel
Dose for Excel
rating

The Excel plug-in that adds extensive functionality to your work in Excel.

MgoSoft PDF Split Merge
MgoSoft PDF Split Merge
rating

A simple application that lets you split PDF files.

AbleBits.com Quick Tools for Microsoft Excel
AbleBits.com Quick Tools
rating

This tool cut the clicks and greatly simplify your daily tasks.

Combine Rows Wizard for Microsoft Excel
Combine Rows Wizard for Microsoft
rating

This addon lets you merge duplicate rows based on the selected key column(s).