Excel 2007 Tip – Highlight Duplicate Values
By JC
Kiadii, Internet Marketing for
Mortgage
Professionals
If you’ve worked with Excel 2007 for a little while, you’ve probably
noticed how much easier it is to delete duplicates.
What if you wanted to take a look at the duplicate values before you
deleted them?
This is also very easy.
Simply highlight the range of
cells you want to check for
duplicates.
Click Conditional Formatting
on the Home
tab.
Click New Rule.
Click the line that reads format
only unique or duplicate values.
Make sure duplicate
is selected under format all.
Click the Format
button to set your formats.
Click OK
until you are back on your Excel screen.
That’s it!
http://www.twitter.com/mortgageva
Don’t
miss the next post – Subscribe
to this blog
and get updates in your email.
JC
Kiadii, Mortgage Internet Marketing
Services . 770-469-7385. Are
you reaching out to the 87% of
new buyers who start their search online?
Our team provides results-driven
mortgage Internet marketing services.
Visit our website and sign up
for the More Closings
email newsletter to receive the report 6
Steps to More Referrals.
Loading tweets...