When you have a lot of data to review in an Excel file it can be tedious finding duplicate worths. Today we will check out exactly how to quickly recognize replicate values with Conditional Formatting.
With the Excel record open emphasize the area of the paper to look for replicate entries.
On The Ribbon click under the Home Tab is selected.
In the Styles area click on Conditional Formatting Highlight Cells Rules Duplicate Values.
This opens the Duplicate Values dialog box where you can select how to format the cells with duplicate data.
Currently you will certainly have the ability to easily find the cells which contain the replicate data so you can change the worths or delete them.
This is a fast and simple pointer to help see to it crucial spreadsheets consist of proper info.