軟體下載 Kutools for Excel 21.00

• 1

  版本確認

• 2

  檔案準備中

• 3

  檔案下載

What's new in this version:

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.