Online Computer Tips Home
Home All Tips OCT Newsletter Free Tutorials Tech News Resources

Home > All Tips > Microsoft Office Tips

Finding Duplicate Cell Values in Excel

If you are a serious Excel user and have huge spreadsheets with a lot of data in them then managing your data can be a real task. If you need to worry about not having duplicate information in your spreadsheet then you can be in for some real time consuming work if you have to find duplicate values manually.

For those who use Excel to store multiple entries in the same columns you may have wanted to be able to remove duplicates in your columns without having to sort through them manually.

Excel makes that easy by allowing to format the cells using a conditional format which will highlight the duplicate cells so you can remove the duplicates. It can also be used to highlight unique values. Be aware that you cannot conditionally format fields in the Values area of a PivotTable report by unique or duplicate values.

Here are the steps to highlight your duplicate cells:

1. Select one or more cells in your table.

2. On the Home tab, in the Style section, click the down arrow next to Conditional Formatting, and click Highlight Cells Rules.

3. Select Duplicate Values from the list.

4. Choose the values that you want to use, either duplicate or unique and then select a format.

Now all the duplicate cells will be highlighted with the color you chose in step 4 making it easy to find and remove them.

Check out our video showing this process step by step.

 

 

Related Tips:
Microsoft Excel Tips
Having all your Excel workbooks open on the taskbar
Not Enough Memory Message When You Start Word or Excel 2000
Online Office 2003 and 2007 Demos
Office 2007 Service Pack 1
Office Tips and Tricks
Microsoft Office 2007 Compatibility Pack
Microsoft Office 2007 Overview
Change Your Default Open and Save Location For Office 2007 and 2010 Programs
How to Turn Off Protected View in Office 2010

 

BROWSE PC HELP INFORMATION
Computer Categories:
 - PC Troubleshooting
 - Networking
 - Windows
 - Microsoft Office
 - Spyware
 - Virus
 - Hardware
 - Software
Learn More:
 - Computer Tutorials
 - Video Tutorials

 - Networking Terms
 - Hardware Terms
 - Virus Terms

Visitor Questions:
 - Free Tech Help
 - Q & A Archive
 - Common Questions
OCT Newsletter
OCT Tech Blog
JOIN US ON GOOGLE+
JOIN US ON FACEBOOK
FOLLOW US ON TWITTER
Get insights into the computer industry and regular updates on our site. Click Here
 
CHECK US OUT ON YOUTUBE

New tech tip videos posted on a regular basis. Subscribe today! Click Here

Back To The Top

Copyright © 2005-2015 Online Computer Tips.com
HOME | ALL TIPS | COMPUTER TUTORIALS | TECH NEWS | RESOURCES | ADVERTISING | ABOUT US | PRIVACY POLICY
Home All Tips OCT Newsletter Free Tutorials Tech News Resources