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.
v27.0 [Feb 14, 2023]
New features:
- New handy chart templates.
- Dynamic Polyline Chart.
- 2.2- Truncate The Y-axis Chart.
- 2. One-to-many Lookup (returns multiple results).
- 2.2- In addition to just listing all the matches, mathematical operations such as sum, count, product, average, etc., can be performed on all matching values.
- 3. Split Data to Rows.
- This feature is designed to split multiple text entries in a single cell which are delimited with certain character (such as semicolon, space, newline, etc.- into different rows.
- 4. Clear Advanced Drop-down List.
- This feature can be used to clear the scope you set for the Multi-select Drop-down List feature, Drop-down List with Check Boxes feature, and the Searchable Drop-down List feature.
Improvements:
- Replace Any Characters.
- The Replace Accented Characters feature is now renamed as Replace Any Characters. This feature is presented in a new look in this version. It is improved to support:
- Replacing any accented characters with regular characters.
- Converting punctuation marks between Chinese and English.
- Converting characters between full-width and half-width.
- Converting letters between uppercase and lowercase.
- Converting between newlines and spaces.
- Removing all non-printed characters.
- Customizing your own replacement rules.
Add Text:
- This feature has been optimized to have more useful options:.
- Add text before certain text;.
- Add text after certain text;.
- Add text between characters;.
- Add text between every word;.
- Add text around the text.
Remove Characters:
- This feature now supports removing duplicated characters within a cell and keeping only the first occurrences.
- Dynamic Drop-down List.
- This feature now supports creating a 2-5 levels dependent drop-down alphabetically.
- Advanced Drop-down List.
- Transform Range.
- This feature now allows transforming the selected range without preserving the cell formatting, which can make the whole process much faster.
- Apply Date Formatting.
- This feature now allows you to add your custom date formats. And you can modify the date format list to keep only the date formats you need.
- Advanced Combine Rows.
- This feature now has a refreshed look that provides a simpler, more coherent experience that lets you operate more easily. Besides, more useful options are provided:.
- Skip empty cells when combining cells based on criteria in another column;.
- Delete duplicate values when combining cells based on criteria in another column;.
- Combine values with colon when combining cells based on criteria in another column;.
- Count unique values based on criteria in another column；.
- Preview the results of the merge in the dialog box under the Preview tab.
- Click the Sample button to open a sample file to learn how to use this feature.
Sort Sheets:
- This feature now supports reordering worksheets in a workbook including hidden worksheets.
Setting Center:
- A new option “Disable Advanced Drop-down List on Startup” is added to the setting center.
- Re-run Last Utility.
Interface Optimization:
- The following features now have a refreshed look that provides a simpler, more coherent experience that lets you operate more easily.
- Multi-select Drop-down List.
- Drop-down List with Check Boxes.
- Searchable Drop-down List.
- Features under the Super LOOKUP group.
- Hide/Unhide Workbooks and Sheets.
- Select Range Helper.
- Fill Custom List.
- Insert Sequence Number.
- Enable Date Picker.
- Link Sheets (formerly known as Data Association).
- Export Graphics.
- Import Pictures.
- Match Import Pictures.
Big Data Optimization:
- For some features, we have improved the rate of big data processing and the accuracy of results.
- Undo operation: improve the stability.
- Increase the backup speed.
- Other improvements.
Fixed:
- Fixed: Make Up a Number – Handling numbers with two decimal places may lead to calculation errors.
- Fixed: Date picker - The Date Picker dialog box will display when selecting non-date formatted cells.
- Fixed: Data Form – The displayed total does not match the selected number of rows under some special states.
- Fixed: Combine Rows, Columns, or Cells without Losing Data – Formulas are recalculated after merging.
- Fixed: Link Sheets – The dialog box is covered when naming a scenario.
- Fixed: Expand Dynamic Drop-down List – Failure to expand the dynamic drop-down list range in some cases.
- Fixed: Passwords Manager – In some cases, the “automatically fill password” option does not fill in the password correctly.
- Fixed: Convert Time – Filtered columns are also converted when saving the results to another location.
- Fixed: Send Emails – In some cases, the program will get stuck when setting a longer send interval.
- Fixed: Other minor bugs.
Mall Creeps
