Hey, guys, Many people want how to delete duplicates in excel so, in this article, I will tell you how to remove duplicates in excel.
Learn now and easily how to remove duplicate values from a Microsoft Excel spreadsheet. Method 1 of 2: Remove Duplicates Double-click the desired Excel file. Wait for the spreadsheet to learn.
Content:
Steps
Learn now and easily how to remove duplicate values from a Microsoft Excel spreadsheet.
Steps
Method 1 of 2: Removing duplicates
Double-click the desired Excel file. Wait for the spreadsheet to load in the program.
If you want, select the document in the "Recent" section of the "Home Page" immediately after opening Excel.
Select a data group. Start by clicking on the first cube, hold down the key ⇧ Shift finally click on the last date. If you want How to Freeze Rows and Columns in Excel.
In case you want to select data in several columns, click on the data above and on the left, hold the button ⇧ Shift-click the one on the right, right, and down.
Open the Data tab. It is easy to find, it is located in the center of the upper lane of Excel, between "Formula" and "Review".
Select the duplicate removal tool. This is one of the tools in the "Data Tools" section of the Cubes tab. Note that a window with options for selecting and deselecting columns will appear.
Make sure all the columns you want are selected. Columns will be named "Column A", "Column B", etc. and next to each will be a box. Clear the check box to deselect the appropriate column.
By default, Excel will also select the columns next to the ones you selected.
click inside Select All if you want to select all the listed columns.
OK. Wait until Excel removes any data that may have been duplicated in the spreadsheet.
It may not be the first duplicate. In that case, try again, but by selecting a column per column.
Method 2 of 2: Marking Duplicates
Double-click the document you want to open. Wait for Excel to load it. Unlike the Remove Duplicates tool, the Conditional Formatting tool does not delete data.
If you want, select the document in the "Recent" section of the "Home Page" immediately after opening Excel.
Click on the data at the far left and above the data group. This will choose you.
- They do not include column headings in the selection ("Name", "Title", "City", etc.).
- To select only one-row data, start by clicking on the far left data.
- To select only one column, start by clicking on the data at the top.
Hold the key ⇧ Shift-click on the data to the right and below the group. In this way, all cells between the first and last selected cells will be selected. If you want Excel for Beginners Free.
To finish selecting only one line, click on the far right data of the same line.
To complete the column selection, click on the data below the same column.
Open the conditional formatting tool menu. The button is located in the "Styles" section of the "Home" tab.
If you don't find the tool, open the Home tab, which is located in the top bar of Excel, and look a little to the right of its central part.
Select the Mark cell rules option. The submenu will appear to the right of the current menu.
Select Duplicate Values. This is the last option in the submenu. Adjust the desired settings in the dialog box that opens and click OK. All duplicate values will be automatically marked in the selected sample.
You may also visit here,