Delete rows with specific text without sorting

In this short video, you will see how rows with specific text can be deleted without sorting data. Here, we want to delete rows where Status is 'Inactive'.
The trick is to find all the rows with specific text, select all those cells using the Find functionality. Once selected, we can delete entire rows using the short cut key Ctrl + -.
Please let us know on which topic / challenge you want us to create video.
Thanks!

[@kevinkorenika2846]

Best tutorial ever! Quick, easy, simple and it actually does what the title says!

[@itmistic]

Thanks for the appreciation ! Glad that you liked it !

[@barrymonteiro8893]

This tutorial is exactly what I was looking for! Thank you!

[@itmistic]

Wow! Really happy that it helped 😊

[@thebhaskarjoshi]

Tutorial of all time.

[@itmistic]

Thanks 😊

[@atulbesra822]

A tremendous trick. A great time saver.👌

[@itmistic]

Happy to hear that!

[@HelaDixman]

Thanks bro, you're a live saver🤗

[@itmistic]

😊

[@rahmansozib144]

Thanks, it was very Helpful

[@itmistic]

Glad it helped!

[@davidruiz8794]

Amazing Tutorial!

[@itmistic]

Thanks! Good to know that you found it useful.

[@aoronnokhan3581]

Very helpful video Thank You

[@itmistic]

Glad it was helpful!

[@techandtravelz]

Thank you so much!

[@itmistic]

Most welcome!

[@abdallahmahmoud5068]

This is what i want you're awesome ❤

[@itmistic]

Happy for you 😊 Thanks!

[@slvrknight72]

Perfect !!! thanks !

[@itmistic]

Welcome!

[@ritviknayak9052]

THANK YOU!!!

[@itmistic]

You're welcome!

[@nilimfdi9926]

OMG Thank you 🙏🏻

[@itmistic]

You’re welcome 😊

[@yatri6352]

Thank you so much

[@itmistic]

Welcome!

[@al_amminn]

Thanks a lot!!

[@itmistic]

Pleasure 😊

[@kunalsharma2228]

Thanks it reduced stress from my mind

[@itmistic]

Most welcome 😊

[@Naveenxsmr]

YOU GAINED SUB BRO ❤ THANKS 💕

[@itmistic]

Thanks for subscribing Naveen 😊

[@investwithasad7]

jo chez puray internet p mjy nahe mil rahe the yahn mil gaye thanks alot buddy

[@itmistic]

Happy to know that it helped you !

[@funnyguydragon]

i can't thank you enough hope you are doing good in life

[@itmistic]

Welcome! Yes, doing good 😊 Thanks!

[@luciagregorioperez9375]

LOVE YAA! THANK YOU

[@itmistic]

Thanks for your love!

[@omairsearchwell8359]

Yeah this is a life saver

[@itmistic]

Glad that it helped you 😊

[@shariqsofi3432]

Very very helpful......

[@itmistic]

Glad that you found it very helpful 😊

[@asyrafhaziq4208]

THANKS SOO MUCH

[@itmistic]

Welcome!

[@farhatieqahrosli2506]

Thanks genius!

[@itmistic]

Most welcome!

[@cliktoview8750]

U R GENIUS

[@itmistic]

Glad that you liked it! Thanks ☺️

[@thefolcantv7054]

very nice job

[@itmistic]

Thank you appreciating !

[@michaelnobles3704]

Thank youuuuu

[@itmistic]

Pleasure!

[@arjunkarte5817]

Fabulous trick ❤❤

[@itmistic]

Glad that you liked it 😊

[@MuhammadUsman-wb8nf]

Thanks Boy :)

[@itmistic]

You're welcome!

[@slamvox]

cool trick

[@itmistic]

Thanks!

[@omarmeharab9166]

instead of deleting, can't we select those rows to take them out on another file? if that's possible then how should we do it?

[@itmistic]

Sorry, it is not possible using this technique. However, you can apply Advanced filter and copy visible rows to anywhere. If you are not sure how to do that, please let us know; we will try to create another video for that. Thanks!

[@omarmeharab9166]

yes that would be really awesome if there was a video on that. I have been searching for it. but couldn't find it anywhere. @@itmistic

[@itmistic]

Sure, we will make a video on it soon.

[@omarmeharab9166]

please do so. will be grateful@@itmistic

[@itmistic]

Sorry, we are facing some technical issues in the video software! Please drop a mail at [e-mail]; we will show through Zoom call. Thanks!

[@dudegaming7302]

I love u so much 😘.

[@itmistic]

Thanks !

[@pankajbusinessculture6331]

लेकिन जिस के base पर ROWS डिलीट की वो formula ही delete हो गया तो automatically कैसे wapis कैसे delete होगी rows

[@itmistic]

Sorry, couldn't understand! Please drop a mail at [e-mail] for live session to clear your doubt. Thanks!

[@missgreenwood805]

How to extract it?

[@itmistic]

You may use Advanced Filter to extract rows based on any criteria. Check the following videos: How to Copy Filtered Records to Another Sheet Using Advanced Filter in Excel: kzbin.info/www/bejne/oXjahH6nna5goKssi=K1q7mgvni5zufmEm Advance Filters in Excel - 10 Examples: kzbin.info/www/bejne/hITYf4Zogs9pqqs I hope it helps.

[@oppophonephone124]

Ok but how to delete different values,, This is same value 😂

[@itmistic]

Either repeat the process for each value, or use VBA 😊

[@RiskManagement-ex2nl]

Thanks, this works in the desktop version but can you do this in the browser version? 03JAN24

[@itmistic]

I just tried, but sorry, it doesn't work in the browser version! You can find and select all the occurrences but as soon as you close the Find dialog box, it selects a single cell !

[@markkozdroj9778]

THANK YOU!!!

[@itmistic]

Welcome!