Deleting filtered rows in Excel

  • Thread starter Thread starter RajeevAsthana
  • Start date Start date
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.
 
Hi RajeevAsthana

Do you use Excel 2007 ?

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

The shortcut is
Alt ;
 
Back
Top