Kutools for Excel 18.00 - Release notes

Question

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

Tip: full function & feature, free trial in 60 days! If the 2 years free upgrade support period is not expired, you are entitled to free upgrade this version. Please just download and install it.

New features:

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

1). Find and select specific cells in text strings:

KTE-18.00-01.png

2). Find and select specific cells in comments:

KTE-18.00-02.png

3). Find and select specific cells in formulas:

KTE-18.00-03.png

4). Find and select specific cells in hyperlinks:

KTE-18.00-04.png

5). Find and select specific cells in cell values:

KTE-18.00-05.png

6). Find and select specific date cells:

KTE-18.00-06.png

7). Find and select cells with specific cell formatting:
With this option, you can quickly find and select all cells with specific formatting, such as bold cells, italic cells, merged cells, cells with comment and so on…

KTE-18.00-07.png

2. 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. See screenshot:

KTE-18.00-08.png

Improvements

1. Super Filter:

Support some new operations for this utility:

1). Improve the condition edit box by adding an OK command button, see screenshot:

[attachment]KTE-18.00-09_2018-08-21.png[/attachment]

2). Insert Refresh option in this latest version, see screenshot:

[attachment]KTE-18.00-10_2018-08-21.png[/attachment]

3). Collect all toolbar features into one drop-down menu, see screenshot:

[attachment]KTE-18.00-11_2018-08-21.png[/attachment]

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

[attachment]KTE-18.00-12_2018-08-21.png[/attachment]
[attachment]KTE-18.00-13_2018-08-21.png[/attachment]

3). Support to insert pictures of the local disk when editing message body, see screenshot:

KTE-18.00-14.png

4). Add right-click menu in the edit message box, see screenshot:

[attachment]KTE-18.00-15_2018-08-21.png[/attachment]

5). Support to save the sent emails to a local folder in SMTP sent mode;
Support to set interval time when sending multiple emails.

KTE-18.00-16.png

6). Add a scenario manager for adding and managing multiple email accounts in SMTP sent mode.

KTE-18.00-17.png

7). A new status column is created to determine if the email sent successfully in SMTP sent mode, see screenshot:

KTE-18.00-18.png

3. Reading Layout:

Add Highlight the area of active cell option in the Reading Layout Settings dialog box, the active cell will not be highlighted by un-checking it. See screenshot:

[attachment]KTE-18.00-19_2018-08-21.png[/attachment]

4. Insert Random Data:
It supports to insert decimal numbers now, see screenshot:

KTE-18.00-20.png

5. Insert Watermark:
1). Support to insert the image watermark based on the picture scale;
2). Support the preview feature in Insert Watermark dialog box.

KTE-18.00-21.png

6. Column list:
1). Columns can be rearranged by clicking the move Up or Down arrows in the toolbar;
2). Columns can be rearranged by dragging the column record in the Column list pane.

KTE-18.00-22.png

Fixed:

1. Fixed: Matching pictures can only be imported once each time when there are duplicate cell values in the Match Import Pictures utility.
2. 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.
3. Fixed: The filter result is not correct if there are error values in the filter range of cells when applying the Super Filter feature.
4. Other minor bugs.