How do I Remove Rows that match a criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have data that I am filtering based on State. I want to remove all the rows
that have 'TX' in State Column. I used data filtering and from the dropdown,
selected 'TX'. When I get the filtered data, I select the rows and 'delete'.
The problem is, it deletes every other row as well. I migrated from exel 2003
to 2007 and see a 'bug' where 2007 can not remove the selected rows only...
Quite frustrating. Is there any way to achieve this without writing any macro?

Thanks
 
I have not yet installed my copy of 2007 yet but it serves you right for
trying to remove TX.
 
Hi

You are quite correct. The behaviour is not the same as with
Autofilter>Select>Delete.
However, if you click on a cell within your data and choose Insert>Table
then use the dropdown on the filter created on your state header to
select TX.
Now, mark the rows, right click and the options will be Delete Rows (as
opposed to Delete) and your rows with TX will disappear (sorry Don<bg>).
Click on the Filter and choose Show All and the remainder of the data
will be there.
 
Back
Top