- Graphic and text skills
The "Smart Toolbox" of WPS Spreadsheet contains 60 efficient small functions to help you work efficiently and easily without overtime.
First, click the "Member Exclusive" tab-"Smart Toolbox" button to open the "Smart Toolbox" function tab.
■ Remove spaces
How to delete spaces or blank characters in the table?
Spaces refer to spaces between characters in a cell. If you want to delete them in batches, you can use the "Delete Spaces" function in the "Smart Toolbox".
Taking this table as an example, there are many different cell spaces in the table. How should we delete them in batches?
First, select the entire worksheet, click the "Smart Toolbox" above, select the "Delete" button, and click the "Delete Spaces" button.
Select which type of blank cells you want to delete. When deleting, the blank cells in the worksheet will be automatically marked in the pop-up window.
■ Delete hyperlink
When a hyperlink inserted in a file is deleted by directly clicking on the cell, sometimes it will automatically jump to the web page. How to quickly delete the hyperlink?
First, select the cells where the hyperlink needs to be deleted, click the "Delete" button and select "Delete Hyperlink".
Click the "OK" button in the pop-up box and the hyperlink in the cell will be deleted.
■ Clear 0 value
It is troublesome to delete products with 0 inventory in the cells one by one. The deletion function of the smart toolbox can help you delete them quickly.
Click the "Delete" button and select "Clear 0 Values". A pop-up window will automatically prompt how many 0 values there are. Click the "OK" button.
There are many other functions in the deletion function in the smart toolbox, so go and try them out.
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-ji-qiao-li-yong-zhi-neng-gong-ju-xiang-gao-xiao-pi-liang-shan-chu.html
评论列表(196条)
测试