Creating a spreadsheet in Excel 2007 means multiple cells, rows and columns. Data values and data sets can often be duplicated in the columns and rows. Locating duplicate data records in a spreadsheet is a priority when accurate results are expected. Excel 2007 provides a solution for this by using a colour code to check your spreadsheet for duplicate records.
- Skill level:
Other People Are Reading
Click the "Home" tab.
Click "Conditional Formatting" in the "Styles" box in the Office ribbon.
Select "Highlight Cell Rules" and then "Duplicate Values." The "Duplicate Values" box will open.
Select "Duplicate" from the drop-down box and choose the colour for the highlighted duplicates. Click "OK." Excel will show all duplicate values in the colour that was chosen.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for