Softpedia >Windows >Office tools >Other Office Tools >Kutools for Excel >  Changelog

Kutools for Excel Changelog

What's new in Kutools for Excel 30.00

Mar 13, 2024
  • New feature:
  • Kutools AI Aide:
  • This powerful AI-driven feature revolutionizes how you interact with Excel, offering an unprecedented level of support and automation.
  • doc KTE 30.00 ai 1
  • Here's what the Kutools AI Aide can do for you:
  • Intelligent Execution of Operations: It can automate and intelligently execute operations within Excel with just a simple command. The gif image below demonstrates how Kutools AI Aide automatically changes all text in a selection to uppercase.
  • Generate Custom Formula: Instantly generate customized formulas by simply describing the desired calculation. The gif image below demonstrates how Kutools AI Aide generates a formula to find the exact location of the maximum value cell in a certain range.
  • Invoke matching Kutools for Excel functions based on your specific requirements: This smart feature understands your task needs and seamlessly integrates with the extensive Kutools toolkit to provide tailored solutions, ensuring that you have the right tool at your fingertips for any Excel challenge. As shown in the gif image below, if you need to split names into first and last names, Kutools AI Aide will call the Split Names feature of Kutools for Excel for you to accomplish the task.
  • Data Analysis and Chart Creation: It helps to Analyze data within a specified range and creates appropriate charts based on the results.
  • Create Custom Functions: This AI Aide can generate customized functions to meet your specific needs. Such as making a function to count the number of cells with a specific font color (like red).
  • Write VBA Code: Whether you're new to VBA or a seasoned pro, the AI Aide can write or help refine your VBA scripts, making automation and customization easier than ever.
  • Provide Operational Guidance: It provides step-by-step assistance on a wide range of operations, ensuring you always know how to proceed.
  • Fulfill Other Common Needs: From text translation to function parsing, the AI Aide caters to a variety of common requirements, enhancing your Excel experience.

New in Kutools for Excel 29.30 (Feb 27, 2024)

  • Improvements:
  • Advanced Drop-down List:
  • Advanced drop-down list: the Multi-select Drop-down List feature, the Drop-down List with Check Boxes feature, and the Make Drop-down List Searchable feature have undergone the following improvements:
  • Supports moving the drop-down list window by dragging.
  • Supports hiding the drop-down list window when you are not using these features temporarily. The drop-down list window will be displayed as a square with a drop-down icon. Simplified the settings in the dialog box when applying these features.
  • Quickly Create a Dropdown List:
  • This feature has been optimized to offer a more streamlined user interface, making it more convenient to use.
  • Advanced Dropdown List Manager:
  • This feature, formerly known as Clear Advanced Drop-down List, has been renamed and optimized with the following improvements:
  • Supports viewing created advanced drop-down lists.
  • Supports modifying created advanced drop-down lists.
  • Split Cells:
  • This feature has been optimized to increase the running speed when processing large amounts of data.
  • Split Names:
  • This feature has been optimized to increase the running speed when processing large amounts of data.
  • Extract Email Address:
  • This feature has been optimized to increase the running speed when processing large amounts of data.

New in Kutools for Excel 27.00 (Feb 10, 2023)

  • Improvements:
  • Password Manager: When opening a workbook encrypted with a password, Kutools' Password Manager will appear in the Password dialog box even if the "Automatically Fill Password" option is not enabled
  • Compare Worksheets: Optimized interface, improved processing logic
  • Optimized startup speed, and improved stability and compatibility
  • Fixed:
  • Fixed: The “Make Up a Number” feature does not work correctly when handling decimals in some cases
  • Fixed: Errors occur when applying the “Dynamic Ranking Bar Chart” feature in some languages other than English
  • Fixed: Applying the “Split Data” feature to a vast data worksheet may cause errors
  • Fixed: Applying the “Split Workbook” feature may cause errors in some cases
  • Fixed: When renaming worksheets using the "Rename Worksheet" feature, special characters in the new name may cause errors
  • Fixed: Errors occur when using VBA to call Kutools features in some cases
  • Fixed: Other minor bugs

New in Kutools for Excel 22.00 (Aug 24, 2020)

  • New features:
  • Step Chart:
  • The Step Chart feature can show the data trend at irregular intervals in a chart based on the specified horizontal (category) axis labels and series values in Excel
  • Target and Actual Chart:
  • The Target and Actual Chart feature can compare the target values and the actual values in a chart It can compare one or multiple sets of data series in a chart, and show the actual values in the style of lines or columns as well
  • Bullet Chart:
  • The Bullet Chart feature can help you quickly compare the actual value, target value, and qualitative ranges of performances (says poor, average, and good, etc) horizontally or vertically It also supports to compare several sets of data series too
  • Vertical bullet chart:
  • Thermometer Chart:
  • The Thermometer Chart feature can help you easily compare the current value and the target value And this feature supports to show the vertical axis as percentage
  • Gantt Chart:
  • With this Gantt Chart feature, you can quickly create a Gantt chart with specifying the tasks, start dates, and end dates (or durations) in Excel
  • Timeline Chart:
  • This Timeline Chart feature enables you to easily create a timeline chart with only 3 steps in Excel, and display the chronological sequence of past or future events on the timescale
  • Color Grouping Chart:
  • This Color Grouping Chart feature can create a column or bar chart, and change fill color for special data points (columns or bars) based on the specified grouping ranges
  • Comparison Bar Chart:
  • This Comparison Bar Chart feature can help you quickly compare two sets of series values, and show the differences of two sets of series values in a bar chart This feature also supports to show the differences with arrows instead of bars
  • Column Chart with Percentage Change:
  • Comparing to normal column charts, this Column Chart with Percentage Change feature can help you create a column chart and mark the changes between every two adjacent columns with green rising arrow or red declining arrow
  • Stacked Chart with Percentage:
  • This Stacked Chart with Percentage feature can not only create a stacked column chart, but also add data label as percentage for every data point
  • Color Chart by Value:
  • With this Color Chart by Value feature, you can easily change the fill color of data points based on the specified data range This feature works well with the clustered column charts and clustered bar charts in Excel
  • Add Line to Chart:
  • This Add Line to Chart feature can quickly add an average line or a line based on a specified value to the selected chart
  • kte-22-13png
  • Create Simple Drop-down List:
  • This Create Simple Drop-down List feature simplifies the process of creating a drop-down list by Excel’s built-in feature, and enables you to get it done with only two steps
  • Date & Time Helper:
  • With this Date & Time Helper feature, you can easily add or subtract years, months, weeks, days, hours, minutes, or seconds from a date/time, and calculate age, date difference, or time difference between two dates/time
  • kte-22-15png
  • Share to:
  • Kutools for Excel 2200 supports to share the whole add-in or a certain feature to friends via email, Facebook, Twitter, Linkedin, and Weibo
  • Click Kutools > Share to to share Kutools for Excel to friends
  • Enable a feature, says Navigation Pane, then click the Share button to only share this feature to friends
  • Feedback:
  • Kutools for Excel 2200 supports users to submit suggestions and operation errors to our developing team directly
  • Improvements:
  • Formula Helper:
  • The Formula Helper is improved greatly to help users filter, find, and apply the formulas easily
  • Formulas are grouped into 5 categories: Date & Time, Statistical, Text, Lookup & Reference, and Math & Trig
  • Add 15 new formulas:
  • Count days, hours and minutes between dates
  • Convert days to year month day
  • Convert seconds to hh:mm:ss time format
  • Count cells equal to A, B or C
  • Count cells with two conditions (and
  • Count unique values
  • Count cells with unique values (include the first duplicate value
  • Count the number of values separated by comma
  • Extract the nth word in cell
  • Extract unique values
  • Extract cells with unique values (include the first duplicate value
  • Extract strings between specified text
  • Index and math on multiple columns
  • Find the largest value less than
  • SUMPRODUCT with criteria
  • Supports to filter formulas in the Formulas Helper dialog
  • Dependent Drop-down List:
  • The Dependent Drop-down List feature supports create 2-levels dependent drop-down lists in horizontal direction.
  • Multi-select Drop-down List:
  • When opening the Multi-select Drop-down List dialog, it will automatically specify the same Apply to settings as you configured last time.
  • Drop-down List with Check Boxes:
  • When opening the Drop-down List with Check Boxes Settings dialog, it will automatically reuse the Apply to settings you configured last time
  • Uses two different interfaces for the Modify mode and Append mode
  • Supports to change the size of drop-down list form by dragging.
  • Beautify the Normal Distribution / Bell Curve chart
  • The Combine Worksheets feature supports OneDrive files and folders
  • The Super Filter feature optimizes the loading efficiency of scenarios
  • Change the language calling way, and speed up the display of forms
  • Adjust positions of some features on the Ribbon, and change some feature names and super tips
  • Optimize and improve other features
  • Fixed:
  • Fixed: The Speedometer Chart doesn’t support customizing fill color
  • Fixed: The Exact Copy feature cannot copy formulas in some situations
  • Fixed: If there is no active window, errors occur when clicking the Toggle to unhide/hide all hidden worksheets button on the Navigation Pane
  • Fixed: Errors occur when applying the Drop-down List with Check Boxes feature to merged cells
  • Super Filter:
  • Fixed: The new added sub-condition groups cannot display
  • Fixed: After saving filter scenarios, the scenarios lost when switching worksheets
  • Fixed: Kutools may cause the welcome screen to disappear in the latest Office 365
  • Fixed: other minor bugs

New in Kutools for Excel 20.00 (Jul 19, 2019)

  • New Features:
  • Insert Pictures from Path(URL):
  • With this handy utility, you can quickly insert multiple pictures in bulk based on the file paths or URL of these pictures. In addition, you can preset the sizes of inserted pictures in three ways: original size, fixed height, and fixed width.
  • Improvements:
  • Navigation Pane:
  • Add new options and operations for this feature:
  • Support to filter AutoText entries by entry names in AutoText Pane.
  • Support to display the text type of AutoText entries with the large font in the AutoText Pane.
  • Add the Select All button to select all AutoText entry groups simultaneously, and the Inverse button to inverse selections at the same time when exporting AutoText entries.
  • Press Win + Shift + Q keys simultaneously to call the Find and Replace Pane.
  • Press Win + Shift + A keys simultaneously to switch between the current sheet and the last opening one.
  • View Options:
  • Add the Disable research pane option in the View Options dialog.
  • Select Specific Cells:
  • Support to select an entire row or column only in the selection.
  • Convert Name to Reference Range (Replace Range Name):
  • The Replace Range Names feature has been renamed as Convert Name to Reference Range, and it’s improved to convert all same names which are working in different scopes to their reference ranges.
  • Encrypt / Decrypt Cells:
  • Add a mask to cover the encrypted cells:
  • Don’t set mask. After encrypting, A long string mixed with letters and numbers will cover each decrypted cell.
  • Set a character as a mask. After encrypting, this character will display repeatedly to cover each encrypted cell.
  • Set a special string as a mask. After encrypting, this string will cover each encrypted cell automatically.
  • Super Filter:
  • Add more filter criterions for this feature:
  • Support to filter cells by error types, such as #NULL!, #REF!, etc.
  • Support to filter cells that don’t begin with or end with a special character or text string.
  • Sort Sheets:
  • Support to sort all sheets, including the hidden ones.
  • Provide installation package for Non-administrator user accounts.
  • Fixed:
  • Fixed: Some screen tips are incorrect.
  • Fixed: The Snap feature does not work with OneDrive.
  • Fixed: The Formula Helper feature cannot return to the current selection correctly or go nt automatically when selecting ranges from other workbooks.
  • Fixed: Some windows display incorrectly when zooming within the high definition screen.

New in Kutools for Excel 18.00 (Mar 16, 2019)

  • 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:
  • Improve the condition edit box by adding an OK command button
  • Insert Refresh option in this latest version
  • Collect all toolbar features into one drop-down menu
  • Create Mailing List / Send Emails:
  • Support Cc and Bcc when creating a mailing list and sending emails;
  • 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
  • Reading Layout:
  • Add Highlight the area of active cell option in the Reading Layout Settings dialog box, the active cell will not be highlighted by un-checking it.
  • Insert Random Data:
  • It supports to insert decimal numbers now
  • Insert Watermark:
  • Support to insert the image watermark based on the picture scale;
  • Support the preview feature in Insert Watermark dialog box.
  • Column list:
  • Columns can be rearranged by clicking the move Up or Down arrows in the toolbar;
  • Columns can be rearranged by dragging the column record in the Column list pane.
  • 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.

New in Kutools for Excel 17.00 (Aug 16, 2018)

  • New features:
  • Tables Merge:
  • This powerful utility can help you to merge two tables in a workbook or two separate workbooks based on matching columns. With this feature, you can update data in the main table based on the new lookup table, add new columns after the main table and insert all non-matching or duplicate matched rows from the lookup table to the main table.
  • Update the existing data in the main table and add non-matching or duplicate matched rows to the end of the main table based on the lookup table
  • Add a new column from the lookup table and put non-matching or duplicate matched rows at the end of the main table. See screenshot:
  • Update the main table and add a new column as well based on the lookup table. See screenshot:
  • Special Filter:
  • The Special Filter feature gathers all frequently-used filter functions to help you improve your work efficiency.
  • Filter Bold:
  • With this feature, you can filter all cells based on bold characters in the column of the active cell with only one click, see screenshot:
  • Filter Italic:
  • This utility can help you quickly filter all cells based on italic characters in the column of the active cell, see screenshot:
  • Filter Strikethrough:
  • One click to filter all cells based on strikethrough data in the column of the active cell, see screenshot:
  • Filter Comment:
  • This feature can help you to filter all cells that contain comment in the column of active cell quickly, see screenshot:
  • Filter Formula:
  • With this utility, you can filter all cells that contain formula in the column of the active cell with only one click. See screenshot:
  • Filter Merged:
  • With this utility, you can filter out all merged cells in current column:
  • This utility can also help to filter all merged cells in a current column based on specified cell content:
  • Filter Uppercase Text:
  • With this handy feature, you can filter all uppercase text cells in a selected column as the following screenshot shown:
  • Filter Lowercase Text:
  • This quick feature can help you filter all lowercase text cells in a selected column at once
  • Filter Text length equal to:
  • With this utility, you can quickly filter all cells based on specified text length in a selected column, see screenshot:
  • Filter Font Color:
  • This simple feature can help you to filter all cells based on specific text font color in a selected column, see screenshot:
  • Filter Background Color:
  • This utility can help you to filter all cells based on specific background color in a selected column, see screenshot:
  • Filter by date:
  • With this useful feature, you can quickly filter all cells based on weekend, workdays or a specified day of the week as you need, see screenshot:
  • Improvements:
  • The Enterprise tab is renamed as Kutools Plus, see screenshot:
  • Super Filter:
  • The edit box is improved to support:
  • Enabling/disabling/deleting the existing criterion;
  • Adjusting the form size by dragging the border. See screenshot:
  • Look for a value in the list:
  • Supporting to type the column number of the returned lookup value directly, see screenshot:
  • Fixed:
  • Fixed: A prompt box will pop out to remind worksheets creating failing when blank cell existing in the selected range of the Create Sequence Worksheets utility.
  • Fixed: The inactive excel files will be locked when applying the Paste to Visible Range feature.
  • Fixed: Invalid email addresses cannot be recognized when sending emails by the Send Emails utility.

New in Kutools for Excel 16.00 (Aug 28, 2017)

  • NEW FEATURES:
  • Insert Bullet:
  • Quickly insert bullet symbols or bulleted list to multiple cells at once
  • Insert Numbering:
  • With this feature, you can insert list of numbering into multiple cells quickly and easily
  • Remove time from date:
  • Quickly and easily remove time from the date time format cells, and only leave date format
  • Toolbar Mode:
  • You can change to different toolbar mode according to your computer screen resolution. If you have higher computer screen resolution, you can choose to use the Medium or Wide toolbar mode. By doing this, it will display more functions in your Ribbon interface
  • Off-line html help document is available:
  • The Help document has been added for Kutools for Excel in this version. You can access the off-line help document as follows arrow blue right bubble
  • IMPROVEMENTS:
  • Currency Conversion:
  • Adding the currency abbreviations before each currency in the dialog box to make this feature more clearly and intelligibly, see screenshot:
  • Add traditional Chinese language support.
  • arrow blue right bubble Fixed
  • Fixed: Large filtered data may be caused Excel crashed when Reading Layout feature enabled.
  • Fixed: Error occurs when typing blank characters in Prevent typing textboxes.
  • Fixed: Other minor bugs.

New in Kutools for Excel 15.00 (Oct 24, 2016)

  • NEW FEATURES:
  • Remove Leading Zeros:
  • One click to remove all leading zeros from selected text format cells at once.
  • Print Specified Pages:
  • This feature can help you to print specified pages of current worksheet, such as odd pages, even pages, custom pages and so on.
  • IMPROVEMENTS:
  • Paste to Visible Range:
  • This feature is now able to only copy and paste cell values to visible range.
  • FIXED:
  • Kutools for Excel is compatible with EMET5.5 now.
  • Other minor bugs

New in Kutools for Excel 14.00 (Oct 24, 2016)

  • Compare Cells:
  • This utility can help you to compare cell values in two ranges, then select the same or different cells in Range A based on the cell values in Range B. And you can choose to indicate all selected cells with the background color or font color.
  • Prevent special characters:
  • With this feature, you can prevent special characters such as @#$%^&*…from entering in a specified range, and only allow entering numbers and letters
  • Prevent specific characters:
  • This utility helps you easily prevent specified characters from entering in a selected range.
  • Allow only specific characters:
  • With this feature, only your specified characters can be typed into a range of cells.
  • Conversion of Number Systems:
  • This utility helps you quickly convert between the number systems, such as convert binary to octal, convert decimal to hex, convert hex to ASCII, etc and vice versa.
  • IMPROVEMENTS:
  • Select Same & Different Cells:
  • The original Compare Ranges feature is renamed as Select Same & Different Cells and moved to the Select group now.
  • Supports comparing two ranges based on single cell.
  • Prevent Duplicate:
  • Supports large selected range instead of single column.
  • It is optional to process or ignore formula cells in selected range during the operation of some Kutools features.
  • FIXED:
  • Fixed: The Super Filter feature can’t filter correctly when the criteria contain special characters.
  • Fixed: No preview results display in the Apply Date Formatting dialog box if selected cells contain formula.
  • Fixed: Error occurs to some utilities if array formulas existing in worksheet.
  • Fixed: Error dialog box will pop up when selecting an object to paste the calculated result with the Kutools Calculator.
  • Fixed: Other minor bugs.

New in Kutools for Excel 13.00 (Aug 25, 2016)

  • New features:
  • Insert Watermark
  • Delete Watermark
  • Hide / Unhide Range Name
  • Add Border to Each Page
  • Improvements:
  • Combine Worksheets:
  • Support combining CSV files and worksheets/workbooks.
  • To include or exclude filtered data during in the final combined file.
  • Trace Precedents and Dependents:
  • The Trace Precedents and Trace Dependents features have been renamed and rearranged.
  • Delete Blank Rows:
  • To enhance the running speed of deleting blank rows when encountering much useless blank rows at the end of worksheet.
  • Fixed:
  • Select only one cell to extract text will cause wrong extracted result
  • A saving dialog box will pop up when exporting range to PDF file
  • Reading Layout cannot work after restoring snapshot in workbook
  • Some Kutools for Excel’s self-defined functions cannot work after restoring snapshot in worksheet
  • The Combine multiple worksheets from workbooks into one workbook feature can’t combine Macro-Enabled workbooks
  • Pictures will be disappeared in the final combined workbook
  • Wrong folders will display in the File Format Conversion dialog box caused by authority problem
  • The converted result and final report are inconsistent after converting workbooks to PDF files
  • Even though workbooks cannot be converted successfully, the source files are deleted
  • A column with totally same value cells can also be sorted with the Advanced Sort feature

New in Kutools for Excel 12.5.0.228 (Mar 3, 2016)

  • New features:
  • Subscript numbers in Chemical Formulas
  • One click to subscript mass numbers in selected chemical formulas.
  • Average / Count / Sum visible cells only:
  • Kutools for Excel adds three useful built-in functions to easily sum / count / average visible cells only with ignoring any hidden or filtered cells in Excel.
  • Find most common value:
  • This new collected Find most common value formula can quickly find the most common / frequent text string or number from the specified list.
  • Trace Precedents and Dependents:
  • Trace Precedents and Dependents utility traces the precedents or dependents of active cell or selected range in real time.
  • arrow blue right bubble Improvements
  • Split Cells:
  • Split cells by text and number
  • The Split Cells utility now supports to separate the texts and numbers mixed in one cell / column into two cells/columns.
  • Split cells by specified width:
  • It allows splitting cell / column by specified width.
  • Currency Conversion:
  • You can specify the decimal places for output values in Currency Conversion utility. See screenshot:
  • KTE 12.50 8
  • Insert Workbook Information:
  • Support to insert current workbook’s created date (and time) and modified date (and time) into cells, header, or footer. See screenshot:
  • KTE 12.50 9
  • Compare Ranges:
  • Add case-sensitive support for comparison between to two lists / columns. See screenshot:
  • Select Duplicate & Unique Cells:
  • Add case sensitive support for selecting duplicate values or unique values from a list/column.
  • Advanced Find and Replace;
  • Press the Tab key will move the cursor orderly in the Find and Replace Pane.
  • Change the default search scope to active sheet within the Find and Replace pane.
  • Change the hotkeys to Win + W for activating the Advanced Find and Replace feature.
  • Select Cells with Error Value:
  • A dialog box will come out and show how many cells with error values have been found and selected.
  • Don’t Prompt Today dialog box:
  • Dialog box which warns users current operation does not support undo allows prompt one time a day only.
  • Convert Time:
  • Support to convert [h]:mm:ss time format (such as 37:30:55) to hours, minutes, or seconds. See screenshot:
  • KTE 12.50 14
  • Track Snap:
  • Add name support for each snapshot of the workbook you take.
  • Add Czech language.
  • arrow blue right bubble Fixed
  • Fixed: Inaccuracy occurs when converting negative numbers and 0 to ordinal numbers.
  • Fixed: If workbook name contains brackets, error will occur when printing multiple selections.
  • Fixed: Error occurs when inserting page break every row.
  • Fixed: Freeze panes multiple workbooks feature and Unfree panes multiple worksheets feature don’t work in Page Break Preview View.v
  • Fixed: AutoText entries cannot be inserted accurately in some special conditions.
  • Fixed: The conversions between Gallon and Liter are wrong in Excel 2010 and higher versions.
  • Fixed: Error occurs when selecting ranges from other workbooks with the Compare Ranges feature.
  • Fixed: Multiple dialog boxes come out when clicking the Advanced Combine Rows feature many times.
  • Fixed: Error occurs when filtering by weekday with the Super Filter feature.

New in Kutools for Excel 11.00 (Aug 24, 2015)

  • New feature
  • Formulas: Kutools for Excel lists some commonly-used formulas for easily calculations with only several clicks
  • Select Unblank Cells: This utility can help you easily select all cells with content from selected range by just one click.
  • List all combinations: This utility is designed to list all combinations of specified series of data, and users can customize separators for combinations.
  • Print First Page of Each Worksheet: With this utility you can quickly print every first page of each worksheet one by one easily.
  • Print Pages in Reverse Order: This utility will reverse the printing order and print from the last page to the first one.
  • Insert Page Break Every Row: This utility will insert page break after every x rows (specified numbers of rows) in current worksheet.
  • Split Cells: This Split Cells utility can easily split a list of data to multiple columns by space, new line, semicolon, or custom separators.
  • AutoFit Comment: This utility will resize all comment boxes automatically to fit their content in active worksheet or all worksheets.
  • Reset Comment Position: This utility will move all comment boxes back to their initial positions in active worksheet or all worksheets.
  • Convert Number to Ordinal: With this utility you can easily convert all numbers in selected range to ordinals with just one click.
  • Find Missing Sequence Number: With this utility, you can quickly find and insert missing sequence numbers, or mark missing sequence numbers by inserting blank rows, adding custom text in a new column, or adding background color.
  • Improvements:
  • Super Filter: Support filtering by text string length in selected range; support filtering by all uppercases, all lowercases, containing uppercase, and containing lowercase in selected range.
  • Rename Multiple Worksheets: support filtering worksheets by sheet name; support selecting or unselecting all worksheets at once by one click; move Rename Options section to the right pane; support renaming worksheets with values in same specific cells in different worksheets of current workbook.
  • Unit Conversion: Support converting numbers among BIN, OCT, DEC, and HEX.
  • Advanced Sort:Support sorting date by week or quarter.
  • Export Range to File: Support exporting specified range to PDF file with preserving formatting, row heights, and column widths.
  • Insert Workbook Information: Support inserting user name at range, header, or footer; support inserting current date and time at range, header, or footer.
  • Add Text: Support inserting text/characters at multiple specified positions simultaneously; support inserting text/characters before every uppercase, lowercase, letter, or number in selected range.
  • Compare Ranges: support adding background color or font color to same values or different values.
  • Paging Subtotals: List the first cell value of each column in the Paging Subtotals dialog.
  • Select Cells With Max & Min Value: Support selecting the maximum/minimum value(s) based on each row or each column in specified range.
  • File Format Converter: support keeping the modified date of original files after conversion.
  • Select Duplicates & Unique Cells: support adding background color or font color to unique value(s) or duplicate value(s).
  • Insert Sequence Number: Support inserting recurring sequence numbers; support inserting sequence numbers in merged cells.
  • Copy Page Setup: adjust the layout in the dialog for easily understanding and applying by users.
  • Fixed:
  • Opening Excel workbook object in Word application will crash the Excel application.
  • Other minor bugs.

New in Kutools for Excel 10.00 (Aug 24, 2015)

  • New feature:
  • Batch Remove All Macros: This utility will batch remove all macros in all specified workbooks, no matter these workbooks are open or not.
  • Improvements:
  • Combine worksheets: Support inserting worksheets’ information as comments at the first row of each range. It will pop up a warning dialog if the combined worksheet will exceed the worksheet size (1,048,576 rows by 16,384 columns). The processing bar will display the workbooks name which is being processed.
  • Split Workbook: Support saving split worksheets as independent workbooks (.xlsx or .xls), text files (.txt), or CSV files (.csv).
  • Fixed:
  • The Columns utility and Worksheets utility are not available when Navigation Pane is off.
  • Only used range is highlighted when enabling Highlight Unlocked utility and unlocking all cells in current worksheet.
  • When there is no opening workbook, error occurs by clicking the Workbook tool in the Navigation Pane.
  • Other minor bugs.

New in Kutools for Excel 9.00 (Aug 24, 2015)

  • New features:
  • Add the frequently-used Workbook and Worksheet utilities to the Navigation Pane.
  • Supporting to sort workbooks in the workbook list of Navigation Pane into ascending or descending order.
  • Add the Match Import Pictures utility: you can easily import pictures into cells according to the cell contents now.
  • Improvements:
  • Support sorting worksheets and workbooks when combining Worksheets. Tip: the workbooks and worksheets will be combined according to the order as they displaying in the Workbooks list and Worksheets list.
  • The window size of the Combine Worksheets is adjustable now.
  • Update Danish language.
  • Add some missing SuperTips, and proofreading some interface descriptions.
  • Redesign some icons to make the icons style more unified.
  • Other minor improvements.
  • Fixed"
  • The calculation error of the SUMBYFONTCOLOR and SUMBYCELLCOLOR.
  • The Excel crash problem caused by the Navigation Pane conflicts with some Add-Ins.
  • The problem of popping-up blank description in the Setting Center when registering Kutools for Excel under specific language.
  • The problem of invalid Undo for the first time after installing Kutools for Excel.
  • The error problem when closing the Supper Filter’s Open saved filter settings scenario.
  • Type in too many characters in the name of AutoText entries will cause error.
  • Other minor bugs.

New in Kutools for Excel 8.0.0.0 (Jan 20, 2015)

  • New features:
  • Worksheet Design:
  • It will display all Worksheet Design tools in a separate tab. It includes following tools or features:
  • A. Selection Lock: it will lock the selection when the worksheet is protected by a password.
  • B. Selection Unlock: it will unlock the selection even though the worksheet is protected by a password.
  • C. Highlight Unlocked: it will highlight the unlocked cells of the worksheet.
  • D. Formulas Hide: it will hide the formulas in the selection when the worksheet is protected.
  • E. Formula Unhide: it will unhide the formulas in the selection even though the worksheet is protected.
  • F. Highlight Hidden: it will highlight all cells, which have been configured to hide formulas when the worksheet is protected.
  • G. Protect Sheet: using a password to protect the worksheet.
  • H. Highlight Formulas: it will highlight all cells, which include formulas in the worksheet.
  • I. Highlight Names: it will highlight all names ranges in the worksheet.
  • J. Settings: options for worksheet design tools.
  • Unprotect the worksheet before opening design tools:
  • If you want to apply the tools or features of worksheet design to a protected worksheet and this option is checked, it will try to unprotect the protected worksheet with the password you have entered in Use Password box.
  • Protect the worksheet before closing design tools (if it turns out to be protected):
  • After designing a protected worksheet with the worksheet design tools or features, this option will automatically use the password of Use Password box to protect the worksheet.
  • With these two options, you don’t need to manually:
  • 1. Unprotect a protected workbook before designing it
  • 2. Protect it again after designing it.
  • You just need to specify the correct password for unprotecting / protecting the worksheet in Use Password box and mark these two options checked.
  • Super Functions:
  • It only includes some functions, right now. We will try to add more useful function in upcoming versions. If there are some functions you want to add, please contact us at sales#extendoffice.com. (Please replace # with @)
  • AutoText Pane:
  • AutoText can be used to store contents, such as Charts, formulas, ranges and so on. With this feature, you can quickly design worksheet without retyping certain contents over and over again.
  • Paste to Visible Range:
  • With this feature, you can only paste to visible cells, even though the range you are pasting to with hidden cells
  • Split Names:
  • It can split the full name into first name, middle name and last name.
  • Extract Mail Address:
  • It will only extract the email address from the selected range.
  • Convert between Roman and Number
  • Select Last Cells:
  • With this feature, you can quickly select the last cell of the used range, the last cell of the last row, and the last cell of last column.
  • Batch Insert Option Button
  • Batch Delete Option Button
  • Freeze Panes Multiple Worksheets:
  • With this feature, it will freeze panes across multiple worksheets and keep an area of a worksheet visible while you scroll to another area of the worksheet.
  • Improved:
  • 1. All dialog boxes will auto fit the font size of your system, making it easier to read and apply the features.
  • 2. Some feature dialog boxes are resizable by dragging it. You just need to move the mouse over the edge of the dialog.
  • A complete new Navigation Pane:
  • In the Navigation Pane, you can drag and drop to arrange the worksheet order right now.
  • If you have check the Show hidden sheet(s) in the Worksheets list option, you can quickly hide or unhide worksheets in Navigation Pane.
  • Filename List:
  • You can list more than 10 000 files with this tool right now.
  • Fixed:
  • When the Enable Live Preview is checked in the Excel Options, the Reading Layout feature will crash in previous versions.

New in Kutools for Excel 7.8.0.0 (Aug 13, 2014)

  • From now on, we will only sell or publish the lifetime license of the software. The lifetime license grants you to use the software forever and free upgrade to any versions of the software within 2 years.
  • If you have purchased the subscription licenses (2 years or 5 years), you don’t need to change your licenses to free upgrade to any versions of the software during your subscription period.

New in Kutools for Excel 7.5.5.0 (May 9, 2014)

  • New features:
  • Advanced Sort: With this utility, you can quickly sort data in a range or table by Text length, Month, Last name, Day, Absolute value, Odd and even number, Mail domain and Frequency. With the built-in Excel Sort command, you can only sort data by values, Cello Color, Font Color and Cell Icon.
  • Convert Formula to Text: With this utility, you can easily convert formulas to text format. Disadvantage: It will convert all cells of range into text format. We will enhance it in new version for only converting formula cells into text format.
  • Convert Text to Formula: With this utility, it will convert formulas which have been stored as text format into real formulas.
  • Select Cells with Non-locked: With this utility, you can quickly select all unlocked cells from a range. Tip: please specify a range before applying this utility.
  • Batch Insert Check Box: With it, you can easily insert check box in a cell or range. Tip: If you select a range, it will insert check box into all cells of the range.
  • Batch Insert Option Button: With it, you can easily insert option button in a cell or range. Tip: If you select a range, it will insert option button into all cells of the range.

New in Kutools for Excel 7.5.0.0 (May 5, 2014)

  • New features:
  • Advanced Sort: With this utility, you can quickly sort data in a range or table by Text length, Month, Last name, Day, Absolute value, Odd and even number, Mail domain and Frequency. With the built-in Excel Sort command, you can only sort data by values, Cello Color, Font Color and Cell Icon
  • Convert Formula to Text: With this utility, you can easily convert formulas to text format. Disadvantage: It will convert all cells of range into text format. We will enhance it in new version for only converting formula cells into text format.
  • Convert Text to Formula: With this utility, it will convert formulas which have been stored as text format into real formulas.
  • Select Cells with Non-locked: With this utility, you can quickly select all unlocked cells from a range. Tip: please specify a range before applying this utility.
  • Batch Insert Check Box: With it, you can easily insert check box in a cell or range. Tip: If you select a range, it will insert check box into all cells of the range.
  • Batch Insert Option Button: With it, you can easily insert option button in a cell or range. Tip: If you select a range, it will insert option button into all cells of the range.

New in Kutools for Excel 7.0.0.0 (Feb 18, 2014)

  • Enhanced the Reading Layout feature. In some rare circumstances, the Reading Layout feature will not display properly.
  • All features and commands of the latest version are allowed to process the merged cells right now. Such as the features of Text Tools.
  • Enhanced the Import Pictures by adding more flexible and useful options. Such as the Mach command, it will allow to you quickly arrange the pictures order according to the content of cells.
  • Fixed some minor bugs.

New in Kutools for Excel 6.5.0.0 (Oct 24, 2013)

  • Reading Layout View is available for Excel 2013 now
  • Advanced Combine Rows:
  • With this utility, you can quickly combine and calculate multiple rows based on the key column. Please take a look at the following instance.
  • Fill Custom List:
  • With this utility, you can quickly fill the custom list data in a range vertically or horizontally.
  • Fill Worksheets References:
  • With this utility, you can quickly fill or create reference to a cell of multiple worksheets in Excel. For example, to fill column A with all data from other workshets' A1*100 in following screenshots.
  • File Format Converter:
  • With this utility, you can easily convert multiple Excel files from XLSX format to XLS format or vice versa, you can also convert multiple Excel workbooks to PDF files.
  • Super Filter:
  • With this utility, you can easily filter date in current worksheet or a range with mutltiple conditions / criteria in Excel. You can quickly get to know how does it work as follows.
  • Compare Ranges:
  • In previous version, the Compare Ranges utility can find duplicate or unique values from two ranges or one range. But in this version, the Compare Ranges can only find duplicate or unique values from two ranges. If you want to find duplicate or unique values from one range, please use the Select Duplicate & Unique Cells.
  • Fixed:
  • All features and utilities will be grayed out under some rare circumstances in Excel 2013.

New in Kutools for Excel 6.0.0.0 (Oct 11, 2013)

  • Never been so easy to combine or merge worksheets:
  • In this version, the Combine utility is enhanced with 4 powerful functions. With the Combine utility, you can:
  • A: Combine multiple worksheets from workbooks into one worksheet.
  • B: Combine all same name worksheets into one worksheet.
  • C: Combine multiple worksheets from workbooks into one workbook.
  • D: Consolidate and calculate values across multiple workbooks into one worksheet.
  • Switch back and forth just between two worksheets:
  • For example, if you just want to switch back and forth between two worksheets, such as Sheet 2 and Sheet 10 as shown in the below screenshot.
  • Import Pictures and Filename List have been improved:
  • In the previous version, if you go to import pictures in one workbook by using the Import Pictures utility, the pictures will be gone after sending the workbook to someone else. The problem has been fixed.
  • Under some circumstances, the Filename List utility can’t list all files of a directory into one worksheet in Excel. We have fixed this problem too.
  • Support online help for each utility:
  • For example, if you want to get more information (help) about the Reading Layout Settings utility, please click “?” as shown in the below screenshot, and then it will open the online help page in your web browser for you. It requires an Internet Connection.

New in Kutools for Excel 5.1.0.0 (Oct 2, 2012)

  • There is not a single new feature in this version, but we recommend you to download and install the latest version. In this version, the point is to fix the problem and make the Kutools for Excel more stable when you are accessing the utility. By the way, you can customize the language for the Kutools for Excel yourself, or you can help us by translating the software from English into your own language and get a free license of the software.

New in Kutools for Excel 4.0.0.0 (Apr 19, 2012)

  • New features locating under Modify group:
  • Transpose Table Dimensions:
  • This utility will transpose two-dimension table (a range) with row headings and column headings into one-dimension table or vice versa.
  • Note: the one-dimension table must contain three columns, the first column will be converted as the row headings of the two-dimension table, the second column will be converted as the column headings of the two-dimension table, and the third column will be converted as the data of two-dimension table.
  • Flip Selected Cells:
  • This utility will flip the selected cells.
  • For example, if you have selected a column, containing the number 1, 2 and 3, this utility will reverse the order to 3, 2, and 1.
  • Fill Cells with Displayed Values:
  • This utility will fill the cells of selected range by converting formulas to their calculated values and converting the values or formulas in selected cells to the way they are formatted.
  • For example, cell A1 with the value 03/21/2012 formatted as Wednesday. This utility will put Wednesday in cell A1.
  • For example, this utility will convert [=A2*(C19/12)] to the calculated value and use it to fill the cell.
  • Inert blank Rows/Columns:
  • This utility allows you to quickly insert specific number of blank rows or columns at a specified interval.
  • Replace Accented Characters:
  • This utility can quickly help you replace all accented characters at once. Normally you have to repeatedly use the find and replace function to replace multiple accented characters in Excel.
  • Fill Blank Cells:
  • This utility can quickly fill the blank cells as follows:
  • Fill the blank cells with above cell data, below cell data, left cell data or right cell data.
  • Fill the blank cells with linear values.
  • Fill the blank cells with fixed value.
  • New features locating under Select Tools group:
  • Select Range Helper:
  • This utility includes the following three functions:
  • Union Selection: without holding down the CTRL key to quickly select multiple ranges.
  • Deselect Cells: to deselect cells from selected ranges.
  • Inverse Selection: to select the inverse selection of selected ranges.
  • Select Interval Rows/Columns:
  • This utility allows you to quickly select a specific number of rows or columns at a specified interval.
  • Compare Ranges for Duplicate Values:
  • This utility can help you compare two ranges and select the duplicate values or unique values between two ranges. Normally you can use the conditional formatting to select duplicate values, but it’s too complicated.
  • Note: the two comparing ranges must contain the same number of columns.
  • New features locating under Utilities group:
  • Copy Multiple Ranges:
  • Normally you cannot copy multiple selected ranges in Excel, but with this utility you can copy multiple selected ranges at once.
  • Adjust Cell Size:
  • This utility helps you to specify the row height and column width in pounds, centimeters, inches or pixels. It can apply to a range or the whole worksheet.
  • Create Folders based on Cell contents:
  • This utility easily creates a lot of folders in a certain specified folder, based on the contents in selected cells.
  • New features locating under Worksheet Tools group:
  • Delete All Hidden Sheets:
  • This utility can delete all hidden sheets from the workbook with one click.
  • Improved features:
  • Interactive Hide / Unhide:
  • Add Very Hidden option: you can set the sheet status as: Visible, Hidden and Very Hidden.
  • Create Sequence Worksheets:
  • Add Filled with Worksheet tabs color option: it will shade the sheet tabs with the colors in the cells of the selected range.
  • Sort Sheets:
  • Add Color Sort option: it can sort all sheet tabs according to their sheet tab color.
  • Cell Comment Tools:
  • Add Convert Tab: it can convert contents of cells into comments or convert comments into contents of cells.
  • Replace Range Names:
  • This utility will replace the name reference with the corresponding cell reference. In the new version, we redesign the utility interface. It can list all the name references in a list.
  • List all name references of the specified range:
  • List all name references of specified worksheet:
  • List specified name reference:
  • Setting Center:
  • You can access the Setting Center of Kutools for Excel by clicking Start > All Programs > Kutools for Excel > Setting Center.

New in Kutools for Excel 3.0.0.0 (Nov 17, 2011)

  • Features have been updated in new version:
  • Rebuilds a new Ribbon interface of Kutools, the features have been classified according to their functions, so it’s much easier for you to find the features.
  • Adds Super Tooltips with each feature, it’s convenient for accessing information about using the feature.
  • Improved the Sort Worksheets feature:
  • Old version: only supports with one click to alphanumerically sort sheets.
  • New version: you can quickly rearrange all sheets by using the drag and drop feature in Sort Sheets dialog box. It’s more powerful for you to quickly rearrange the order of all sheets. It also support with one click to alphanumerically sort sheets.
  • The view settings group has been included in Toggle Setting. It’s much easier for you to set any of the settings about workbook, worksheet, objects and comments.
  • Max Cell and Min Cell have been embodied in Select Cells with Max or Min Value. You can specify the range for selecting the max or min value.
  • Improved Open Containing Folder:
  • Old version: only open the folder where the active workbook stays in.
  • New Version: it can not only open the folder where the active workbook stays in, but also marks the workbook as selected.
  • 28 new features have been added in new version:
  • Superscript / Subscript (Formatting):
  • Easily format text as superscript or subscript in a cell.
  • Alternate Row Shading:
  • Quickly apply shading to alternate rows for a range cells in a worksheet to improve the readability of your worksheet in Excel, and you don’t need to know how to use the Conditional Formatting and standard formatting.
  • Unit Conversion:
  • Quickly convert more than 11 measurements from one unit to another in your Excel.
  • Currency Conversion:
  • A quick way to convert more than 50 currencies in your Excel by using the latest exchange rates from the reliable Internet website.
  • Select Specific Cells:
  • Selects cells or entire row from a specified range that meet certain criteria.
  • Select Cells with Format:
  • Selects cells with the same formatting from a range cells according to the formatting of the base cell or the base cell attributes.
  • Exact (Formula) Copy:
  • With this tool you can easily copy all the formulas without adjusting the relative cell references.
  • Convert References:
  • This tool will convert the notation of references to cells in the formulas in your selected range.
  • Replace Range Names:
  • This tool augments Excel with a feature for replacing a name reference in the selected formulas with the corresponding reference.
  • Error Condition Wizard:
  • This tool is sophisticated designed for adding error condition to a formula or group of formulas.
  • Cell Comment Tools:
  • A powerful comments manager: easily comments appearance settings, modifies the comments and so on.
  • Kutools Calculator:
  • With this calculator you can carry out more than 10 types of mathematical operation.
  • Synchronize Worksheets:
  • Quickly toggle all the worksheets of the active workbook pointing on the same row number (each worksheet has the same range selection and upper left cell as the active sheet).
  • Interactive Hide / Unhide:
  • Interactively hide or unhide multiple workbooks and worksheets at one time.
  • Inset Sequence Number:
  • Quickly insert a unique (and consecutive) value into a cell in Excel.
  • Set Scroll Area:
  • It’s a fantastic way to set or limit the scrolling area in your workbook.
  • Print Multiple Workbooks Wizard:
  • Quickly print multiple workbooks and text files from a specified directory or across multiple directories.
  • Copy Page Setup:
  • Quickly copy the page setup setting from active worksheet to the other worksheets in the same workbook.
  • Export Range to File:
  • Easily export a range of date to a file, either an Excel workbook, a CSV, a simple HTML or all formatting HTML.
  • Export Range as Graphic:
  • Quickly convert a range of the active worksheet to an image in Gif, JPEG, TIF or PNG format.
  • Insert File at Cursor:
  • Quickly insert complete content of worksheet, text file into current cursor position of active worksheet.
  • Filename list:
  • With this tool you can easily create a new workbook containing a list of the filenames from a specified directory, you can choose to include the subdirectory and create hyperlinks to the filenames.
  • Date Picker:
  • With this tool you can randomly insert a formatted date into a cell, or make a fast change the formatting of an existing date.
  • Perpetual Calendar:
  • Quickly insert a calendar picture of specified month in your current worksheet, or create a new workbook to lay out a specified month calendar (or 12 months).
  • Create List of Sheet Names:
  • With this tool you can quickly create a list of all worksheet names of the active workbook in a new workbook, which contains hyperlinks or macro buttons for quickly navigate to other worksheets.
  • Create Sequence Worksheets:
  • Quickly create a new workbook with customized worksheet names. You can easily specify the worksheet name by using: month names, day names, numerical sequence, a series, custom list and date in a range.
  • Remove All Macros:
  • Quickly remove any of the following macros from your workbook: VBA modules, UserForms, Excel 5/95 dialog worksheets, or Excel 4 XLM macro worksheets.
  • Some minor errors have been fixed in new version:
  • Fixed: the delete features cannot delete specified objects.
  • Fixed: to undo the Swap Ranges operation will cause errors.

New in Kutools for Excel 2.0.6.2 (May 21, 2011)

  • Add Excel Explorer function; release .msi package

New in Kutools for Excel 1.1.0.0 (Jan 25, 2011)

  • Fix a bug in max workspace.