Delete Filtered Rows in Excel 2007

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 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


--

Regards,

Peo Sjoblom




"Moon" wrote in message
...
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!

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

"Peo Sjoblom" wrote in message
...
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


--

Regards,

Peo Sjoblom




"Moon" wrote in message
...
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!

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

On 27 sep, 04:36, Moon wrote:
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!

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, InsertTable then the autofilter is automatically
applied.
Filtering and deleting then behaves as normal, whether your active cell is
within the table or outside.

--
Regards
Roger Govier



"Moon" wrote in message
...
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!

Hi Moon

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Moon" wrote in message ...
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!

On Sep 27, 5:36 am, Moon wrote:
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.

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message oups.com...
On Sep 27, 5:36 am, Moon wrote:
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.