Deleting filtered rows in Excel
 

Hi,

While I used AutoFilter to filter out few rows and tried to delete these
rows, I noticed that it has deleted other rows also which were not displayed
in the filtered rows.

Is it the right behaviors?

Any help is appreciated.

Thanks
Rajeev.

Deleting filtered rows in Excel
 

See my reply in this thread

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"RajeevAsthana" wrote in message
...
Hi,

While I used AutoFilter to filter out few rows and tried to delete these
rows, I noticed that it has deleted other rows also which were not displayed
in the filtered rows.

Is it the right behaviors?

Any help is appreciated.

Thanks
Rajeev.