Is there any easy way to check a spreadsheet for duplicates in Excel 2007?
- Yes, open up Excel 2007
- Click the Home tab
- Choose Conditional Formatting
- Highlight Cells Rules
- Click Duplicate Values
- Click OK
Excel will highlight the duplicates for you so that you can delete them / change them.
Posts
No comments:
Post a Comment