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.
v25.0 [Jun 10, 2021]
New features:
- Smooth Area Chart: By default, area chart has jagged lines when creating by using Excel built-in feature. This Smooth Area Chart feature can help to easily create an area chart with smooth lines by only several clicks.
- Horizontal Waterfall Chart: The Horizontal Waterfall Chart helps to easily generate a horizontal waterfall chart or a mini horizontal waterfall chart in Excel.
- Interval Label Bar Chart: The Interval Label Bar Chart can generate a bar chart with category labels above the bar which help free up more chart space.
- Stacked Difference Chart: The Stacked Difference Chart feature generates a bar or column chart to compare two sets of data. With this type of chart, you can easily figure out whether the data are growing or falling during a certain period, and know the exact amount of change in the data.
- Price Tag Chart: This Price Tag Chart feature generates a chart looks like a price tag, which acts like a column chart but the appearance is more novel and beautiful.
- Check Box Line Chart: When using a line chart to compare many sets of data, the chart looks mussy because there are too many polylines in the chart. The Check Box Line Chart feature helps to generate a dynamic line chart with check boxes in Excel. You can decide which lines to be displayed in the chart by just checking the corresponding check boxes in order to keep the chart clean and easy to analyze.
- Multi-condition Lookup: This Multi-condition Lookup feature helps to look up values in different columns with 2 or more criteria with several clicks only.
- Data Association: The Data Association demonstrates a real-time filtering of worksheets between two Excel workbooks. After configuring this feature, clicking on any cell in the key column of primary worksheet will correlate the data in secondary worksheet and filter the corresponding data immediately.
- Insert QR Code: The Insert QR Code feature can generate QR codes based on specific cell values easily.
- Drop-down List: This version adds several drop-down list related features for you to handle drop-down list easily.
- Encrypt Workbook: The Encrypt Workbook feature can encrypt a batch of workbooks which saved in the same or different folders in current device or OneDrive with the same password at the same time.
- Decrypt Workbook: The Decrypt Workbook feature helps to decrypt a batch of workbooks which saved in the same or different folders in current device or OneDrive with specified password.
- Korean Language Pack: This version supports Korean language now.
Improvements:
- Split Workbook.
- Advanced Sort.
- Split Data.
- Export Range to File.
- Passwords Manage.
