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

or

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.


arrow blue right bubble 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.


arrow blue right bubble 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.


arrow blue right bubble Fixed

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

2. Fixed: other minor bugs.


Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial.
kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.