Sunday, November 20, 2011

How to Delete Redundant Cells in Excel


1. Right-click the Excel file you want to edit, and click 'Open With.' Click 'Microsoft Excel' in the list of programs.
2. Highlight all the cells you want to check for redundancy. You can highlight all cells at once by clicking the corner square in the upper-left corner of the spreadsheet.
3. Click the 'Data' tab and click the 'Remove Duplicates' button. A window opens prompting you for a list of columns on which you want to run the duplication utility.
4. Click the 'Select All' button if you want to check all columns. Otherwise, check each column you want to check.
5. Click 'OK' to remove the redundant cells. Excel returns a report of how many cells were deleted from the spreadsheet.

Blogger news