軟體下載 Kutools for Excel 26.10

• 1

  版本確認

• 2

  檔案準備中

• 3

  檔案下載

What's new in this version:

Kutools for Excel 26.10
- Change log not available for this version


Kutools for Excel 26.00
- Change log not available for this version


Kutools for Excel 25.00
- Change log not available for this version


Kutools for Excel 24.00
- Change log not available for this version


Kutools for Excel 23.00
- Change log not available for this version


Kutools for Excel 22.00
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


Kutools for Excel 21.00
- Change log not available for this version


Kutools for Excel 20.00
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.