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

A

Anupma

Joined
Apr 8, 2014
Messages
2
Reaction score
0
Hi,:wave:

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

Similar Threads

delete only visible rows in filter mode 4
Delete Filtered Rows in Excel 2007 7
Excel 2007 overwriting Hidden Rows 1
Unable to delete rows for only filtered results 4
I cannot delete the extra rows or columns in Excel 2007 2
Formula or Code to keep Hidden Rows Hidden 6
Excel 2007 - Cannot Delete or Insert Rows 1
Excel 2007: Delete Duplicates 2

Top