How to find and remove duplicates in Excel. Filter for unique values in large or small datasets to clean up your worksheets and workbooks.

You can use the Cut command or Copy command to move or copy selected cells, rows, and columns, but you can also move or copy them by using the mouse. By default, Excel displays …

When duplicates are removed, the first occurrence of the value in the list is kept, but other identical values are deleted. Because you are permanently deleting data, it's a good idea to …

Because you are permanently deleting data, it's a good idea to copy the original range of cells or table to another sheet or workbook before removing duplicate values.

Repeating item and field labels in a PivotTable visually groups rows or columns together to make the data easier to scan. For example, use repeating labels when subtotals are turned off or …

When an Excel worksheet spans more than one page, you can print row and column headings (also known as headers or labels) on every page.

If some cells, rows, or columns on a worksheet do not appear, you have the option of copying all cells—or only the visible cells.

If you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. With it, you can quickly switch data from columns to rows, or vice versa.

When shaping data, a common task is to keep or remove duplicate rows. The results are based on which columns you select as the comparison to determine duplicate values is based on the …

Select an entire row or column and on the contextual menu, tap Copy. Select another row of column where you want to paste and on the contextual menu, tap Paste.