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.
v17.0 [Mar 26, 2018]
- Tables Merge
This powerful utility can help you to merge two tables in a workbook or two separate workbooks based on matching columns. With this feature, you can update data in the main table based on the new lookup table, add new columns after the main table and insert all non-matching or duplicate matched rows from the lookup table to the main table.
- Special Filter
The Special Filter feature gathers all frequently-used filter functions to help you improve your work efficiency.
- Improvements
The Enterprise tab is renamed as Kutools Plus.
The edit box is improved to support
Enabling/disabling/deleting the existing criterion.
Adjusting the form size by dragging the border.
- Look for a value in the list
Supporting to type the column number of the returned lookup value directly.
- Fixed
Fixed: A prompt box will pop out to remind worksheets creating failing when blank cell existing in the selected range of the Create Sequence Worksheets utility.
Fixed: The inactive excel files will be locked when applying the Paste to Visible Range feature.
Fixed: Invalid email addresses cannot be recognized when sending emails by the Send Emails utility.
Other minor bugs.
Mall Creeps
