Hi,
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
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