Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or
×

kleverig Kutools for Excel 20.00 - Release notes

  • Excelfans
  • Excelfans's schermafbeelding Topic Author
  • Offline
  • Administrator
  • Beheerder
More
1 week 6 days ago #1759 by Excelfans
Replied by Excelfans on topic Kutools for Excel 20.00 - Release notes
Hello,
Thanks for contacting us.
Sorry, we don't have such feature yet.

Please try to contact us via sales@extendoffice.com or support@extendoffice.com.
Please try to be more specific about your issue in the email, and you will get the solution quickly.

Please Log in or Create an account to join the conversation.

More
1 week 6 days ago #1758 by TBP
Replied by TBP on topic Kutools for Excel 20.00 - Release notes
I downloaded the tool so that I can use the Distinguish Differences by Column function which inserts a blank row when a value changes. I can't seem to find this function. Can you please tell me where it is?

Please Log in or Create an account to join the conversation.

  • Excelfans
  • Excelfans's schermafbeelding Topic Author
  • Offline
  • Administrator
  • Beheerder
More
1 month 2 days ago - 2 weeks 2 days ago #1720 by Excelfans
Kutools for Excel 20.00 - Release notes was created by Excelfans
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 Free download Kutools for Excel - handy Excel add-ins collection .




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.


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.


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.


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


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.


6. Create Bubble Chart

This feature will help you quickly create a bubble chart in Excel.


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


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.


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.


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.


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.


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.


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.


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.


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


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.


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.


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





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.

Please try to contact us via sales@extendoffice.com or support@extendoffice.com.
Please try to be more specific about your issue in the email, and you will get the solution quickly.

Attachments:
Last edit: 2 weeks 2 days ago by Excelfans.

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun