Delete only Filetered rows in excel 2007 not hidden rows or header

Apr 8, 2014
Reaction score

I have recently joined the community, I just wanna share a knowledge.
I have faced the issue in Excel 2007 on deleting filtered rows,it was deleteing my hidden rows too which I didnt want to delete.

I tried folowing way it worked:
1. Keep the cursor on header cell eg, I wanted to filter by Product Name so I kept my cursor in Product Name Header.
2. Click on Data>Filter
3.Select Rows Number at Left most
4. Right Click> Delete Rows
Note: If only Delete option is displayed then it will delete hidden rows also, Try and follow steps again the option should be 'Delete Rows'

Please let me know if it worked
Gud Luck:thumb:


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