Skip to main content

Kutools for Excel 5.00: more Excel tools and features!

Author: Zhoumandy Last Modified: 2022-06-15

Handy Excel add-ins and tools – Kutools for Excel 5.00 – is here! No matter you are the users or not, you are entitled to free download to try it out or upgrade to the latest version from here.
For more questions and suggestions, please don’t hesitate to contact us at

arrow blue right bubbleAll tools and features have been redesigned in two tabs:

blue-dotKutools Tab:

1. View group: Tools and features about visibility operation in Excel have been grouped in View group.

2. Range and Cells group: Tools and features can be applied to a range and multiple cells in Excel that is located at Range and Cells group.

3. Editing group: Tools and features about selecting content, deleting content, inserting content, removing text and special characters or formatting content are located at Editing group.

4. Formula group: Tools and features about applying operations in formulas are located at Formula group.

blue-dotEnterprise Tab:

1. Workbook and Sheets group: Tools and features about applying operations in workbooks or worksheets are located at Workbook and Sheets group.

2. Security group: Tools and features about operations for encoding or decoding cells and protecting or unprotecting worksheets are located at Security group.

3. Filter & Statistic group: Tools and features about filtering and statistic operations are located at Filter & Statistic group.

arrow blue right bubbleBugs have been fixed in this version:

blue-dotNavigation Pane: In previous version, the Navigation Pane will crash the Excel under some rare circumstances. In the new version, it won’t crash any more.

blue-dotMerge Workbook: In previous version, after merging multiple workbooks into one Excel file with Merge Workbook feature, you cannot save the merged files in Excel in some cases. But this problem has been completely fixed in the new version.

arrow blue right bubbleNew tools and feature in this version:

1. Input Helper:

Highlighting the row and column of the activated cell that will make it easily type content in the cell or view the data. See screenshot:

2. Show Columns:

It’s easy to show all hidden columns with one click.

3. Show Worksheets:

It’s easy to show all hidden worksheets with one click.

4. Date Format Converter:

Quickly convert common short date string, long date string and various date formatting into your local date and time formatting.

5. Cell Encode:

Quickly apply password to encode the selected cells.

6. Cell Decode:

Quickly apply password to decode the encoded cells in a range.

7. Supper Filter:

Easily customize multiple conditions for filtering data in Excel.

8. Delete Rows & Columns:

Quickly delete blank, hidden or unhidden rows / Columns from a range, an entire worksheet, the selected worksheets or the whole workbook.

9. Reverse Text Order:

Reverse text string order in cells.

10. Insert Workbook Information:

Inserting worksheet or workbook name, workbook path or workbook path & name in header, footer or cells.

11. Spell Out Numbers:

Spell out numbers into English or Chinese words in Excel. For example, it can spell our 12.75 into “Twelve dollars and seventy five cents” in Excel.

12. Split Data:

Split a range data into multiple worksheets in current workbook according to specific basis.

13. Copy Cell Formatting:

With this tool, you can quickly copy specific cell formatting and apply it to a range cell in Excel.

14. Export Graphics:

You can export charts, pictures and shapes from Excel with this tool.

15. Find & Break Broken Links:

It can list all links (external reference) of active worksheet and break all broken links by replacing it with appreciate value in Excel.

16. Convert Hyperlinks:

With this tool, you can quickly convert text (URL) into hyperlinks, apply multiple hyperlink addresses to cell content (text) and convert multiple hyperlink address into text in Excel.

17. Select Merged Cells:

It can quickly select the merged cells from a range in Excel.

18. Merge Same Cells:

Merge adjacent cells that contain the same value in a column with one click. Please select the column that you want to merge same cells first.

19. Unmerge Cells:

This tool can quickly unmerge the merged cells in a range with one click, and fill each unmerged cell with content of merged cell.

20. Insert Titles Rows:

Quickly insert title row in a column.

21. Prevent Duplicate Entries:

This tool can prevent entering duplicate data in a single column with one click.

22. Round without Formula:

With this tool, you can easily round, round up, round down numbers in a range, and make the actual value of cells as displayed value.

23. Protect Worksheets:

Quickly protect multiple worksheets with same password.

24. Unprotect Worksheets:

If there are multiple worksheets have been protected by using the same password, it can unprotect all protected worksheets with the password.

25. Count by Color:

This tool will calculate the cells based on cell background color in a range and generate a report with information, such as how many cells that have the same background color, the average value, the max value and the min value of same background color.

26. Count by Page:

Insert a row into each printed page for analyzing and calculate each column, such as sum value, count value, average value, max value, min value, product and count numbers of each column.

27. Import Picture:

Import multiple pictures from same directory in worksheet, and rearrange the imported pictures in order.

28. Print Current Page:

This tool arrows you to quickly print the printed page which the active cell locates at with one click.

29. Print Multiple Columns:

With this tool, you can quickly print columns in multiple segments to fit on one printed page in Excel. Let’s say you have a column with 200 names and you want to print 4 columns with each column containing 50 names on one printed page.

30. Change Comment Shape:

Quickly change the shape of all comments in Excel.

arrow blue right bubbleTools and features have been improved in this version:

1. Delete Characters:

Add custom option. You can type in the characters or special characters that you want to delete in the range.

2. Copy Multiple Ranges:

It’s available to copy the row height and column width.

Best Office Productivity Tools

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...


Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Comments (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Leave your comments
Posting as Guest
Rate this post:
0   Characters
Suggested Locations