-->

Wednesday, March 20, 2013

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

Posted by Sharath
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

0 comments:

Post a Comment