« Paste By Values Has a New Look, Try this! | 50+ Websites Give Excel Training's (on net) » |
Remove Particular Rows from the List
Learn Excel, Excel TipsHi there,
Today I have a nice trick to share with you. This trick shows How to remove particular rows which contains specific names or dates or anything that matters.?
I have a set of data which contains Excel Master School subscribers (not original names). If you want to remove the students whose access to utilize the course was ended (eg: say 6 months access to the view and download option). To do this we require a quick tip. Right?
...
A small demonstration which replicate the same:
HERE IS HOW WE CAN DO IT?
1. Select the cells
2. Click on CTRL + H (Find & Replace)
3. Type "Jeff" in place of Find
4. Keep Replace as empty
5. Click on "Find All"
6. Select all the items listed below the "find all" option
7. Click on OK
8. Right Click on the data set
9. Select and delete "Entire Row"
10. That's it. Magic Works!!!
DO YOU USE FIND ALL TRICK?
If you find anything to share with us, use this space to share your ideas and suggestions using our comments section.
If you find this helpful, please do share it on your social networking sites by clicking on the icons placed around the blog.
If you want to support me, REGISTER here for free. You will be receiving latest updates directly into your email.
SOME IMPORTANT LINKS:
SUGGEST your idea to Microsoft Excel Team
Thanks,
You must be logged in to see the comments. Log in now!
If you have no account yet, you can register now! (It only takes a few seconds)
Recent comments