How do I delete rows based on a category?

S

suzy

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!!!
 
G

Gary''s Student

Dont hide the unwanted rows, hide the good rows.

With the unwanted rows visible you can just select them and delete them!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I cannot delete the extra rows or columns in Excel 2007 2
Excel - How do I delete filtered out rows? 2
how do i combine excel worksheets 1
Delete rows based upon a range of times 5
Selecting rows based on a value 3
Delete Rows Based on highlighted Color 7
Rank based on category 3
How to filter rows data based on background color of individual cells 1

Top