EXCEL essential toolbox

Introduction to EXCEL Essential Toolbox Software

​​ ​​The EXCEL Essential Toolbox is a plug-in that supports both EXCEL/WPS. It comes with free multi-tab functions. It can be used after installation. It is completely integrated with excel/wps. Most operations can be undone after execution. Supports 32-bit/64-bit OFFICE, and of course perfectly supports WPS!

The EXCEL essential toolbox intelligently identifies whether it is 32/64-bit EXCEL or WPS, automatically blocks existing WPS functions, and adds additional WPS-specific functions!

It provides many practical functions such as password removal, lunisolar calendar conversion, storing selected areas as pictures, sorting worksheets and generating directories, manual double-sided printing, professional-level table data summary, and penetrating query. Right-clicking on the worksheet label also adds the functions of easily hiding/unhiding the worksheet and exporting the worksheet to a file. For financial personnel, it also provides calculation functions for personal income tax, unrecognized financing expenses, mortgage loan/general loan interest, various compound interest, and actual interest rate amortization. In addition, it also provides templates for automatically generating analysis documents, financial ratio calculations, etc. to simplify your daily work.

EXCEL essential toolbox operating environment

Tested operating environment: Win95/98/Me/2000/NT/XP/Vista/Win7/Win8/Win10 (32-bit/64-bit)

Runnable EXCEL versions: EXCEL2007/2010/2013/2016/2019 (32-bit/64-bit)

Runnable WPS versions: WPS2016-WPS2019 or higher

EXCEL essential toolbox update log

Updated content of Excel essential toolbox version 18.60:

New features:

​​ 1. Processing Tools → More → Added the [BOM parent-child, tree structure conversion] function to realize mutual conversion between BOM parent-child structure and tree structure!

​​ 2. New functions: Summary Tool → More, new [Data Rearrange] function, which can rearrange a set of two-dimensional data according to the newly specified rows and columns.

​ ​ Other improvements:

​ ​ 1. The processing tools → other → bottom title function has been improved. When the horizontal page break is abnormal, it will prompt that the index exceeds the upper limit. This has been improved and will no longer prompt.

​​ 2. The function of batch tool → batch → batch export of embedded documents has been improved. Those embedded PDF documents formed by direct copy and paste can also be exported normally.

3. Processing Tools → Formula Assistant → Added [Calculate Retirement Date] function, which can use a formula to generate a retirement date based on the specified date of birth and gender.

4. Batch Tools → Batch Operations → Formulas, a new function [Delete the outermost Round function of the formula] is added. Many formulas are rounded by adding Round functions in batches, such as =round(12.3456,2), this function is Remove these outermost roud functions and restore the original result. For example, in this example it becomes: 12.3456.

​​ 5. Batch Tools→Others→Batch downward filling of non-empty cells has been improved. Characters will still be retained after filling character-type values.

​​ 6. Other Tools→Others→ID card number verification function has been improved, and the option of [Insert Column on the Right] to display batch verification results has been added.

​ 7. Improvement of the function of preventing misreading of rows: When setting formulas across tables, when switching to other worksheets and scrolling the wheel, the function of preventing misreading of rows is unavailable and has been improved;

​​ 8. Summary Tool → More → Merge the two tables according to common columns, make a pre-judgement for keyword duplication, and prompt:

There are duplicate values ​​in the keywords of both tables, which will cause data disorder, and the number of generated rows will increase exponentially. Under normal circumstances, only the keywords of one table are allowed to have duplicate values. Exit?

​ 9. Batch Tools→Multiple Sheet Rename→Use Cell Value→Cell Range (can only be in 1 row or 1 column). If the cell range selected for naming is not in the current worksheet, the name cannot be renamed. This has been improved.

​​ 10. Processing Tools→Pictures→Import Pictures→Adjust the cell height according to the picture height. If the picture is too large, it will cause part of the picture to overflow the cell. This has been improved.

11. Batch Tools → Batch → Batch Print Excel and Convert to PDF. If [All Worksheets] is checked, after the conversion is completed, it will prompt "No convertible PDF documents found", which has been modified to the correct prompt; forced printing of hidden tables Change the option to unchecked by default

12. Other tools → Template → Template calculation, when performing [automatic generation of analysis documents] or [batch generation of word operations], if an error message appears: Unable to convert COM of type "Microsoft.Office.Interop.Word.DocumentClass" The object is forced to be converted to the interface type "Microsoft.Office.Interop.Word._Document". An automatic reminder has been added. Do you want to open it to view the detailed solution?

​​ 13. When using template application and other functions that require calling the clipboard, if it prompts: Error number 4605, this command is invalid, a solution will be given:

Please enter [Settings], [System], [Clipboard] of Windows, adjust [Clipboard History] to [Off], and restart the computer.

14. Summary Tool → More → Merge Multiple Column Content function has been improved. If multiple areas are selected, the original prompt is: "Multiple areas are currently selected. This function only operates on the first area of ​​the selected multiple areas." , this prompt is not accurate enough and has been modified to:

Only continuous areas are supported, please reselect the data area to be merged.

15. Batch Tools → Improved multi-table encryption function. When performing batch protection of worksheets, if the password is wrong, a prompt will appear: The original table is already protected and cannot be protected again; if the password is the same as before, it will continue to remain protected.

Under WPS, because the worksheet protection command does not report an error even if the protection fails, if the worksheet has been password protected, without canceling the protection, directly protect it again with another password, it will also prompt that the encryption is completed, which has been specially done. Special treatment.

16. Summary Tool → More → The function of extracting common rows from two tables has been improved. The generated results will list the common rows of Table 1 and the common rows of Table 2 at the same time, which is consistent with the style of the [Remove Common Rows from Two Tables] function.

​​ 17. Summary tool→Summary→Copy formula function without changing the reference:

(1) If there are hidden rows, it will prompt: There are hidden rows in the selected area and will be ignored. It is recommended to cancel filtering or hiding before using this function.

(2) Before selecting the target cell, the currently selected area will be prompted to facilitate user verification and avoid causing user confusion by directly prompting the user to select the target cell.

18. Table Tool → Table, 4 functional improvements including [Multiple Area Copy], [Copy Visible Area Only], [Paste Only to Visible Area], and [Copy with Format]:

Before selecting the target cell, the currently selected area will be prompted to facilitate user verification and avoid causing user confusion by directly prompting the user to select the target cell.

19. The Summary Tool → Summary → [Formula Apply] function has been improved. The original prompt on the interface was "This operation cannot be undone. If the result is not satisfactory, you can give up saving." has been modified to: "Warm reminder: This operation cannot be undone. Please Make a backup before proceeding."

20. Processing tools→Pictures→Import pictures:

The new version of WPS has a bug in the decimal processing of the top attribute of images, which causes offset when importing images in batches under WPS. Solution:

The ultimate solution: I have contacted the wps developer and strive to eliminate the bug as soon as possible so that it can be solved once and for all!

Alternative solution: Use the toolbox to import pictures in batches under Excel, and the effect is always perfect;

Temporary solution:

​ ​ Under WPS, first set the height of all rows in the worksheet where you want to import images to a unified multiple of 3, such as: 18, It cannot be the default 13.5, and then select [Adjust image height according to cell height] on the image import window, and you can also import images normally.

​​ Supplementary explanation: For merged cells composed of n rows, as long as the row height/n above is still an integer, you can use this number to set the row height.

We have added a solution link with pictures and texts on the official website: https://www.ahzll.top/HELP/example/ About the solution to the offset of batch imported images under WPS using the toolbox.docx

​​ 21. Summary Tools → More → Super Replacement → Comparison Table, if the window opens with the [Comparison Table] label by default, there will be no [Specified Folder] in the replacement range on the window. This has been improved.

​ ​ 22. Navigation → Search function has been improved. Previously, it could only search for values, but now it can also search for the value of formulas.

​ ​ 23. Multi-tab → In Excel 2007/2010, read-only documents cannot switch labels, which has been improved.

​​ 24. Finance and Taxation Tools → Finance and Taxation → Unified Social Credit Code Verification Function Temporarily Offline Reminder: Since the free online query interface has been closed, this function can only be temporarily closed until a replacement free interface is found.

​​ 25. Summary Tool → Summary → Automatically fill in the subtotal formula, add [add subtotal for the same items], add the subtotal formula under the same consecutive items in the condition column, and add the total at the end.

FAQ

Function not working properly

Problem description: A certain function in the toolbox cannot be used normally or an error is reported.

Solution:

Check if the Excel version is compatible with the toolbox.

Make sure the toolbox is properly installed and activated.

Try restarting Excel or your computer to clear possible caches or conflicts.

Check the toolbox's help documentation or online support to learn how to use the features and their limitations.

Performance issues

Problem description: Excel runs slowly or freezes when using the toolbox.

Solution:

Close unnecessary Excel plug-ins or tools to reduce system load.

Clean Excel's cache and temporary files.

Upgrade your computer hardware, such as adding memory or changing to a faster processor.