Select a cell inside the data which you want to remove duplicates from and go to the Data tab and click on the Remove Duplicates command.Įxcel will then select the entire set of data and open up the Remove Duplicates window. It’s so common, there’s a dedicated command to do it in the ribbon. Removing duplicate values in data is a very common task. Find And Remove Duplicate Values With The Remove Duplicates Command You should always be aware which version you want and what Excel is doing. The results from duplicates based on a single column vs the entire table can be very different. This results in even less values being considered duplicates. The second image highlights all the duplicates based on all columns in the table.The second image highlights all the duplicates based on the Make and Model of the car.The first image highlights all the duplicates based only on the Make of the car.In the above example, there is a simple set of data with 3 columns for the Make, Model and Year for a list of cars.
Find And Remove Duplicate Values Using VBAĭuplicate values happen when the same value or set of values appear in your data.įor a given set of data you can define duplicates in many different ways.Find And Remove Duplicate Values With Conditional Formatting.Find And Remove Duplicate Values Using A Formula.Find And Remove Duplicate Values With Power Query.Find And Remove Duplicate Values With A Pivot Table.Find And Remove Duplicate Values With Advanced Filters.Find And Remove Duplicate Values With The Remove Duplicates Command.On the top menu line, click Window and then click Freeze Panes.Select (click) the cell immediately below the row you want frozen, and immediately to the right of the column you want frozen.Make sure Row 1 and Column 1 display in the Excel window.Freezing Panes in Old Versions of Excelįollow these directions for freezing panes in Excel version 2003 and older. In older versions of Excel, open the worksheet, on the top menu line click Window, and click Unfreeze Panes.
#LATEST VERSION OF EXCEL HOW TO FREEZE COLUMN HEADER WINDOWS#
Just open the worksheet and in the Windows section of the ribbon's View tab, click Freeze Panes ▼ and click Unfreeze Panes as shown below. It's easy to unfreeze panes in an Excel worksheet. We've scrolled in both directions, but can still understand the data! Note: all rows above, and columns to the left, of the selected cell are frozen regardless of whether they contain headings or other data. Notice the heavier lines around the locked rows and columns. The image above shows our worksheet with the frozen panes, which we've highlighted in yellow.
Most large worksheets require row AND column panes be frozen. If we scroll both vertically and horizontally as shown below, the data becomes meaningless. Click Freeze First Column to keep Column A visible while scrolling left or right.