I have not yet installed my copy of 2007 yet but it serves you right for
trying to remove TX.
--
Don Guillett
SalesAid Software

"Mahesh" wrote in message
...
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