How do I delete only the unfiltered row?

L

Leo

Not sure is Microsoft remove or forgot to include the feature. I have
filtered my data in excel 2007 and want to delete the row shown out but it
just delete everything.
Previously in excel 2003, it will not delete those not shown in the filter
option and remain it until I unfilter it.
 
D

Dave Peterson

Deleting or modifying rows that are above and below a hidden row in a filtered
Excel 2007 worksheet also deletes or modifies the hidden row
http://support.microsoft.com/kb/928974/en-us

But if you want to be careful, you should be able to select your range, then hit
F5 and select visible cells only.

Watch what happens to the selection.

You should be able to see the difference by the marquee (dancing ants)
surrounding the selected areas.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem viewing back the "Unfiltered range" 4
paste filtered data in unfiltered list 0
How do I freeze the swimlane headers? 0
Delete Filtered Rows in Excel 2007 7
need to show unfiltered data on chart 5
"cannot shift objects off sheet" error 8
Macro help?: move row to other sheet when text is entered in cell 0
How do I remove the top half of a block interval? 1

Top