Delete rows with specific text without sorting in Excel #short

preview_player
Показать описание
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 + -.
Рекомендации по теме
join shbcf.ru