Deleting filtered rows in Excel

R

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.
 
R

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 ;
 
Top