Let’s say you have data like this.

Data Sample

There could be 2 possibilities; you want to delete data which are

  • Only “6” or
  • Which contain “6”

The basic idea is to find those particular cells, and delete the data in them.

Let’s take the 1st scenario

  • Only “6”
    1. Go to Find (Press Ctrl + F)
    2. In ‘Find what’, type 6
    3. Click on Options >>
    4. Tick on ‘Match entire cell contents’. This enables Excel to find cells only with 6 and nothing else, not even a space before or after
    5. Click ‘Find All’
    6. Click on 1 of the searches and press Ctrl + A (select all searches found)
    7. Go to the sheet and right-click on any 1 of the searched result. If you left-click, the selection (select all) will go away
    8. Now press Esc and then press Delete

You’re done!

Only 6

 

Now let’s understand the 2nd scenario

  • Which contain “6”
    1. The only difference here in that you do not tick on ‘Match entire cell contents’. This enables Excel to find all cells which contain “6”
    2. Repeat the same procedure as above

You’re done!

With 6

 

Enjoy Excel-ling!