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

My color indicator for filtering is black - how do I get it back . 1
Excel 'hangs' when deleting a row 1
how to insert row or delete while the auto filter is turn on? 1
deleting rows--calculating formulas with each row as it goes? 1
How do you delete filtered rows in an autofiltered list. The row. 3
How do I show the results of filter? 1
filter and delete 1
Find & delete duplicated entries. 1

Top