Remove Duplicate Rows from a Table : Table Row Column « Table « Microsoft Office Excel 2007 Tutorial






Click a cell in the table. 
           Click the Design tab under Table Tools. 
           Click the Remove Duplicates button.
Click a cell in the table. Click the Design tab under Table Tools. Click the Remove Duplicates button.
Select the columns with duplicates. 
           You can click Select All or Unselect All.
Select the columns with duplicates. You can click Select All or Unselect All.
Click OK.
Click OK.








4.2.Table Row Column
4.2.1.Insert a Row or ColumnInsert a Row or Column
4.2.2.Select Rows and ColumnsSelect Rows and Columns
4.2.3.Delete Rows or Columns from a TableDelete Rows or Columns from a Table
4.2.4.Remove Duplicate Rows from a TableRemove Duplicate Rows from a Table