Once the range has been selected, select 'conditional formatting' from the home tab in the ribbon, then select "create new rule": There are some selection techniques that will speed up the process of selecting the right area available here. This can be a column or row, or an entire table of data. To make use of conditional formatting you must first select the range (area) of data you wish to apply the conditional formatting on. But it still has various uses for removing duplicates out of a single column. For example two persons with the same first name, but a different surname would be highlighted by this option. However, it's worth noting that individual data values may be duplicates without the whole row being a duplicate. This will use any formatting you select to overlay the data and show you any duplicates. Conditional FormattingĬonditional formatting can be used to highlight duplicates ready for manual removal. There are multiple ways of highlighting or removing duplicates from an Excel worksheet. AdviseU: Student Wellbeing Adviser Team.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |