TABLE OF CONTENTS
Get started

Highlight Duplicates in Excel

Learn how to highlight duplicates in Excel.

5 minute read
Highlighting Duplicates in Excel

To highlight duplicates in Excel, the first step is to select the data range. Depending on your needs, you can search for duplicates in a single column, multiple columns, or the entire table. 

With your chosen data range, you can now proceed to:

  1. Go to the Home tab on the ribbon.
  2. Click on Conditional Formatting in the Styles Group.
Conditional Formatting
  1. Select "Highlight Cells Rules" from the dropdown menu.
Highlight cell rules
  1. Choose "Duplicate Values" from the submenu.
Duplicate values.
  1. In the dialog box, select "Duplicate" and choose your preferred formatting options. The “light red fill with dark red text” is a good option to make your duplicate values stand out in your dataset. Once specified, click on OK to confirm your choices.
Duplicate.

You should now find all of your duplicate values highlighted with the formatting method you chose.

If you initially pick a single column, like the "Team" column in the dataset below, Excel will highlight any duplicate values within that specific column.

Example 1.

If you select multiple columns, such as "Team", "Job Title" and "Reason for Leaving" Excel will identify duplicate values within all of these chosen columns.

Example 2.


Reviewing these outcomes will facilitate the identification and management of duplicate values in your Excel worksheet. This helps in maintaining data accuracy and streamlining data analysis tasks efficiently. The highlighted duplicates serve as visual aids for decision-making and taking appropriate actions to ensure data integrity.

Additional Resources

If you found this article valuable, explore our Excel for Business & Finance Course. It equips students with the technical skills essential for success in competitive finance and investment positions. Enroll in this course to become a part of our community of students who have secured positions at prestigious companies such as Goldman Sachs, Amazon, Bloomberg, and many others!

Other Articles You Might Find Helpful

‍

Introduction

Building a cash flow statement from scratch using a company income statement and balance sheet is one of the most fundamental finance exercises commonly used to test interns and full-time professionals at elite level finance firms.

Test hyperlink

Image caption goes here
Sample Image Insertion
Dolor enim eu tortor urna sed duis nulla. Aliquam vestibulum, nulla odio nisl vitae. In aliquet pellentesque aenean hac vestibulum turpis mi bibendum diam. Tempor integer aliquam in vitae malesuada fringilla.

Elit nisi in eleifend sed nisi. Pulvinar at orci, proin imperdiet commodo consectetur convallis risus. Sed condimentum enim dignissim adipiscing faucibus consequat, urna. Viverra purus et erat auctor aliquam. Risus, volutpat vulputate posuere purus sit congue convallis aliquet. Arcu id augue ut feugiat donec porttitor neque. Mauris, neque ultricies eu vestibulum, bibendum quam lorem id. Dolor lacus, eget nunc lectus in tellus, pharetra, porttitor.

  • Test Bullet List 1
  • Test Bullet List 2
  • Test Bullet List 3
"Ipsum sit mattis nulla quam nulla. Gravida id gravida ac enim mauris id. Non pellentesque congue eget consectetur turpis. Sapien, dictum molestie sem tempor. Diam elit, orci, tincidunt aenean tempus."

Tristique odio senectus nam posuere ornare leo metus, ultricies. Blandit duis ultricies vulputate morbi feugiat cras placerat elit. Aliquam tellus lorem sed ac. Montes, sed mattis pellentesque suscipit accumsan. Cursus viverra aenean magna risus elementum faucibus molestie pellentesque. Arcu ultricies sed mauris vestibulum.

‍

Conclusion

Morbi sed imperdiet in ipsum, adipiscing elit dui lectus. Tellus id scelerisque est ultricies ultricies. Duis est sit sed leo nisl, blandit elit sagittis. Quisque tristique consequat quam sed. Nisl at scelerisque amet nulla purus habitasse.

Nunc sed faucibus bibendum feugiat sed interdum. Ipsum egestas condimentum mi massa. In tincidunt pharetra consectetur sed duis facilisis metus. Etiam egestas in nec sed et. Quis lobortis at sit dictum eget nibh tortor commodo cursus.

Odio felis sagittis, morbi feugiat tortor vitae feugiat fusce aliquet. Nam elementum urna nisi aliquet erat dolor enim. Ornare id morbi eget ipsum. Aliquam senectus neque ut id eget consectetur dictum. Donec posuere pharetra odio consequat scelerisque et, nunc tortor.
Nulla adipiscing erat a erat. Condimentum lorem posuere gravida enim posuere cursus diam.

Kenji Farre
Kenji Farre
Senior Instructor

Ready to Level Up Your Career?

Learn the practical skills used at Fortune 500 companies across the globe.

Get started