Let’s say you have data like this.
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”
- Go to Find (Press Ctrl + F)
- In ‘Find what’, type 6
- Click on Options >>
- 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
- Click ‘Find All’
- Click on 1 of the searches and press Ctrl + A (select all searches found)
- 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
- Now press Esc and then press Delete
You’re done!
Now let’s understand the 2nd scenario
- Which contain “6”
- 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”
- Repeat the same procedure as above
You’re done!
Enjoy Excel-ling!