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
 

Hi RajeevAsthana

Do you use Excel 2007 ?

You can do this before you delete
F5Special
Visible cells only

The shortcut is
Alt ;

--

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.