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.
v12.0 [Oct 29, 2015]
New features
1. Adding new useful built-in functions
Kutools for Excel adds a couple of useful functions for easily calculations without remembering formulas.
Count by font bold:
Sum by font bold:
2. Adding new commonly-used built-in formulas
More commonly-used formulas are available now, which including: Find nth occurrence of a character, Count words in range, Count weekends between two dates, Count weekdays between two dates and Count the number of specific weekday.
3. Delete All Inactive Sheets
This utility can easily delete all inactive sheets except current one with clicks. See screenshot:
arrow blue right bubble Improvements
1. Navigation Pane
1.1 All opening Excel windows will be displayed in the Workbook pane of Navigation Pane.
1.2 Adding status bar for the numbers of all sheets, visible sheets and hidden sheets of current workbook at the bottom of Navigation Pane. See screenshot:
2. Split Workbook
2.1 Support splitting current workbook and saving each selected worksheet as a separated PDF file.
2.2 It will display dialog box for you to process when the destination has files with the same names during splitting period. See screenshot:
3. Match Import Pictures
The Match Import Pictures feature supports case sensitive now. See screenshot:
4. Advanced Sort
The Advanced Sort feature supports case sensitive now. See screenshot:
5. Split Cells
You can split cells into multiple rows now. See screenshot:
6. Advanced Find and Replace
6.1 Pressing shortcuts Ctrl Shift F will directly access the Advanced Find and Replace pane of Kutools for Excel. And you can also assign shortcuts Ctrl F in the Navigation Options to access the Advanced Find and Replace pane of Kutools for Excel.
6.2 The Advanced Find and Replace pane of Kutools for Excel is floatable.
7. List All Combinations
7.1 There is a checkbox before each combination entry;
7.2 Pressing shortcuts Alt A will directly add text to the Combination list. See screenshot:
8. Select Nonblank Cells
Displaying the total number of all nonblank cells in selected range. See screenshot:
arrow blue right bubble Fixed
1. Fixed: Fail to register in Office 365 and 2016.
2. Fixed: Cell A1 is selected when no nonblank cells existing in selected range.
3. Fixed: Some errors of the interface language.
4. Fixed: other minor bugs.
Mall Creeps
