11/24/2023 0 Comments Delete duplicates in excel![]() 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 |