Highlight the an area you want search or click on the highlight all button (CTRL A)
Click on the Home tab, then click on Conditional formatting, then Highlighted Cells Rules, then Duplicate Value.
Then click OK
Sunday, March 22, 2015
Find Duplicates In Excel
This was done in Excel version 2007
Highlight the an area you want search or click on the highlight all button (CTRL A)
Click on the Home tab, then click on Conditional formatting, then Highlighted Cells Rules, then Duplicate Value.
Highlight the an area you want search or click on the highlight all button (CTRL A)
Click on the Home tab, then click on Conditional formatting, then Highlighted Cells Rules, then Duplicate Value.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment