Wednesday, March 20, 2013

How to Find Delete Multiple Instances in Excel


1. Click the Windows 'Start' button and select 'All Programs.' Click 'Microsoft Office' followed by 'Microsoft Excel' to open the spreadsheet software.
2. Click the 'File' ribbon tab, then click 'Open.' Double-click the Excel spreadsheet file that contains the duplicate values.
3. Highlight all the cells you want to check for duplicates. Click the 'Data' ribbon tab at the top of the window. Click 'Delete Duplicates' to start the wizard.
4. Check the box for each column you want to check from the selection. If you want to check all columns, click 'Select All.'
5. Click 'OK' to run the duplicate checker. The window displays the number of duplicates found. Click 'OK' to delete the duplicate instances.

Blogger news