The Excel worry-free plug-in includes functions such as batch merging/splitting of Excel reports, batch query/summarization of multiple files, batch extraction of specified data across files, batch import/export of pictures, etc., to help you worry-free tabulation.
Excel worry-free plug-in software instructions
The plug-in supports Excel 2007, 2010, 2013, 2016, 2019 and 2021. It also supports WP and can be used in simplified, traditional and English systems.
All functions come with animated teaching materials (click the first button to call). Please watch the animation demonstration before operating to reduce the time of fumbling.
Excel worry-free plug-in function introduction
01. Workbook summary: Summarize the values of specified worksheets in multiple workbooks. You can specify multiple workbooks at one time, and specify multiple required areas in the workbooks. These areas are allowed to be discontinuous. The summary method includes averaging and summing, and for text areas, it automatically switches to counting (counting the number of non-empty cells)
02. Worksheet summary: Summarize the specified worksheet in the current workbook. You can specify the summary area arbitrarily, allowing you to specify multiple discontinuous areas. Summarization includes summing and averaging. If the cell contains text, it will automatically switch to counting (accumulating the number of non-empty cells).
03. Check the report: Check the numerical similarities and differences between the two worksheets, list the different cell addresses, and mark them with colors.
04. Cross-sheet search: Search for specified words in multiple worksheets, and then list them in a new worksheet. You can also search for specified words in multiple workbooks and then list them in a new worksheet. Supports exact matching and fuzzy matching.
05. Payment bar: Instantly, the salary details are generated to generate salary sticks for easy printing and cutting. You can define the number of rows in the salary header yourself.
06. Extract cells across workbooks: Batch values from specified cell addresses in specified worksheets in multiple workbooks and list them in a new sheet. For example, the H2 cell of the first worksheet of each workbook stores the "return rate", then this tool can list the return rates in all files to facilitate comparison.
The above figure demonstrates an absolute address reference.
07. Extract cells across worksheets: Batch values from specified cell addresses in multiple worksheets and list them in a new sheet. For example, the H2 cell of the first worksheet of each workbook stores the "return rate", then this tool can list the return rates of all worksheets to facilitate comparison. Supports both relative address and absolute address reference methods.
08. Reorganize workbooks: Reorganize a batch of workbooks by name. The reorganization rule is to extract the worksheets one by one from all workbooks, and then store the worksheets with the same name in a new workbook. Each worksheet in the new workbook The name is equal to the original workbook name, and the new workbook name is equal to the original worksheet name
.
09. Merge workbooks and worksheets: Function one is to merge the worksheet data of all workbooks in the specified folder. There are two ways to merge
, 1 is to merge all data into one worksheet, 2 is to merge all data into different worksheets, the worksheet name is equal to the worksheet name in the original workbook; function 2 is to merge all worksheets in the active workbook , listed in the last worksheet.
10. Split worksheet: Split the data of the current worksheet into multiple worksheets according to conditions. You can use data in any column as the splitting condition.
11. Split Worksheet 2: Split the data of the current worksheet into multiple worksheets based on conditions. You can use data in any column as the split condition. Keep all information at the footer of the page after splitting.
13. Workbook splitting: Split each worksheet of the specified workbook into a separate workbook. The name of the new workbook is equal to the name of the original worksheet.
14. Batch retrieval of sheets: Extract worksheets with specified names one by one from all workbooks in the specified folder and merge them into a new workbook. You can extract all worksheets in all workbooks, you can also extract a single worksheet in a certain workbook, and you can also extract worksheets with the same name in all workbooks (manually specify the table name).
15. Batch creation of tables: Create new tables in batches or print them in batches based on the user's own detailed tables and templates specified by the user. It is suitable for various types of notices or delivery orders. It can also be called a copy printing tool or a mail merge tool, but it is more powerful and flexible than WORD's mail merge.
16. Clear interference symbols: Clear interference symbols in the selection, including leading and trailing spaces and other invisible characters. Functions like Vlookup will fail if there are interfering characters in the cell.
17. Import pictures: Batch import pictures in jpg, gif, png, bmp and other formats into the worksheet. Allows you to import pictures in subfolders, allows you to choose whether to store pictures in landscape or portrait orientation, allows you to specify whether the ratio of pictures is locked, allows you to set whether pictures adjust with cell size adjustments, allows you to specify picture names and spacing distances between pictures...
18. Import pictures and type them: Import pictures in batches and type them automatically. You can type types in multiple rows and columns. You can specify the image size and path arbitrarily, and you can automatically remember the path you selected last time.
19. Import network pictures: Import network pictures in batches, and you can specify the picture size arbitrarily. You can choose to store it in a cell or in a comment.
20. Export pictures: Export all pictures of the current table to the hard disk and save them as jpg or PNG pictures.
Excel worry-free plug-in update log
Version 2.1 has modified the installation method to avoid installation failures and improve software compatibility.
Huajun editor recommends:
Excel worry-free plug-in is free software, download it if you need it! This site also has Cloud Machine Manager, Cloud Machine Manager, and Batch Butler for you to download!
