Problems deleting filtered rows

[Ron de Bruin]

hi Rodrigo

You are not the only one
I only see this problem myself when I filter in a table in 2007 but not with Autofilter

You can do this (part of one of my webpages)

1) Select the whole data range or if you not have empty rows/columns in the range
you can use Ctrl * to select all data or use F5>Special>Current region>OK with
one cell selected in the data range.
If it copy all the data (there are a few reports of 2007 users) use also the shortcut
Alt ; or F5>Special>Visible cells only>OK to select only the Visible cells.

 

[Rodrigo Alonso]

I usually use the Filter function when dealing with data in Excel.
But I cannot figure out why SOMETIMES the hidden data (i.e. after being
filtered) is also afected by changes to filtered data. For example, if I use
Filter to find blanks cells and then delete the filtered rows also hidden
rows (with data) are deleted.
I am using Excel 2007, and I never had this problem before with earlier
versions of Excel.
I will appreciate any help regarding this problem
Thanks.

 

[scott]

I have had the same issue and used what Ron suggests going to visible
cells only.
If it is possible, without messing up your sheet, to sort all of the
blank cells into a group which you can delete that is another way to
remove them.
ScottD

 

[Rodrigo Alonso]

Hello Ron:
Thanks for your help.
The problem is that it seems to be a random problem, because when I was
testing your advice on the spreadsheet with problems it started working
fine.
In any case, I will have your advice at hand for the next time I run into
the problem.
It also allow me to learn about your webpage.
Thanks again.
Regards,
Rodrigo Alonso


P.S. But certainly it is a very annoying situation not to know if the
program works or not.

 

[Rodrigo Alonso]

Thanks Scott for your help.
As I also answer to Ron, the problem is that this is a problem that appears
randomly, and makes it very annoying when you work with a lot of data.
Since the problem happens when a filtered is used, it is not only the risk
of unknowingly deleting a hidden row, but also changing their value when you
think only are doing this only to visible cells selected.
Hopefuly a fix to the problem will be found soon.
Regards,
Rodrigo Alonso

 

[Ron de Bruin]

The problem is that it seems to be a random problem, because when I was

testing your advice on the spreadsheet with problems it started working
fine.

That's the problem

When you can reproduce it every time it is easier to create a bug report.

 

[creepyd666]

I usually use the Filter function when dealing with data in Excel.
But I cannot figure out why SOMETIMES the hidden data (i.e. after being
filtered) is also afected by changes to filtered data. For example, if I use
Filter to find blanks cells and then delete the filtered rows also hidden
rows (with data) are deleted.
I am using Excel 2007, and I never had this problem before with earlier
versions of Excel.
I will appreciate any help regarding this problem
Thanks.

Very old problem, but I know the answer..
This is caused when you select the header row and turn on the autofilter (something you had to do in Excel 2003 I believe) - If oyu turn on autofilter with the first row selected you will have this problem.
Turn on autofilter by just selecting a single cell anywhere in the table and you should be able to delete from filtered data without it deleting rows in between.