Kutools for Excel 20.00 - Release notes

Question

Good news! Kutools for Excel 20.00 is released with new handy features and excellent improvements! You can upgrade to or have a free trial of this version by downloading from HERE .

New Features

1. Enhanced Edit Bar

This handy feature will enhance the formula bar, help you view and edit long content of the active cell at ease.
KTE-20.00-01.png

2. 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.
KTE-20.00-02.png

3. 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.
KTE-20.00-03.png

4. Validate ***** Number

With this feature, you can set data validation for one or multiple selections quickly, and only allow ***** numbers in the specified format to be entered.
KTE-20.00-04.png

5. 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.
KTE-20.00-05.png

6. Create Bubble Chart

This feature will help you quickly create a bubble chart in Excel.
KTE-20.00-06.png

7. Create Speedometer Chart

This feature will help you quickly create a speedometer chart in Excel. It supports two speedometer chart types:
180° speedometer chart
270° speedometer chart
KTE-20.00-07.png

8. Create Normal Distribution / Bell Curve Chart

This feature will help you quickly create a normal distribution chart or bell curve chart in Excel. It supports three chart types:
A. Normal distribution chart
B. Frequency histogram chart
C. The combination of Normal distribution chart and frequency histogram chart.
KTE-20.00-08.png

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.
KTE-20.00-09.png

10. 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.
KTE-20.00-10.png

11. 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.
KTE-20.00-11.png

12. 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.
KTE-20.00-12.png

13. 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.
KTE-20.00-13.png

14. 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.
KTE-20.00-14.png

15. 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. (Tip: Clicking mouse will change the active cell.)
KTE-20.00-15.png

Improvements

1. 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.
KTE-20.00-16.png

2. 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.
KTE-20.00-17.png

3. 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.

4. 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).
KTE-20.00-18.png

Fixed

1. Fixed: Super Find cannot find values less than a certain value.
2. Fixed: Cannot end the process of Currency Conversion after updating currency exchange rates.
3. Fixed: Navigation Pane leads to working areas confusing within multiple HDPI screens.
4. 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.
5. Fixed: After changing display language, slices of text don’t switch to current selected language in Format Converter and Insert Workbook Information dialog boxes.
6. Other minor bugs.