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.
v9.0 [May 7, 2015]
New features
1. Add the frequently-used Workbook and Worksheet utilities to the Navigation Pane. See screenshots:
2. Supporting to sort workbooks in the workbook list of Navigation Pane into ascending or descending order. See screenshots:
3. Add the Match Import Pictures utility: you can easily import pictures into cells according to the cell contents now.
arrow blue right bubble Improvements
1. Support sorting worksheets and workbooks when combining Worksheets. Tip: the workbooks and worksheets will be combined according to the order as they displaying in the Workbooks list and Worksheets list. See screenshot:
2. The window size of the Combine Worksheets is adjustable now.
3. Update Danish language.
4. Add some missing SuperTips, and proofreading some interface descriptions.
5. Redesign some icons to make the icons style more unified.
6. Other minor improvements.
arrow blue right bubble Fixed
1. Fixed: the calculation error of the SUMBYFONTCOLOR and SUMBYCELLCOLOR.
2. Fixed: the Excel crash problem caused by the Navigation Pane conflicts with some Add-Ins.
3. Fixed: the problem of popping-up blank description in the Setting Center when registering Kutools for Excel under specific language.
4. Fixed: the problem of invalid Undo for the first time after installing Kutools for Excel.
5. Fixed: the error problem when closing the Supper Filter’s Open saved filter settings scenario.
6. Fixed: type in too many characters in the name of AutoText entries will cause error.
7. Fixed: other minor bugs.
Mall Creeps
