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 ;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

delete only visible rows in filter mode 4
Auto-filter selection 1
Excel 07 - deleting filtered items 2
Macro/VB coding question 3
Delete only Filetered rows in excel 2007 not hidden rows or header 0
Autofilter functionality 3
Delete Filtered Rows in Excel 2007 7
Excel 2007 compatibility issue - speed between cells 2

Back
Top