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.
v18.0 [Aug 16, 2018]
New features:
- Super Find: This powerful utility improves the Find function of Excel, it can help you to find and select the cells that matched a specific condition in text strings, comments, formulas, hyperlinks, cell values, and dates. It can find the cells with specific cell formatting as well. This feature can be applied in a selected range of cells, active worksheet, selected worksheets, whole workbook and all opened workbooks.
- Fuzzy Lookup : In Excel worksheet, entering a list of same text manually may contain some typos, with this feature, you can quickly check for the similar records based on character differences, and then correct them to your own text at once.
Improvements:
- Super Filter: Support some new operations for this utility: 1). Improve the condition edit box by adding an OK command button; 2). Insert Refresh option in this latest version. 3). Collect all toolbar features into one drop-down menu.
- Create Mailing List / Send Emails: 1). Support Cc and Bcc when creating a mailing list and sending emails; 2). Support multiple attachments to be inserted into one cell without number limitation while creating a mailing list.
- Support to insert pictures of the local disk when editing message body.
- Add right-click menu in the edit message box.
- Support to save the sent emails to a local folder in SMTP sent mode.
Support to set interval time when sending multiple emails.
- Add a scenario manager for adding and managing multiple email accounts in SMTP sent mode.
- A new status column is created to determine if the email sent successfully in SMTP sent mode.
Fixed:
- Fixed: Matching pictures can only be imported once each time when there are duplicate cell values in the Match Import Pictures utility.
- Fixed: A warning prompt box is always popped out if the first character is not ? character when typing a formula under Custom option in the Operation utility.
- Fixed: The filter result is not correct if there are error values in the filter range of cells when applying the Super Filter feature.
- Other minor bugs.
Mall Creeps
