How do I highlight duplicate rows?



How do I highlight duplicate rows?..

Answer / Jayant Srivastava

To highlight duplicate rows in Excel, follow these steps:
1. Select the range of cells you want to check for duplicates.
2. Go to "Conditional Formatting" in the Home tab.
3. Choose Highlight Cells Rules > Duplicate Values.
4. Set the fill color and other options as needed.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

What is the symbol for autosum in excel?

1 Answers  


How can I vary the width in the columns of a spreadsheet?

1 Answers  


How do I fix a name error in excel?

1 Answers  


Which is latest version of excel?

0 Answers  


How do I make a spreadsheet on my computer?

1 Answers  


How do you link excel to access?

1 Answers  


How do you combine cells in excel with commas?

1 Answers  


How do I create a formula for multiple cells in excel?

1 Answers  


How do I change conditional formatting in excel?

1 Answers  


How do you use the countif function in excel?

1 Answers  


Can you merge tabs in excel?

1 Answers  


How can I reduce my excel file size?

1 Answers  


Categories