Kutools for Excel 11.00 - Release notes

Kutools for Excel 11.00 is available now. 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 feature

Formulas
Kutools for Excel lists some commonly-used formulas for easily calculations with only several clicks, which including:

1.1 Calculate age based on birthday 1.2 Look for a value in list 1.3 Sum absolute values 1.4 Count times a word appears 1.5 Sum numbers in a cell 1.6 Add years to date

1.7 Add months to date 1.8 Add days to date 1.9 Add hours to date 1.10 Add minutes to date 1.11 Add seconds to date 1.12 Add weeks to date

Advanced Find and Replace
Kutools for Excel released a new utility of Advanced Find and Replace to find and replace values across multiple workbooks and specific worksheets easily.

Select Unblank Cells
This utility can help you easily select all cells with content from selected range by just one click.

List all combinations
This utility is designed to list all combinations of specified series of data, and users can customize separators for combinations. See screenshot:

Print First Page of Each Worksheet
With this utility you can quickly print every first page of each worksheet one by one easily.

Print Pages in Reverse Order
This utility will reverse the printing order and print from the last page to the first one.

Insert Page Break Every Row
This utility will insert page break after every x rows (specified numbers of rows) in current worksheet.

Split Cells
This Split Cells utility can easily split a list of data to multiple columns by space, new line, semicolon, or custom separators.

AutoFit Comment
This utility will resize all comment boxes automatically to fit their content in active worksheet or all worksheets.

Reset Comment Position
This utility will move all comment boxes back to their initial positions in active worksheet or all worksheets.

Convert Number to Ordinal
With this utility you can easily convert all numbers in selected range to ordinals with just one click.

Find Missing Sequence Number
With this utility, you can quickly find and insert missing sequence numbers, or mark missing sequence numbers by inserting blank rows, adding custom text in a new column, or adding background color.

---

Improvements

1. Super Filter
1.1 Support filtering by text string length in selected range. See screenshot:

1.2 Support filtering by all uppercases, all lowercases, containing uppercase, and containing lowercase in selected range. See screenshot:

2. Rename Multiple Worksheets
2.1 Support filtering worksheets by sheet name;
2.2 Support selecting or unselecting all worksheets at once by one click;
2.3 Move Rename Options section to the right pane;
2.4 Support renaming worksheets with values in same specific cells in different worksheets of current workbook.

3. Unit Conversion
Support converting numbers among BIN, OCT, DEC, and HEX.

4. Advanced Sort
Support sorting date by week or quarter. See screenshot:

5. Export Range to File
Support exporting specified range to PDF file with preserving formatting, row heights, and column widths.

6. Insert Workbook Information
6.1 Support inserting user name at range, header, or footer;
6.2 Support inserting current date and time at range, header, or footer.

7. Add Text
7.1 Support inserting text/characters at multiple specified positions simultaneously;

7.2 Support inserting text/characters before every uppercase, lowercase, letter, or number in selected range.

8. Compare Ranges
Support adding background color or font color to same values or different values. See screenshot:

9. Paging Subtotals
List the first cell value of each column in the Paging Subtotals dialog.

10. Select Cells With Max & Min Value
Support selecting the maximum/minimum value(s) based on each row or each column in specified range.

11. File Format Converter
Support keeping the modified date of original files after conversion.

12. Select Duplicates & Unique Cells
Support adding background color or font color to unique value(s) or duplicate value(s). See screenshot:

13. Insert Sequence Number
13.1 Support inserting recurring sequence numbers;

13.2 Support inserting sequence numbers in merged cells.

14. Copy Page Setup
Adjust the layout in the dialog for easily understanding and applying by users.

---

Fixed

1. Fixed: Opening Excel workbook object in Word applicaiton will crash the Excel applicaiton.

2. Fixed: other minor bugs.