:WPS form smart toolbox smart toolbox batch filling-Table skills免费ppt模版下载-道格办公

Image and text skills

WPS Form's "Smart Toolbox" contains 60 efficient small functions to help you work efficiently and work easily without working overtime.

First click the"Member Exclusive" tab-"Smart Toolbox" button to open the "Smart Toolbox" button ToolboxFeatures tab.

微信图片_20210809150042.png

▪Quickly insert number sequences

Taking this worksheet as an example, what should I do if I need to enter a numerical sequence in column A with one click?

First open the worksheet, click the "Members Only" drop-down menu above and click the "Smart Toolbox" - "Fill" button.

Select the cells where you want to add numbers, click the "Fill" button and select "Enter 123 Number Sequence", and the cell will quickly click The sequence is filled with Roman numerals. In the same way, you can add a Roman numeral sequence or a letter sequence by clicking the function directly to add the sequence.

智能工具箱-填充.gif

▪Quickly insert the current date

Take this person entry and exit registration form as an example. You need to quickly insert the current date in this column. How to do it quickly?

First open the worksheet, select a column of cells where you want to add the current date, and click the "Smart Toolbox" - "Fill" button.

Pull down and select "Enter the current date". At this time, a variety of date display formats will appear in the pop-up box on the right. Just select a suitable style to add. .

录制_2021_08_23_14_11_39_578.gif

▪Blank cell filling

Split the merged cells in the worksheet. Sometimes the copy will only be displayed in one of the cells. How to quickly fill multiple cells with the copy.

Select the cells to be filled, click "Fill"-"Fill blank cells", and select the value above in the pop-up box Click the OK button as usual, so that you can quickly fill the merged and split cells.

Of course, it is not limited to merging and splitting tables. You can also directly select cells.

智能工具箱-填充3.gif

The fill function in the smart toolbox and other quick functions are waiting for you to discover, go and try it.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/WPS-biao-ge-zhi-neng-gong-ju-xiang-zhi-neng-gong-ju-xiang-pi-liang-tian-chong.html