:WPS table data comparison skills: how to quickly mark the only data in the table-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. WPS table data comparison skills: how to quickly mark the only data in the table

WPS table data comparison skills: how to quickly mark the only data in the table

Author: daogeziyuan • • Table skills • Views 752
  • Image and text skills

In the supermarket's purchase bill for the week, Want to quickly mark the products that have only been purchased once? What about quick tagging?


分界线.png


1. MarkingSingle areaUnique data

First click "Data" - "Data Comparison", drop down and click "Mark Unique Data" . Select the list area in the Mark Unique Data edit box, In comparison mode Check the name class, Select the color of the annotated data among the specified colors, Single Click the "OK Mark" button.


标记唯一数据1.gif


2. Mark the unique data of two areas and two worksheets, SupermarketA new batch of products were purchased on the 4th,but the management staff made a mistake in the data.

Now I want to quickly mark which products have been purchased. How do I do this? Click "Two Regions" in the Mark Unique Data edit box, in the region Select the detailed list of purchased goods on the 1st day in 1, areaSelect the detailed list of goods purchased on the 4th in the 2 box. Select the specified color, click the "OK Annotation" button.


标记唯一数据2.gif


Similarly, if there are two different worksheets,Click "Two Worksheets" to check Worksheet that needs to label dataor click "Select File" to add a file

Click the "OK Mark" button


标记唯一数据3.gif


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-shu-ju-dui-bi-ji-qiao-ru-he-kuai-su-biao-ji-biao-ge-zhong-de-wei-yi-shu-ju.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu lx~沈绝 Columnist
48 196
single-end

Related Suggestion