Deleting filtered rows in Excel

[RajeevAsthana]

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.

 

[Ron de Bruin]

Hi RajeevAsthana

Do you use Excel 2007 ?

You can do this before you delete
F5>Special
Visible cells only

The shortcut is
Alt ;