- Green versionCheck
- Green versionCheck
- Green versionCheck
- Green versionCheck
- Green versionCheck
Software function
According to the characteristics of each function, the submenus are divided into 18 categories.
Based on the Excel functions, 200 new practical functions have been expanded to increase the extended functions of Excel.
Universally applicable to Excel 2003, 2007 and 2010, 2013, 2016, 2019, 2021.
Supports Chinese and English display and traditional and simplified operating systems,
It has more than 30 gorgeous skin interfaces and supports Excel2010 to fully hide tabs. This plug-in also inherits the Excel2003 classic style menu, which is designed to facilitate the proficiency of those friends who have switched from Excel2003 to the 2007 or 2013 version.
Merges the ExcelTabs workbook multi-tab plug-in to facilitate switching and use in different workbooks. The step-by-step prompting function across workbook cells makes it easier for you to enter data.
There are 18 configurable parameters for image batch size and embedded format maps, and the import of multi-column images, and up to 80 combinations of import methods to meet the different needs of various industries for image import, export and standardized layout.
Expression Calculation Wizard makes automatic calculation of mathematical functions and complex formula expressions so lightweight and efficient, and can intelligently interact with EXCEL.
The project decryption function can decrypt the unviewable EXCEL project documents of VBA projects. Reopening the document after decryption can restore the source code with 100% accuracy. Combined with the Office programming treasure box, it has become an essential tool for VBA developers.
Software Highlights
Built-in VlookupIn() function, which is more powerful and easier to use than Vlookup() function.
It can undo and restore VBA macro programs to prevent accidental mouse clicks and misoperations.
Based on the save DBF function of EXCEL, you can also easily encrypt or decrypt all SQL database (*.DBF) files to prevent important content from being read and written at will.
The all-in-one voice reader has the function of an English learning repeater and can read aloud repeatedly and with delay.
The memory cell reader immediately reads the contents of the specified or offset row and column of cells in response to pressing Enter.
The original batch picture sorting function, known as the "Picture Sorting Master", has 21 styles to choose from. It can quickly sort pictures in a specified storage range in the worksheet and output them to a new table in batches.
It supports multiple operating systems from XP to WIN10 and is perfectly compatible to achieve seamless docking. In addition to using the original replaceable machine, U disk version users can achieve unimpeded access to XP/WIN7/WIN8/WIN10.
Batch printing of QR codes and barcodes, batch QR code recognition (can have logo), batch QR code generation (can have logo), batch production of shipping order labels, sales order labels, inventory labels and printing of QR codes and barcodes Etc., hundreds of QR codes or barcodes can be produced at one time based on the template.
Table data summary, fully automatic search and entry, data collection master, batch image resize, batch image import, batch image export, batch map annotation, image query, long image and paging screenshots, batch image sorting master, batch image format Conversion, batch text watermarks and logo watermarks, batch extraction of sensitive image information, identity ID verification, bank card verification upgrade, extracting the same items and different items, extracting unique values, selecting unique values in the area, intelligent filling, row and column coloring, background coloring, ID verification, real-time conversion of weights and measures, text extraction, text removal, extraction Numbers, get dotted numbers, remove numbers, get letters, remove letters, get Chinese characters, remove Chinese characters and other quick number retrieval functions.
Functions such as changing file time in batches are all available, and each function is refined.
Both the stand-alone version and the mobile version have realized the registration code of one code for three uses, which can be used for both "EXCEL Universal Treasure Box" 32-bit and 64-bit and "WPS Universal Treasure Box".
It has been tempered for ten years by the world's top Microsoft MVP experts and the accounting management information team. It is the result of the joint efforts of software author Liang Ruichun and EXCEL users and enthusiasts. It is known as the "all-round office Swiss Army Knife". Genuinely registering a set of authorization can use 32-bit Office, 64-bit Office, and domestic WPS Enterprise Professional Enhanced Edition at the same time, which is extremely convenient for users who need to switch software.
Help users improve efficiency and work smartly, solve user pain points and quickly improve office efficiency.
EXCEL universal treasure box features
【Public Lunar Calendar Query】: Generate a multi-functional calendar that can query the correspondence between all holidays and the public lunar calendar dates
【Gregorian to Lunar Calendar】: Convert Gregorian calendar dates to lunar calendar in batches, you can choose whether to display the heavenly stems and earthly branches
【Advanced Positioning】: Multifunctional selection (search) tool. You can select a value greater than a certain value, less than a certain value, or within a certain range. Wildcards are supported during text positioning. You can also search and locate by format
【Background coloring】: Use the specified color to highlight the current row and column, which is helpful for viewing data and avoiding looking at the wrong row. You can define the color as you like, adjust the depth of the color freely, and choose the coloring method.
【Environment Settings】: Set the worksheet interface view and control the display and hiding status of each item.
【Hide all disks】: Hide the specified drive letter to protect private files
【Summary by color】: Classify and total the data of the selected area according to the background color
【Unlock password protection】: Instantly delete worksheet passwords, suitable for Excel 2002, 2003, 2007, 2010
【Macro virus killing】: Can kill three kinds of macro viruses, one-click killing
【Capture window object】: Convert the selected window or object into a picture file, and can capture the Excel interface and all other interfaces
【Cut rectangular object】: Convert the selected rectangular area into a picture file
【Capture all areas】: Convert all selected areas into image files
【Delete empty cells】: Delete the empty cells in the selection, and the subsequent data will be automatically improved
【Transpose selection】: Replace the rows and rows of the selection
【Invert by column】: Invert the data of the selection horizontally
【Invert by column】: Invert the data of the selection vertically
【Letter case conversion】: Convert selected words between uppercase, lowercase and first letter capitalization
Excel Treasure Box Frequently Asked Questions
Analysis of reasons for unsuccessful installation of EXCEL universal treasure box:
For those who cannot install, please note the following 6 points:
1: It must be the full version of OFFICE, not the green version or the streamlined version. They do not support COM add-ins.
2: You must close Excel to install or delete tools, and then restart Excel after installation.
Three: If it is VISTA or WIN 7, it must be installed as an administrator user and the User Account Control (UAC) function must be turned off from the control panel.
Four: If you have installed other EXCEL tools, please close it first, they may delete the menu of this tool.
Five: Do not use skin packages other than the system for desktop theme display. If installed, please uninstall it first to avoid affecting the normal display of the tool.
Six: If the XP system + administrator rights + 32-bit Office individual versions cannot automatically load the toolbox menu: Office button--"Excel options--"Excel add-in--"Com add-in--"Go button-- 》Add the ExcelTools.Dll file in the installation directory and confirm.
EXCEL Universal Treasure Box 32-bit update log:
1: Optimized performance
2: We are serious about solving bug problems
Huajun editor recommends:
Say goodbye to junk software, EXCEL Universal Treasure Box 32-bit is a green and safe software, the editor has personally tested it! Our Huajun Software Park serves you wholeheartedly. There are alsoToday's goal,Hanwang Attendance Management System,WPS Office,NTKO large file upload control,Kuai Dao Ke platform software, available for you to download!
it works
it works
it works