Delete Filtered Rows in Excel 2007


G

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

Advertisements

P

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
 
R

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
 
R

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

Advertisements

P

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.
- [email protected]#$!!. 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. [email protected]#$ 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.
 
Ad

Advertisements


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

Top