I am filtering a large Excel spreadsheet. I want to remove all rows on the sheet that are not a part of the filter. I know I can copy the rows and paste them into another spreadsheet. But I would rather apply the change directly to the same spreadsheet.
How do I accomplish this?