Wednesday, March 20, 2013

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

Posted by Sharath Chandra

  • 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: - 'Excel'lent Blog