Hi,
For deleting rows which you have filtered (eg : rows having name ROYA in column Name) not the other rows.
I tried folowing way it worked:
1. Keep the cursor on header cell eg, I wanted to filter by Name so I kept my cursor in 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
Bookmarks