Set Home| Set Favorite|

WPS Office Forum

 Forgot password?
 Register
Search
View: 91|Reply: 0

Highlighting cells containing duplicate values in Spreadsheets

[ Promote this link! ]
Post time: 2019-04-12 14:15:28
| Show all posts |!read_mode!
Everybody knows that Excel is a best tool for managing and sorting your data. Here I am sharing a simple tip to highlight cells which are containing duplicate values.

1) Select specific column or row which has values.
2) Go to conditional formatting option above.
3) Select highlight duplicate values option.

Ms excel is such a powerful tool that it can help you organize your whole company's data in such a way that everything comes handy on fingertips. Share your best tips so that they can help us too.
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Dark room|Mobile|Archiver|WPS Office   

2019-06-20 08:06 GMT+8 , !processed_in! 0.072373 !seconds!, 10 !queries! .

Powered by Discuz! X3.2

Release 20151208, © 2001-2019 Comsenz Inc.

MultiLingual version, Rev. 469, © 2009-2019 codersclub.org

!fastreply! To Top !return_list!