MS WORD2013/Excel2013. a giant table, how to search and find all cells containing the same text?
Go to solution
Solved by Master Disaster,
Select the range of cells you wish to test.
On Excel's Home tab, choose Conditional Formatting, Highlight Cells Rules, and then Duplicate Values.
Click OK within the Duplicate Values dialog box to identify the duplicate values.
Duplicate values in the list will now be identified.
That should highlight all cells containing duplicate values
-
Featured Topics
-
Topics
-
0
-
2
-
Niber ·
Posted in General Discussion1 -
GodAtum ·
Posted in General Discussion2 -
1
-
FALL1N ·
Posted in Phones and Tablets0 -
0
-
3
-
Familt ·
Posted in Troubleshooting4 -
Lurx0720 ·
Posted in Phones and Tablets3
-
-
play_circle_filled
Latest From ShortCircuit:
We've Never Unboxed a 3D Printer Like THIS before! - Micronics SLS 3D Printer
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now