ExcelBanter - How do I delete rows based on a category?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I delete rows based on a category? (https://www.excelbanter.com/excel-discussion-misc-queries/253757-how-do-i-delete-rows-based-category.html)

Suzy

How do I delete rows based on a category?

I want to delete multiple rows based on a category from one of the columns. I
can categorize them and hide the unwanted rows, but I don't know how to
delete them.
PLEASE HELP!!!

Gary''s Student

How do I delete rows based on a category?

Dont hide the unwanted rows, hide the good rows.

With the unwanted rows visible you can just select them and delete them!
--
Gary''s Student - gsnu200909

"suzy" wrote:

I want to delete multiple rows based on a category from one of the columns. I
can categorize them and hide the unwanted rows, but I don't know how to
delete them.
PLEASE HELP!!!

All times are GMT +1. The time now is 06:03 AM.