office smart office

Smart Office is an auxiliary tool to enhance Office efficiency. This software can improve your work efficiency 10 times or 100 times.

Features:

This software is easy to operate, just like a point-and-shoot camera. With just one click, complex data processing can be automatically completed by the computer, allowing you to get twice the result with half the effort. We sincerely hope that more people can reduce work stress and improve work efficiency through this software.

​

Function details:

1. 1 second to create the link directory

2. In 1 second, add all files to the print queue [print in order, not out of order, easy to print]
                           
3. Copy the display area [copy visible cells, hidden cells are not copied]

4. In 1 second, disconnect the formulas in the specified area or all worksheets [can also be converted to numerical format or seen values]

5. Display/delete N or all hidden worksheets in 1 second [no need to click one by one]

6. 1 second to delete all links or comments or pictures
                   
7. In 1 second, fill the cell content down to the blank cells [Intelligent recognition, no need to paste them one by one]
                   
8. 1 second, insert blank rows at any position [insert rows at equal intervals and insert rows according to classification]
                   
9. 1 second, delete blank lines
(1) If the entire line has no content, delete the line

(2) If the content of a cell in the specified column is empty, delete the row where the cell is located.
                       
10. 1 second to realize mutual conversion between xls (2003 and below versions) and xlsx (2007 and above versions)
                       
11. 1 second, add [Subtotal] [Total] according to category
                   
12. In 1 second, the worksheet is split into N worksheets according to the category, and each worksheet contains one category of content.
                   
13. In 1 second, merge the contents of multiple worksheets into one worksheet
                   
14. Merge multiple workbook files into one workbook in 1 second
                   
15. In 1 second, merge the contents of worksheets with the same name into the corresponding worksheets.

16. Super merge cells to merge the same content
                   
17. Super split cells, split merged cells and fill in content

18. Keep the cell contents and merge them [horizontally, vertically, and three-dimensionally]

19. Export a single or all worksheets into a separate file in 1 second

20. 1 second, sort the worksheet by name

21. Rename worksheets in batches in 1 second [there are four forms: add suffixes, name based on cell content, add serial number to name, and find and replace characters]
                                     
22. Insert pictures in batches and layout them in 1 second [there are 4 modes: custom scaling, original size, A4 printing size, and cell filling]

23. Export specified pictures or all pictures in 1 second. You can also export cell ranges as pictures.

24. 1 second to extract the required sample
(1) Draw samples according to group distance
(2) Draw samples according to sample size
25. Electronic pointer/screen brush [Draw as you like and erase as you like, adjustable thickness, transparency, undoable, etc.]
                                     
26. Bind shortcut keys [to realize multi-key or multi-step operations with one click, and can also run automatically in cycles]
                   
27. Advanced search and replace [1. You can find the files where the content you need is stored, without having to open files one by one to find it; 2. Search and replace content in N files; 3. Regular search and replace]
                       
28. Batch rename files in any format in 1 second [there are four forms: add suffix, name based on cell content, add serial number to name, and find and replace characters]

29. Move the worksheet [Solve the problem that the worksheet cannot be moved from xlsx format to xls format]
                       
30. Custom formats and custom functions
                                         

​