Delete Filtered Rows in Excel 2007

[Guest]

When I need to delete some filtered rows, In excel 2003, I will filter the
items that need to delete follow by highlight all rows then select delete
rows will do.
However in excel 2007, the same step will delete the whole content even
though the unfiltered rows.

Pls help!

 

[Peo Sjoblom]

I wouldn't expect it to be any difference, but try this. After you have
highlighted all rows press F5, then special and select visible cells, press
enter or click OK and now try to delete to see if it works

 

[RobN]

Another Vs2007 problem, me thinks! It seems this version has a mind of its
own and doesn't behave the same for all.

I had the same problem happen when I tried deleting filtered data on my
computer at work, but at home it works fine. (same version, and in fact,
same Office Vs2007 CD)

Rob

 

[JB]

With VBA

Range("_FilterDataBase").Offset(1,
0).Resize(Range("_FilterDataBase"). _
Rows.Count - 1).SpecialCells(xlCellTypeVisible).Delete
Shift:=xlUp
ActiveSheet.ShowAllData

JB
http://boisgontierjacques.free.fr

 

[Roger Govier]

Hi

It works exactly the same as XL2003 for me, provided my active cell is
within the range of the list where the deletion is to occur.

If the active cell is outside of the list, then what you describe can occur.

If you create a Table, Insert>Table then the autofilter is automatically
applied.
Filtering and deleting then behaves as normal, whether your active cell is
within the table or outside.

 

[Ron de Bruin]

Hi Moon

Do you use AutoFilter or do you filter in a table in excel 2007

 

[propelledash]

When I need to delete some filtered rows, In excel 2003, I will filter the
items that need to delete follow by highlight all rows then select delete
rows will do.
However in excel 2007, the same step will delete the whole content even
though the unfiltered rows.

Pls help!

I have encountered the same major annoying &*#$!#!! problem in Excel
2007.

- I work on more than 40,000 rows of data.
- I setup a criteria to filter the data.
- Filter is applied which hides the rows that didn't meet my
criteria.
- I perform computations on the remaining rows.
- I remove the filter or aka, "show all" records.
- !@#$!!. All records were affected by the computation. Rows that
weren't intended to be updated were updated.
- Same procedure, I did it over and over. What's worse is, It will
work on the 1st try and fail on the 2nd. It will fail on the 1st, it
will work on the 2nd. !@#$ Annoying.

- Same process, I tried on Office 2000, 2003. And it works fine, 100%.
It DOESN'T affect the filtered/Hidden records.

- This is probably another bug. An addition to the 850 * 77.1 bug that
was just recently discovered. FYI, try that 850 * 77.1 on a calculator
vs Excel 2007 and compare the result.

 

[Ron de Bruin]

Do you use AutoFilter or do you filter in a table in excel 2007