All categories

Kutools for Excel 21.0

Free Extend the functionality of MS Excel and make it more effective
3.6 
Latest version:
29.20 See all
Developer:

Extend your MS Excel's usability with additional 200+ functions to simplify and boost it. Make it easier and faster to operate with sheets, merging cells, hide and unhide sheets, protect your data, count cells by color, benefit from batch insert and delete actions and other multiple cell operations performed with one click.

The ExtendOffice developer has released a very comprehensive add-in for MS Excel named Kutools for Excel. This handy tool includes more than 200 advanced functions that help you simplify your MS Excel tasks. The add-in is structured in groups with every group having its own functions.

You are now able to combine sheets, merge cells without losing data, paste to only visible cells or batch operations with one click in Excel. It has a pretty neat utility, Track Snap, which can take a snapshot of the current workbook at any time, a Reading Layout View which makes checking and entering data easier, and a Show Worksheets feature that toggles all hidden sheets to be visible.

Moreover, it includes features like Range Converter, which helps you process operations in ranges and cells, and Content Converter, that allows you to execute multiple conversion operations. Other Feature Groups include Editing, Formula, Security, and Filter & Statistic.

I also noticed the addition of new improvements. Most noticeable is the addition of context menu in the Navigation pane, the rename of Clear All Cells Formatting into Clear Characters Formatting and the support of hidden files and folders in the Filename List.

All in all, having numerous and well-structured features, Kutools for Excel helps MS Excel to emerge in one of the richest and complex platforms of its kind.


v21.0 [Oct 29, 2019]
New features:
- Lookup Across Multiple Sheets: Comparing to the VLOOKUP function which can only look for a value from one range, this feature will help Excel users to batch look for multiple values across multiple worksheets at a time easily.
- Lookup and Sum: This feature will find a row or column in the selection based on the given criteria and return the summation of the found row or column.
- Lookup from right to left
- Different from the VLOOKUP function which can only look for a value in the leftmost column of a range, this feature enables you to look for values in any column of a range, and return values in another column as you need.
- Lookup from bottom to top: If there are multiple matched values, the VLOOKUP function will search from top to bottom and return the first matched value. But this feature will reverse the lookup order (from bottom to top) and return the last matched value.
- Lookup between two values: This feature can help to look for a value between two values and return a matched result easily.
- Replace 0 or #N/A with Blank or a Specified Value: If the lookup value is not found or empty, the VLOOKUP function will return #N/A error value or 0. This feature will return empty or a specified value for those unfound lookup values and empty values.
- Dynamic Drop-down List: With this feature, you can quickly create a 2 levels dependent drop-down list or a 3-5 levels dependent drop-down list with several clicks only.
- Colored Drop-down List: With this feature, you can quickly add multiple conditional formatting rules (highlight color) to cells or rows bases on the drop-down list options.
- Multi-select Drop-down List: Normally you can select one option for one cell in the data validation (drop-down list) range in Excel. But after enabling this feature, you can select multiple options for every cell from the drop-down lists.
- Drop-down List with Check Boxes: This feature will add a check box before each drop-down list option. After enabling this feature, you can tick the check boxes to select one or multiple options from the drop-down lists quickly.
- Password Manager: This feature can add and manage passwords, which are used to open password-protected workbooks. After adding passwords in this manager, corresponding workbooks can be opened directly when using Combine Worksheets or other features of Kutools for Excel.
Improvements:
- PivotTable Special Time Grouping: This feature is optimized and enhanced greatly, and be more user-friendly now: Add check boxes before grouping criterions, and support to select multiple grouping criterions at a time. Automatically recognize and select date or time column.
- Create Speedometer Chart: This feature is improved to create more artistic speedometer chart in Excel. Support to manually type in max/min/current values directly when creating static speedometer chart. Decorate the output speedometer chart, and make it more beautiful.
- Navigation Pane: This feature is enhanced greatly and provides a much smoother user experience:
- Displaying the Navigation Pane floatingly, and click the pin button can fix the display back.
- In the Workbook & Sheet Pane, add a toolbar above sheet list to show sheet tools.
- In the Workbook & Sheet Pane, double click the workbook name to rename it.
- In the Workbook & Sheet Pane, add icons to show worksheet protection status and sheet tab colors.
- In the AutoText Pane, support to combine imported AutoText categories.
- In the AutoText Pane, support to sort AutoText categories or AutoText entries by manually dragging and dropping.
- In the Column list Pane, add a toggle button to unhide/hide columns.
- In the Name manager Pane, remind users when modifying a named range and switching to other panes without saving changes.
- Optimize icons, language, etc.
- Super Filter:
- Add a Close the scenario button in the toolbar.
- Support to specify working scope for filter scenarios: Current worksheet, Current workbook, and All.
- When opening a filter scenario in a new worksheet or workbook, users can choose to load and synchronize the opening scenario, or create a new scenario based on the opening scenario.
- Support to wrap long filter criteria.
- Remind users to save filter scenarios when closing the workbook.
- Optimize icons, language, etc.
- Combine Worksheets:
- Support to specify combine mode: combine by row, and combine by column.
- Add the Password feature, with which users can add passwords to open password-protected workbooks directly when combining.
- Send Emails: This feature is enhanced to support using Outlook’s signature settings.
Fix:
- Fixed: Insert Pictures from Path (URL) feature cannot insert pictures from some special website.
- Fixed: Send Emails feature cannot identify some special characters in cells, such as the newline character.
- Fixed: Some dialogs display abnormally with Multi-screen HDPI.
- Fixed other minor bugs.

Suggestions

Microsoft Office Publisher
Microsoft Office Publisher
Free

Creates and distributes custom newsletters

Adobe Acrobat Reader DC
Adobe Acrobat Reader DC
Free

Open, sign, annotate and share PDF files

Nitro Pro
Nitro Pro
Free

Create, sign, edit, secure, and print your PDF documents

Download
Free