[Excel Tips] How to Remove all the cell data which contains same Data

Hi, 

• Select all your data
• Press CTRL+F and search for “<<DATA WHICH YOU ARE TRYING TO DELETE>>”
• Click on “Find all” button
• Now, select the first result.
• Scroll down, holding SHIFT key, select the last result. This will select all search results.
• Close the Find box.
• Press CTRL - (to delete cells)
• Select “Entire row”
• Click ok
• Job Done!

Courtesy: chandoo.org - 'Excel'lent Blog