Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question
I think you'll probably have to do that in VBA. –  Lance Roberts Jun 1 '10 at 19:22
add comment

2 Answers

up vote 7 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.

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

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

share|improve this answer
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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