Ads 468x60px

Tuesday, March 19, 2013

How to remove all cells containing John (or anything else) [Quick tip]

How to remove all cells containing John (or anything else) [Quick tip]:
Here is an interesting question someone asked me recently,
If I have to delete all rows with “John” in it. Do you know how to do it? 
Well, it looks like they really hate John. But it is none of my business.
So lets go ahead and understand a dead-simple way to get rid of all cells with John or whoever else you fancy.
  1. Select all your data
  2. Press CTRL+F and search for “John”
  3. Click on “Find all” button
  4. Now, select the first result.
  5. Scroll down, holding SHIFT key, select the last result. This will select all search results.
  6. Close the Find box.
  7. Press CTRL - (to delete cells)
  8. Select “Entire row”
  9. Click ok
  10. Now poor John is history!
See this demo to understand:
How to delete all cells with a specific value in Excel?

More tutorials on removing stuff…

If you often find yourself with more data than you need & spend a lot of time deleting Johns from your data, then you will find below tutorials very useful.

PS: As I was traveling in last 2 weeks, I could not write often. Starting Monday, you will see your favorite awesome Excel tips regularly.

0 comments:

Post a Comment