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.
v22.0 [Mar 29, 2020]
Improvements:
- Formula Helper: The Formula Helper is improved greatly to help users filter, find, and apply the formulas easily.
- Formulas are grouped into 5 categories: Date & Time, Statistical, Text, Lookup & Reference, and Math & Trig.
- Add 15 new formulas:
- Count days, hours and minutes between dates.
- Convert days to year month day.
- Convert seconds to hh:mm:ss time format.
- Count cells equal to A, B or C.
- Count cells with two conditions (and).
- Count unique values.
- Count cells with unique values (include the first duplicate value).
- Count the number of values separated by comma.
- Extract the nth word in cell.
- Extract unique values.
- Extract cells with unique values (include the first duplicate value).
- Extract strings between specified text.
- Index and math on multiple columns.
- Find the largest value less than.
- SUMPRODUCT with criteria.
Fixed:
- Fixed: The Speedometer Chart doesn’t support customizing fill color.
- Fixed: The Exact Copy feature cannot copy formulas in some situations.
- Fixed: If there is no active window, errors occur when clicking the Toggle to unhide/hide all hidden worksheets button on the Navigation Pane.
- Fixed: Errors occur when applying the Drop-down List with Check Boxes feature to merged cells.
- Super Filter:
- Fixed: The new added sub-condition groups cannot display.
- Fixed: After saving filter scenarios, the scenarios lost when switching worksheets.
- Fixed: Kutools may cause the welcome screen to disappear in the latest Office 365.
- Fixed: other minor bugs.
