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.
- Select all your data
- Press CTRL+F and search for “John”
- 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
- Now poor John is history!
See this demo to understand:
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.
- Remove duplicate values from Excel [More ways to do it]
- Remove blank rows in your tables
- Extracting specific data using advanced filter
- Remove un-necessary portions form text values
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.
Do you want to be awesome in Excel?
Here is a smart way to become awesome in Excel. Just signup for my Excel newsletter. Every week you will receive an Excel tip, tutorial, template or example delivered to your inbox. What more, as a joining bonus, I am giving away a 25 page eBook containing 95 Excel tips & tricks. Please sign-up below:
Your email address is safe with us. Our policies
More awesome tips for you:
Leave a Reply
|Finding Conversion ratio using Pivot Table Calculated Items||Finding Nearby Zipcodes using Excel Formulas|