It will automatically have your column headers, select the columns of which you want to remove the duplicate values. You can also use the shortcut ALT + A + MĪfter clicking on remove duplicates a dialog box shall appear of remove duplicates. To remove the duplicates, select a random cell and select the option of Remove Duplicates from the data tab in the ribbon. We shall use the same example as above for learning removal of duplicates. In our case, we select ‘Light Red Fill with Dark Red Text’.Ĭlick on OK and you shall see that the duplicate names have been highlighted in red color. You shall see a duplicate values dialog box, wherein you can select your formatting option. Select the first option ‘Highlight Cells Rules’ and the sub-option as ‘Duplicate Values.’ When you click on the dropdown of conditional formatting, you shall receive various options. Alternatively, you can also use shortcut key: Alt + H + L. So first we shall select the Name column (A1:A15).Ĭlick on the conditional formatting option available at the right hand side of the home tab. In our example below, we want to find if any name has been repeated.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |