up vote 1 down vote favorite
share [g+] share [fb]

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

link|improve this question
95% accept rate
1  
I think you'll probably have to do that in VBA. – Lance Roberts Jun 1 '10 at 19:22
feedback

1 Answer

up vote 4 down vote accepted

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.

link|improve this answer
1  
Ctrl+G is the hotkey for "Go to..." in excel 2003 – Dan Jun 1 '10 at 20:26
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.