how do i delete all non filtered rows in Excel [duplicate]

if i have an excel sheet and i filter by a certain column, how do i then delete all non visible rows?

Solution 1:

When you have all your filters selected you can highlight what remains and then click:

Excel 2007:

Home>Editing>Find & Select>Go to special...>Visible Cells Only

Excel 2003:

Edit>Go To...>Special...>Visible Cells Only

Copy and paste into a new sheet.

Solution 2:

Reverse filter on what you don't need and delete those rows. All that will be left are the rows you need - Excel 2007

Solution 3:

A nice, quick technique: use the Fill Color icon to fill all the cells in one of the columns you see. Then do a color filter on that column, and delete all the rows. You will be left only with the filtered rows.