how to print address labels from excel 2003

To quickly select all columns, click Select All.Under Columns, select one or more columns.In the Remove Duplicate dialog box, do one or more of the following:.On the Data tab, in the Data Tools group, click Remove Duplicates.Select the range of cells, or make sure that the active cell is in a table.Any other values outside the range of cells or table are not altered or moved.īecause you are permanently deleting data, it's a good idea to copy the original range of cells or table to another worksheet or workbook before removing duplicate values. When you remove duplicate values, only the values in the range of cells or table are affected. Method 3 of 5: remove duplicate values in Excel 2010 and later Step by step

The unique values from the selected range are copied to the new location.

Select the Unique records only check box, and click OK.

or click Collapse Button to temporarily hide the dialog box, select a cell on the worksheet, and then press Expand Button.

In the Copy to box, enter a cell reference.

To copy the results of the filter to another location, do the following:.

To filter the range of cells or table in place, click Filter the list, in-place.

In the Advanced Filter dialog box, do one of the following:.

On the Data tab, in the Sort & Filter group, click Advanced.

Select the range of cells, or make sure the active cell is in a table.

Method 2 of 5: Advanced Filter for unique values Step by step Note: changing the range address ( $A$2:$A$16) to suit your needs. Method 1 of 5: extract unique values using Excel formula Formulaįor example: range A2:A16 contains duplicate values, an array formula in B2:B16 extracts an unique distinct list from column range A1:A16.

Are you looking to get unique values (or remove duplicate values) in Excel, and as quick as possible? Have no fear - doing so is easy! Excel formula, Advanced Filter, Remove Duplicates command, PivotTable, and VBA as ways of extract unique values quick.

How to print address labels from excel 2003