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.
v24.0 [Jan 19, 2021]
New features:
- Project Status Spectrum Chart.
- Project Status Bead Chart.
- Progress Pie Chart.
- Radial Bar Chart.
- Alternative Rose Chart.
- Nightingale Chart.
- Bidirectional Histogram Chart.
- Multiple Series Line Chart.
- Multi Layer Column Chart.
- Forecast Chart.
- Threshold Value Area Chart.
- Rectangular Pie Chart.
- Half Pie Chart.
- Add Poly Line.
- Detach Chart.
- Date Picker.
- Mark Keyword.
- Show Classic Menu on Quick Access Toolbar.
- Convert date to serial date.
- Convert date to quarter.
- Sum based on the same text.
- Cell contains specific text then return value.
- Abbreviated Name .
- Connected value by specific character (string).
- Calculate days in year.
- Calculate days in month.
Improvements:
1. Extract Text: In the latest version, the Extract Text feature has been improved greatly to handle most of extracting needs:
- Extract the first N characters, says extract the first 10 characters from the left of each cell in the specified range;.
- Extract the last N characters, says extract the last 6 characters from the right of each cell in the specified range;.
- Extract characters in the specified position range, says extract from the 5th character to the 12th character from each cell in the specified range;.
- Extract characters before a given text, says extract all characters before the first blank from each cell in the specified range;.
- Extract characters after a given text, says extract all characters after the first blank from each cell in the specified range;.
- Extract all numbers from each cell in the specified range.
- The feature supports to use formulas to extract the characters. That means the extracted results are dynamic, and they can update automatically based on the original cells in the specified range.
- (Kutools) Search: Support to disable the “ALT S” shortcuts to enable the (Kutools) Search feature.
- Multi-select Drop-down List: Support to remain the activated status you set in the last closed workbook.
- Drop-down List with Check Boxes: Support to record the activated status you set in the last closed workbook.
- Dumbbell Plot Chart: Support to fill the bars between dots with two colors, so that you can quickly identify the difference is positive or negative between the two sets of values.
- Multi Series Histogram Chart: In the latest version, the Multi Series Histogram Chart also supports to create a multi-series bar chart.
- Progress Ring Chart: The Progress Ring Chart has optimized the chart style, and now it adds 3 chart styles for our users.
- Reading Layout: The Reading Layout feature is improved to support highlighting the area of the active cell. However, the Highlight the area of active cell option is disabled by default.
- Copy Ranges: In the latest version, the Copy Ranges feature is enhanced to copy multiple ranges ignoring the hidden rows and columns.
- Find and Break Broken Links: The Find and Break Broken Links feature has been improved greatly in the latest version. Now it not only supports to find and break links to cells of other workbooks, but also supports to find and break links to PivotTables, shapes, and name ranges.
- Setting Center: Enhance the repairing feature to solve the problem of loading failure.
Fixed:
- Fixed: Some minor bugs occur when applying the AutoText feature in the Navigation Pane.
- Fixed: Some bugs occur when looking for comments with username in the Super Find Pane.
- Fixed: Some formula errors come out when creating dynamic drop-down list in non-English environments.
- Fixed: The Average line added by the Add Line to Chart tool cannot update automatically.
- Fixed: Some minor bugs occur in the Super Filter Pane.
- Fixed: When adding OneDrive folders in the Combine Worksheets dialog, their subfolders are ignored.
- Fixed: Some features cannot save the custom-defined colors.
- Fixed: Barcodes cannot be inserted due to blank or special characters existing in the worksheet names.
- Fixed: In the latest Office 365, the Export Range to File feature cannot export a selection to simple HTML file because the total number of characters in some cells of the selection is greater than 255.
- Fixed: The Work Area feature probably cannot work in Excel 2013 and later versions.
- Fixed: The Reading Layout feature may cause lockup when copying and pasting to other worksheets in some cases.
- Fixed: The Monitor Precedents and Dependents feature lead to copying and pasting failures in some situations.
- Fixed: OneDrive folders cannot be found in some situations.
- Other minor bugs..
